PAICGEN: Error ORA-06502: PL/SQL: Numeric Or Value
(Doc ID 1610589.1)
Last updated on FEBRUARY 03, 2019
Oracle Project Billing - Version 12.1.3 and later Information in this document applies to any platform.
When attempting to run the PAICGEN PRC: Generate Intercompany invoices for a single project with a through date of the following errors occur.
ERROR ----------------------- ORACLE error during DRAFT INVOICE GENERATION (cursor=25 code=-6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too) PAI_ORACLE_ERROR ERROR cursor=25 code=-6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too Unable to complete Invoice detail process. ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.PA_INVOICE_DETAIL_PROCESS", line 2487 ORA-06512: at line 1
Leaving paicexp()Error during Draft Invoice Generation. Module paicexp returned failure PA_IGEN_ERROR MODULE paicexp Error during Draft Invoice Generation. Module paicgop returned failure PA_IGEN_ERROR MODULE paicgop
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!