R12:PA:PRC: Generate Intercompany Invoices For A Single Project Completes With Error
Last updated on APRIL 30, 2018
Applies to:Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Invoices
PRC: Generate Intercompany Invoices for a Single Project completes with 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
: 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 to:
GL_DAILY_RATES WHERE TO_CURRENCY = :B4 AND FROM_CURRENCY = :B3 AND
TRUNC(CONVERSION_DATE) = TRUNC(NVL(:B2 ,SYSDATE)) AND CONVERSION_TYPE = :B1
Process as CONVERSION_TYPE use USER_CONVERSION_TYPE. This works only for Spot rate, but for other rates USER_CONVERSION_TYPE is not equal to CONVERSION_TYPE, thus can not find conversion rate.
Affected projects has different rate type than Spot.
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)
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