Accounting not Created Correctly for Foreign Currency Credit Memo Applications in Cash Basis
(Doc ID 2857002.1)
Last updated on APRIL 14, 2022
Applies to:Oracle Receivables - Version 12.2.9 and later
Information in this document applies to any platform.
When using Cash Basis for credit memo application with foreign currency, the accounting is not created correctly in XLA.
Steps to reproduce the issue:
Navigation: Receivables Responsibility > Transactions > Transactions
- Create Invoice in foreign currency and save
- Create On Account CM in foreign currency and save
- Apply the CM to the Invoice via: Action > Application
- Run Create Accounting
The transaction would not post. The below error is found in the Subledger Exception Report:
There is no entered amount for the subledger journal entry line(...)
The source assigned to the accounting attribute Entered Amount has no value for extract line number(...)
To verify if you are facing this issue, it is recommended to generate the Transaction Analyzer and check the following:
a) The Transaction Analyzer may show the following error message in XLA:
Entered Amount and Accounted Amount are Not on Same Side
b) The Transaction Analyzer shows NULL value in the XLA_LINES table for the fields ENTERED_DR and ENTERED_CR that correspond to the Credit Memo Applications.
Below is an example of how the data may looks like in the Transaction Analyzer:
- The table XLA_AE_HEADERS shows that Cash Basis is used (i.e.: AR_DEFAULT_CASH)
- ENTERED_DR and ENTERED_CR fields have NULL value in XLA_AE_LINES table
AE_HEADER_ID ACCOUNTING_CLASS_CODE ENTERED_DR ENTERED_CR ACCOUNTED_DR ACCOUNTED_CR
2611721 REVENUE NULL NULL NULL 380
2611721 REVENUE NULL NULL 400 NULL
Due to this data corruption, the Credit Memo cannot get processed.
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
|1. Bug Summary|
|2. Fixed Files|
|3. Recommended Patches|
|4. Solution Steps|
|Still Have Questions?|