R12.2.5: Performance Issue With PALDLC PRC: Distribute Labor Costs Process. Log Shows Very Large with Error: ORA-01403
Last updated on SEPTEMBER 15, 2017
Applies to:Oracle Project Costing - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, Labor Costing Flow
Since upgrading from R12.1.3 to R12.2.5, the log from the run of PALDLC PRC: Distribute Labor Costs process has become enormous.
This is causing a performance issue where the program in 12.1.3 ran for 10 to 15 minutes and in 12.2.5 is ts now taking 50 to 60+ minutes.
In 12.2.5, the log file shows error:
The issue can be reproduced at will with the following steps:
1. Run PALDLC PRC: Distribute Labor Costs process wide open:
Validated parameters are as follows:
Parameter 1 - Expenditure group = 'WOU-15-JUL-17ST3946429'
Parameter 2 - Project Id = '0'
Parameter 3 - Employee Name = 'All'
Parameter 4 - End date = ''
Parameter 5 - Incurred by orgainzation ID = ''
Parameter 6 - Reschedule interval = None
Parameter 7 - Reschedule time of day = ''
Parameter 8 - Reschedule until = ''
Parameter 9 - Reschedule adjust dates = No
2. Log file shows error above.
Upgraded from 12.1.3 to R12.2.5
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