R12 Credit Memos Are Failing Create Accounting with error 'The account on the gain or loss line is invalid.'
Last updated on MAY 01, 2018
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
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