My Oracle Support Banner

CURR_ROUND Incorrectly Generated For Functional Receipts (Doc ID 1064975.1)

Last updated on APRIL 22, 2019

Applies to:

Oracle Receivables - Version 12.0.0 to 12.0.7 [Release 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



Changes

 

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
Changes
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.