PA: R12: Performance Issue With PRC: Process Projects Structure Updates (Doc ID 1921975.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 01-AUG-2016***

Symptoms

On : 12.0.6 version, Project Performance Reporting

ACTUAL BEHAVIOR
---------------
Process Project Structure Updates spawns PRC: Update Project Performance Data impacts performance


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
PRC: Process Projects Structure Updates is run nightly for each operating unit. We have had occasions for one operating unit who use program projects where PRC: Update Project Performance Data is spawned.
This can take up to 6 hours to run for one or two projects and prevents us running the critical finance updates for our legislative reporting.
We need to understand exactly why this process is being spawned. We also want to prevent this being automatically spawned and have the option to run this only at the weekend. We currently run PRC: Update Project Performance Data and PRC: Update Project Summary Amounts at the weekend only because both processes take so long to run.
We also need to understand the impact of stopping PRC: Update Project Performance Data from running immediately after PRC: Process Project Structure Updates.
We have read the various documents on Metalink and located the profile options mentioned but we have been unable to find a direct hit to our actual scenario so need guidance on the best course of action to take

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