AR_S_00040 Receipts Workbench Issue: Datafix: Miscellaneous Receipt Exchange CCID = -1 In xla_ae_lines Table For Secondary Ledger (Doc ID 2044111.1)

Last updated on DECEMBER 10, 2024

Applies to:

Symptoms

User is not able to post MISC receipts in Foreign currency to GL.

Create Accounting fails with errors:

Line Error Number Error Message
1 0 The account on the gain or loss line is invalid. If you have a gain/loss
journal line type defined, please verify the account derivation rule attached
to it on the journal line definition.  If not, verify the value of the source
mapped to the accounting attributes Exchange Gain Account and Exchange Loss
Account.

1 95314 The entered amount and accounted amount for line 1 are not on the
same side.
Please inform your system administrator or support representative that: The
source assigned to the accounting attribute entered amount is not consistent
with the source assigned to the accounting attribute accounted amount or the
supplied conversion rate is invalid.

ANALYSIS
=========
Customer is posting for Primary ledger and Secondary/Reporting ledger.
Secondary/Reporting ledger accounting is populated by SLA .
The CCID is populated as -1 for Secondary/Reporting ledger data.
Hence the receipt is not getting accounted to SLA and GL.

The Receipt has been multiple times rates adjusted the receipt which is an extremely corner case and odd usage.

currency_conversion_rate is not correctly populated in AR_DISTRIBUTIONS_ALL for the receipts created in foreign currency.

Fix Approach
============
Currency_conversion_rate has to be correctly populated in AR_DISTRIBUTIONS_ALL  for MISC receipts  

Cause

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