My Oracle Support Banner

R12:PA:PRC: Generate Intercompany Invoices For A Single Project Completes With Error (Doc ID 2392523.1)

Last updated on AUGUST 01, 2018

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information 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 to:
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

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.

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)

Changes

 

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!


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