Conversion Rate Does not Exist for a New Reporting Ledger that was added (Doc ID 1537458.1)

Last updated on MARCH 25, 2013

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
New Ledger was added that added the GBP to EUR Conversions.
Some of the Dates for the Invoices are back to 2011 year.
The conversion Rates for the GBP to EUR did not exist and needed to be added.

Symptoms

Attempting to run Create Accounting and receive the following error:

Error: Conversion Rate Does not Exist to convert GBP to EUR on Receipt in a new Reporting Ledger 2067 that was added.

Steps to Reproduce:
Responsibility:
Receivables Manager
Navigation: 
Control > Request > Run 
Select Create Accounting from the LOV
Enter Required Parameters and Click OK

Gather the Create Accounting Output flle Generated.
Look into the Diagnostic for the Receipt in question to the xla_ae_lines table for the Ledger Failing.

See that you have Exchange Date and Exchange Type .   Exchange Rate is missing.
See that the line that is missing the Exchange Rate is also missing value in Accounted DR or Accounted CR

Changes

New Reporting Ledger Added GBP to EUR

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