Upgraded Receipts Fail Due to CURRENCY_CODE = XXX in XLA_AE_LINES Table (Doc ID 1987510.1)

Last updated on MARCH 11, 2015

Applies to:

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

Symptoms

On : 12.1.3 version, Subledger Accounting Uptake for Receivables

There are upgraded Receipts that have a CURRENCY_CODE for the Exchange Gain/Loss Account in XLA_AE_LINES showing as XXX.

This is a result of the Exchange Gain/Loss in the AR_DISTRIBUTIONS showing a NULL value.

The XXX currency in XLA_AE_LINES is causing an error in the Journal Import, showing error EC08:

ERROR
-----------------------
EU02 This journal entry is unbalanced and suspense posting is not allowed in this ledger.
EC08 Invalid currency code.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms