Receipt Using BOE For Cross Currency POs Using Custom Daily Rates Ends In Error: Ora-20120

(Doc ID 2296906.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, GST


Customer is creating cross currency POs and using custom daily rates.  When performing receipt using BOE, get the error:

JAI_EXCEPTION_OCCURED JAI_PROCESS_MSG jai_cmn_utils_pkg.currency_conversion
ORA-20120 Currency Conversion Date no defined in the system



STEPS
The issue can be reproduced at will with the following steps:
1. Create PO in cross currency
2. Ensure currency conversion type is custom one
3. Approve the PO
4. Create BoE and link the PO
5. Confirm the BoE
6. AP invoice would be created-account and pay it
7. Now try to do receipt on Boe and click on India tax details and you will get error
JAI_EXCEPTION_OCCURED JAI_PROCESS_MSG jai_cmn_utils_pkg.currency_conversion
ORA-20120 Currency Conversion Date no defined in the system

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