CURR_ROUND Incorrectly Generated For Functional Receipts (Doc ID 1064975.1)

Last updated on DECEMBER 02, 2014

Applies to:

Oracle Receivables - Version: 12.0.0 to 12.0.7 - Release: 12.0 to 12.0
Oracle Receivables - Version: 12.0.0 to 12.0.7   [Release: 12.0 to 12.0]
Information in this document applies to any platform.
EXECUTABLE:XLAACCPB - Create Accounting
EXECUTABLE:ARACCPB - Submit Accounting

Symptoms

Creating a Receipt and Invoice in functional currency produces an unnecessary CURR_ROUND distribution. This CURR_ROUND distribution causes an unbalanced journal entry which fails to post.

The following shows a sample of what the Receipt data looks like:

AR_RECEIVABLE_APPLICATIONS_ALL:
STATUS     ACCTD_AMOUNT_APPLIED_FROM    ACCTD_AMOUNT_APPLIED_TO
APP        598463.63                    598463.64

The penny difference between ACCTD_AMOUNT_APPLIED_FROM and ACCTD_AMOUNT_APPLIED_TO causes a CURR_ROUND row to be generated.

AR_DISTRIBUTIONS_ALL:
SOURCE_TYPE     CCID       ACCTD_AMOUNT_DR      ACCTD_AMOUNT_CR
CURR_ROUND      2404       0.01                 ~


This corruption is also found in XLA_AE_LINES causes Create Accounting process to fail:

XLA_AE_LINES:
ACCOUNTING_CLASS_CODE      ACCOUNTED_DR      ACCOUNTED_CR
EXCHANGE_GAIN_LOSS         ~                 0.01



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms