PALDLC: PRC: Distribute Labor Costs completes with error ORACLE error while updating drc for items with extn call (Doc ID 2795119.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Symptoms

When running the program PRC: Distribute Labor Costs, the program completes in error.

The log file contains the following information
...
...
Determining how many EIs to skip. # of IEs [100]
[0] items updated 'N' skipping further processing
palccc: Preparing to Call Raw Cost Extension
App error during Extn Call for eiid [#######] - status [1]
palccc: Updating rejected rows after calling client extension
ORACLE error while Calling Raw Cost extn
[24] items updated for rej code
Updating items after extn call
ORA-01458: invalid length inside variable character string
  
ORACLE error while updating drc for items with extn call
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
EXPENDITURE ITEM ID: <EXP_ITEM_ID> <CUSTOM LABOR COSTING EXTENSION.PROCEDURE>: PROCESS 01-4: GET PERIOD;User-Defined Exception
EXPENDITURE ITEM ID: <EXP_ITEM_ID> <CUSTOM LABOR COSTING EXTENSION.PROCEDURE>: PROCESS 00-1: GET GET_EXT_VALUES;User-Defined Exception
EXPENDITURE ITEM ID: <EXP_ITEM_ID> <CUSTOM LABOR COSTING EXTENSION.PROCEDURE>: PROCESS 01-5: GENERATE RATE FOR EC;User-Defined Exception

Step To Reproduce
--------------------
Log into a Projects Responsibility
Navigate to Other > Requests > Run
Enter PRC: Distribute Labor Costs
Click Submit

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.