PALDLC: Project Cost and Distribution Related Programs Have Suddenly Having Performance Issues (Doc ID 2954696.1)

Last updated on JUNE 16, 2023

Applies to:

Symptoms

Project related programs are running for extremely long times

1. PRC: Distribute Supplier Cost Adjustments
2. PRC: Distribute Total Burdened Cost
3. PRC: Generate Cost Accounting Events

This is a sudden change in the length of time the programs are expected.

There was only a single burden schedule version dating back many years.

If any change is made to a Burden Schedule's version information, that change causes all expenditure items within that burden schedule's version's date range to be flagged for re-costing. 

Those changes include adding or changing any organization, cost code, and/or Multiplier to that burden schedule's version.

This burden schedule had rates defined at the Operating Unit level, so all organizations below the operating unit were impacted.

This resulted in millions of expenditure items being flagged to re-cost.

Steps to Reproduce
----------------------
1. Navigate to Projects responsibility
2. Submit the concurrent requests
3. Verify the issue.

Due to this issue, users cannot process complete processing transactions because the programs are running into the next business day and interfering with normal business operation.

Changes

A burden schedule was recompiled to resolve an issue with PRC: Interface Supplier Costs giving the exception: Can not find burden schedule revision
R12 PAAPIMPB PRC: Interface Supplier Cost Process Gives the Following Even though a Burden Multiplier Exists: Can not find burden schedule revision (Doc ID 1583562.1)

Cause

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