My Oracle Support Banner

Concurrent PRC: Generate Draft Invoices for a Single Project ends with error (Doc ID 2477843.1)

Last updated on JUNE 12, 2023

Applies to:

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

Symptoms

Concurrent Program:

PRC: Generate Draft Invoices for a Single Project errors: 

Error Message:

PRC: Generate Draft Invoices completed with below error
ORACLE error during DRAFT INVOICE GENERATION (cursor=14 code=-6502:
ORA-06502: PL/SQL: numeric or value error: character string buffer too)
then have the error

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 7

 

 

Note : PRC:Generate draft invoice program is failing with ORA error when India Localization code is active.
           This issue occurs when multi Currency is enabled in Project Billing and Invoice currency is not same as Invoice Processing currency.

 

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

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