PALDLC Errors With ORA-01458: Invalid Length Inside Variable Character String Error When Processesing Large Number of Time Cards for Both Regular and Contract Employees

(Doc ID 2096787.1)

Last updated on JANUARY 13, 2016

Applies to:

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

Symptoms

PALDLC PRC: Distribute Labor Costs

Fails with ORA-01458: invalid length inside variable character string error when processing a large number of time cards for both regular and contract employees.

Error:

Starting to fetch all selected expenditure items for AutoAccounting
Starting rate derivation for CWK.
Calling PA_Costing_Client_Extns.Calc_Raw_Cost_Hook to check if CWK rates are
returned by client extension.
PA client extension of CWK rate derivation for eiid [5275543] - status [0] -
denom raw cost [] - Quantity [.5] - Currency Code [] - Rate [0.00]
ORA-01458: invalid length inside variable character string

Error does not occur when processing a small number of time cards.

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