R12: Create Accounting Error 0 - Incorrect XRATE Date for Refund Failing for Secondary Ledger Accounting (Doc ID 2187451.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

DESCRIPTION OF THE LOSS OF FUNCTIONALITY
------------------------------------------------------
In Oracle Payables, Payment accounting has the following error:

ERROR
-------
Error number 0
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.

REPRODUCTION STEPS

==============

**steps before creating invoice/payment transaction**
Create a reporting ledger with foreign currency (ex: INR), (reporting level subledger) for primary ledger. In a Payables responsibility->Setup->options->Payables Options: In the Accounting Option tab, in the Payment accounting section, check the following boxes: Account for Payment - When payment is issued, When Payment Clears. Account for Gain/Loss - When Payment Clears Make sure the invoice and payment have different rate dates(ex: 16-JAN-2016 and 17-JAN-2016 respectively), same rate type (corporate), and different rates for both dates (ex: .33 and .5 respectively)

*****************************************
1. Create a Credit memo in USD currency
a. Validate Credit Memo
b. Approve Credit Memo
c. Account (Final) Credit Memo
2. Create a refund in USD currency

a. Pay credit memo
b. Account (Final) Refund. The accounting should get the Error number 0 for the reporting 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.

===============




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