Conversion Rate Does not Exist for a New Reporting Ledger that was added
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.
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
New Reporting Ledger Added GBP to EUR
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