My Oracle Support Banner

AR: Create Accounting Error 'The account on the gain or loss line is invalid' for a Miscellaneous Receipt in Functional Currency (Doc ID 2994315.1)

Last updated on DECEMBER 21, 2023

Applies to:

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


Run Create Accounting for an Entity that have both a Primary and Secondary Ledger.
The output shows the following error for a Miscellaneous Receipt in Functional Currency on the Secondary Ledger:

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.

The issue can be reproduced at will with the following steps:
Responsibility: Receivables Manager
Navigation: Menu > View > Requests > Submit a New Request... > Single Request
    1. Select from List Of Value 'Create Accounting'
    2. Provide the parameters >  Submit




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.