R12 PAIGEN PRC: Generate Draft Invoices Process Fails: ORA-01458: Invalid Length Inside Variable Character String (Doc ID 1295559.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Billing - Version 12.1.1 and later
Information in this document applies to any platform.
*** Checked for relevance 24-Sep-2014 ***

Symptoms

After launching the concurrent request PAIGEN PRC: Generate Draft Invoices for a Single Project, the process fails with the following error:

ORA-01458: invalid length inside variable character string.
paievt_cur: Open CursorORACLE error during DRAFT INVOICE GENERATION (cursor=18 code=-1458: ORA-01458: invalid length inside variable character string
)
PAI_ORACLE_ERROR
ERROR
cursor=18 code=-1458: ORA-01458: invalid length inside variable character string
Leaving paievtcons()Error during Draft Invoice Generation. Module paigaacons returned failure
PA_IGEN_ERROR
MODULE
paigaacons
Error during Draft Invoice Generation. Module paigaacons returned failure
PA_IGEN_ERROR
MODULE
paigaacons
Error during Draft Invoice Generation. Module paitrncons returned failure
PA_IGEN_ERROR
MODULE
paitrncons
Error during Draft Invoice Generation. Module paigop returned failure
PA_IGEN_ERROR
MODULE
paigop

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