R12.2.5: Performance Issue With PALDLC PRC: Distribute Labor Costs Process. Log Shows Very Large with Error: ORA-01403 (Doc ID 2308097.1)

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.

Symptoms

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:



STEPS
-----------------------
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.


Changes

 Upgraded from 12.1.3 to R12.2.5

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