Performance Issue In Changing WIP Job Status (Doc ID 2137008.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

Performance issue in changing WIP job status while trying to change WIP job status from Unreleased to Released using wip mass load

EXPECTED BEHAVIOR

Expect to see lesser time taken for Mass load

STEPS

The issue can be reproduced at will with the following steps:
1. Insert data into WIP interface tables to change the status of the job
2. Launch WIP Mass Load
3. The request completes successfully but takes more time..


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