My Oracle Support Banner

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 FEBRUARY 12, 2019

Applies to:

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


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:
         accounting_class_code = EXCHANGE_GAIN_LOSS
          accounting_line_code = CM_EXCH_GAIN_LOSS





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

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