Work Orders Changes and Creations Are Taking Longer Time to Save
Last updated on FEBRUARY 08, 2018
Applies to:Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.
The Discrete Job form is taking long time to save (8-10 minutes) to create a job after upgrade from 12.1.3 to 12.2.6 or applying the consolidated patch 25166872:R12.WIP.B.
The Profile "MRP:Consume MPS" is set to "No" in this instance.
According to the trace file while occurring the performance issue, it can confirm the following query is taking the longest time.
The Discrete Job form should take a couple of seconds to save.
Steps to Reproduce
- Responsibility: Work In Process
- Navigation: Discrete -> Discrete Jobs.
- Query an existing Job OR create a new Job
- Make any change on the Job
- Click on Save and form takes time to save.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms