R12 Credit Memos Are Failing Create Accounting with error 'The account on the gain or loss line is invalid.' (Doc ID 565135.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

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

Symptoms

Running Create Accounting and there are credit memos failing with error:

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.

When you view the credit memos the data seems to be in balance with the gain/loss account.  Also the gain/loss account is a valid account, but still the error occurs.

There is an alternate error that you might get on this issue and that is during Jounral Import you might get an EC12 error. 

Data will show in:
XLA_AE_LINES
         accounting_class_code = EXCHANGE_GAIN_LOSS
XLA_DISTRIBUTION_LINKS
          accounting_line_code = CM_EXCH_GAIN_LOSS

 

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