My Oracle Support Banner

R12: PAIGEN: ORA-01458: Invalid Length Inside Variable Character String (Doc ID 2073809.1)

Last updated on AUGUST 13, 2018

Applies to:

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

Symptoms

When attempting to run PRC: Generate Draft Invoices for a Single Project
the following error occurs.

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Run PRC: Generate Draft Invoices for a Single Project


2. The process errors out. The complete error is:

 

Project Id :97994
Ptop_task_id: 5303727 adj_on_std_inv not equal to N Count14
return stat...Calling Labor paigil
Setting.....
...Inserting line # 1 of invoice # 3 for $-1000
 Pinv_rate_type=Corporate len=9
 Pinv_rate_date=21-JUL-15 len=9
 Pinv_exchange_rate=.015873015873015873015873015873X len=32
 Pcredit_process_flag=X len=1
ORACLE error during DRAFT INVOICE GENERATION (cursor=32 code=-1458: ORA-01458: invalid length inside variable character string
  )

Leaving paiiil()Error during Draft Invoice Generation. Module paiiil returned failure

 

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.