PAICGEN: Error ORA-06502: PL/SQL: Numeric Or Value (Doc ID 1610589.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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


Cause

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