Receipts Workbench Issue: Datafix: Miscellaneous Receipt Exchange CCID = -1 In xla_ae_lines Table For Secondary Ledger (Doc ID 2044111.1)

Last updated on JUNE 22, 2016

Applies to:

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

Symptoms

Issue:
======
User is not able to post MISC receipts to GL.

Create Accounting fails with errors:

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

1 95314 The entered amount and accounted amount for line 1 are not on the
same side.
Please inform your system administrator or support representative that: The
source assigned to the accounting attribute entered amount is not consistent
with the source assigned to the accounting attribute accounted amount or the
supplied conversion rate is invalid.

ANALYSIS
=========
Customer is posting for primary ledger and secondary ledger.
Secondary ledger accounting is populated by SLA .
The CCID is populated as -1 for reporting ledger data.
Hence the receipt is not getting accounted to SLA and GL.

The Receipt has been multiple times rates adjusted the receipt which is an extremely corner case and odd usage.

currency_conversion_rate is not correctly populated in AR_DISTRIBUTIONS_ALL for the receipts created in foreign currency.

Fix Approach
============
Currency_conversion_rate has to be correctly populated in ARD for MISC receipts  

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