CURR_ROUND Incorrectly Generated For Functional Receipts (Doc ID 1064975.1)

Last updated on OCTOBER 25, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.