My Oracle Support Banner

CURR_ROUND Incorrectly Generated For Functional Receipts (Doc ID 1064975.1)

Last updated on DECEMBER 13, 2017

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution
  References

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