Create Accounting For AR Transaction Shows Error 'Account On The Gain Or Loss Line Is Invalid (Doc ID 1964209.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Manage Revenue-Record Accounting for Revenue Transactions

When attempting to run Create Accounting for Receivables, the following error occurs.

ERROR
-----------------------
The account on the gain or loss line is invalid. Details: If you have a gain or loss
journal line rule defined, verify the account rule associated with it for the journal
entry rule set can derive a valid account. If no gain or loss journal line rule is
defined, verify the value in the source mapped to the accounting attributes
Exchange Gain Account and Exchange Loss Account references a valid
account.


STEPS
-----------------------
1. Create a Primary Ledger (10 PL EUR) and Reporting Ledger (10 PL USD D)
2. Run Create Accounting for Receivables subledger
3. Review Create Accounting Execution Report which shows (example):
Journal Entries with Errors
Ledger 10 PL EUR
Journal Entry Status Invalid related entry

Transaction Number 620013
Ledger 10 PL USD D
Journal Entry Status Invalid

Line Error Message
2 The account on the gain or loss line is invalid. Details: If you have a gain or loss journal line rule defined, verify the account rule associated with it for the
journal entry rule set can derive a valid account. If no gain or loss journal line rule is defined, verify the value in the source mapped to the accounting attributes
Exchange Gain Account and Exchange Loss Account references a valid account.

Note: For line 2, the ACCOUNT is NULL

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, month end and year end processing cannot be completed.

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