R12 PAIGEN Fails ORACLE Error During DRAFT INVOICE GENERATION (cursor=31 Code=-1458: ORA-01458 (Doc ID 1570836.1)

Last updated on AUGUST 01, 2016

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 PAIGEN  PRC: Generate Draft Invoices for a Single Project (or a range) the following error occurs:

ERROR
-----------------------
 MCB Related Changes Pinv_rate_type=l¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿len=37
 Pinv_rate_date= len=0
 Pinv_exchange_rate=¿¿¿len=6
 Pcredit_process_flag= len=0

and

ORACLE error during DRAFT INVOICE GENERATION (cursor=31 code=-1458: ORA-01458: invalid length inside variable character string
  )
PAI_ORACLE_ERROR
ERROR
cursor=31 code=-1458: ORA-01458: invalid length inside variable character string
  

Leaving paiiil()Error during Draft Invoice Generation. Module paiiil returned failure
PA_IGEN_ERROR
MODULE
paiiil
Error during Draft Invoice Generation. Module paiewd returned failure
PA_IGEN_ERROR
MODULE
paiewd
Error during Draft Invoice Generation. Module paiagr returned failure
PA_IGEN_ERROR
MODULE
paiagr
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