My Oracle Support Banner

ECC Project Manufacturing Full Load Performance (Doc ID 2806608.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

Oracle Project Manufacturing - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, SUPPORT

ACTUAL BEHAVIOR
---------------
ECC -- performance issue running full load for Project Manufacturing

We've been trying to get the PJC command center load to run for the first time, but it keeps failing after running for 36 hours.

The errors in the log say it's running out of TEMP space. The DBAs have increased temp many times, as well as applied 3 SQL profiles, and it is still failing.


EXPECTED BEHAVIOR
-----------------------
Expected better performance

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Projects -> Project Manufacturing command center Data Load
2.Submitted request for Full load
3.Created project(P2-PJ-3) and assigned parameters
4.Submitted request for Incremental load




Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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