My Oracle Support Banner

Performance Issue in OPM Pre-Processor In Release 12.2.7 After Upgarde from Release 12.1.3 (Doc ID 2473793.1)

Last updated on OCTOBER 08, 2024

Applies to:

Oracle Process Manufacturing Financials - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Patch Application Issues

ACTUAL BEHAVIOR
---------------
Performance issue with OPM Pre-Processor after upgrade from 12.1.3 to 12.2.7.
The gather Schema statistics was run before submitting the pre-processor.
In current 12.1.3 Production instance, the program runs about 30 minutes, and in upgrade 12.2.7. environment which is a copy of prod it runs hours.

Note: Patches 28614991:R12.GMF.C and 28492809:R12.GMF.C have been applied on the 12.2.7 instance.


EXPECTED BEHAVIOR
-----------------------
Similar performance in 12.2.7 that was there in 12.1.3.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: OPM Financials
2. Navigation: OPM Pre-Processor

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