My Oracle Support Banner

Accounting not Created Correctly for Foreign Currency Credit Memo Applications in Cash Basis (Doc ID 2857002.1)

Last updated on MARCH 24, 2025

Applies to:

Oracle Receivables - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

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

  1. Create Invoice in foreign currency and save
  2. Create On Account CM in foreign currency and save
  3. Apply the CM to the Invoice via: Action > Application
  4. 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

XLA_AE_HEADERS:

AE_HEADER_ID     PRODUCT_RULE_CODE
2611721             AR_DEFAULT_CASH

 

XLA_AE_LINES:

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.

Changes

 None

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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