My Oracle Support Banner

Lot Cost Process Taking Long Time To Complete After Upgrade To R 12.2.10 (Doc ID 2862636.1)

Last updated on MAY 02, 2022

Applies to:

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

Symptoms

On : 12.2.10 version, Lot Costs

ACTUAL BEHAVIOR
---------------
After upgrade from 12.1.3 to 12.2.10 and database upgrade to 19.12.0.0, find there is a performance issue when running the lot cost process.
Before the upgrade, the process finished in 2-3 minutes and now it takes about 30 minutes to complete.

The process is taking time on the following:

Start Gather Statistics on GMF_LOT_COSTED_ITEMS_GT.
Processing uncosted transactions.


EXPECTED BEHAVIOR
-----------------------
Better or same performance in 12.2.10 as in 12.1.3


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: OPM Financials
2. Navigation: Lot Cost > Lot Cost Process
3. Submit lot cost process.


Changes

Upgraded application from 12.1.3 to 12.2.10 and upgraded database to 19.12.0.0.

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.