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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Invoices

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

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