My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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:
Receivables Manager
Control > Request > Run 
Select Create Accountingfrom 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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.