R12:PA:PRC: Generate Intercompany Invoices For A Single Project Completes With Error
(Doc ID 2392523.1)
Last updated on NOVEMBER 15, 2022
Applies to:
Oracle Project Billing - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Invoices
PRC: Generate Intercompany Invoices for a Single Project completes with error:
Error:
Sql Error : ORA-20001: JAI_EXCEPTION_OCCURED (JAI_PROCESS_MSG=jai_cmn_utils_pkg.currency_conversion. Err:ORA-20120: Currency Conversion Rate Not Defined In The System)
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512
: at "APPS.JAI_PA_COSTING_PKG", line 196
ORA-06512: at "APPS.JAI_PA_COSTING_PKG", line 832
ORA-06512: at "APPS.JAI_PA_PDIA_AFTER_T1", line 708
ORA-04088: error during execution of trigger 'APPS.JAI_PA_PDIA_AFTER_T1'
From trace file seems that problem stem from:
SELECT CONVERSION_RATE
FROM
GL_DAILY_RATES WHERE TO_CURRENCY = :B4 AND FROM_CURRENCY = :B3 AND
TRUNC(CONVERSION_DATE) = TRUNC(NVL(:B2 ,SYSDATE)) AND CONVERSION_TYPE = :B1
In which USER_CONVERSION_TYPE is being passed. This works only for Spot rate, but for other rates USER_CONVERSION_TYPE is not equal to CONVERSION_TYPE, thus it cannot find a conversion rate.
Affected projects are using rate types other than "Spot".
ERROR
-----------------------
ORA-20001: JAI_EXCEPTION_OCCURED (JAI_PROCESS_MSG=jai_cmn_utils_pkg.currency_conversion. Err:ORA-20120: Currency Conversion Rate Not Defined In The System)
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |