PALDLC: PRC: Distribute Labor Costs Program Errors in Log and Output: Oracle Error Occurred in Calc_Raw_Cost Extension and ORA-01403: No Data Found (Doc ID 2930750.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Symptoms

PALDLC: PRC: Distribute Labor Costs Program completes with error in Calc_Raw_Cost extension; both the log and the output show errors. Note when distributing Labor Cost and the Quantity for a half hour, this appears correct in the Timecard (0.5), but not in the PA_EXPENDITURE_ITEMS_ALL table (0.499999999999).

ERROR

Output: 

CALC_RAW_COST_EXT_FAIL

Logfile: 
Determining how many EIs to skip. # of IEs [21]
[0] items updated 'N' skipping further processing
palccc: Preparing to Call Raw Cost Extension
Oracle error occurred in Calc_Raw_Cost extension
Expenditure item id: [number], status: [-number]
ORA-01403: no data found
Expenditure item id: [number], status: [number]

and/or: 

STEPS TO REPRODUCE
1. Projects responsibility
2. Distribute Labor Cost and the Quantity for a half hour
3. See this is fine in OTL (0.5)
4. Check in project, 0.499999999999 is shown and failure

Cause

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