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 MAY 20, 2024
Applies to:
Oracle Receivables - Version 12 and later Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!