Error Number 0 & 95353 in Oracle Payables: The account on the gain or loss line is invalid. - Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/07/error-number-0-95353-in-oracle-payables.html

Issue:

Line	Error Number	Error Message
3	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.

Line	Error Number	Error Message
	95353	Subledger Accounting was unable to derive an accounting code combination using the account derivation rule Exchange Rate and Tax Exchange Rate Variances owned by Oracle. Please review the account derivation rule and make sure it derives a valid accounting flexfield combination for the source values passed for the transaction.

Data Corruption in Financials Options possibly because the account added at the financial options have been incorrectly modified.

1. Run the following query to determine if this is an issue.

select ASP_RATE_VAR_gain_CCID
, ASP_RATE_VAR_loss_ccid
, asp_org_id
from AP_SYSTEM_PARAMETERS_EXTRACT_V;

If the query returns -1 for ASP_RATE_VAR_GAIN_CCID or ASP_RATE_VAR_LOSS_CCID then proceed.

Solution:

1. Navigate to Financials Options in AP

2. Populate the PO Rate Gain and Loss fields. If already populated then change the value to itself and save it.

3. Run the query again to be sure all the values are not -1.

4. Please run Create Accounting and Verify.