Discrete Job Creation Fails/hangs With 'Scheduling Job And Creating Material Requirements' Message

(Doc ID 2364657.1)

Last updated on FEBRUARY 22, 2018

Applies to:

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

Symptoms



ACTUAL BEHAVIOR

Discrete Job Creation fails/hangs with 'Scheduling Job and Creating Material Requirements'
The Discrete Job form is hanging to create a job after upgrade from R12 to 12.2.6.


Tried the following:


To implement the solution, please execute the following steps:

1. Run Gather Schema Statistics for WIP, INV, BOM and MRP at 50%--these run nightly and nothing out of the ordinary.

2. Using Adadmin, regenerate the WIPDJMDF form. Please make sure to use the option to rebuild all dependent libraries--done this several times.

3. Using Adadmin, please relink the entire WIP schema

4. Bounce Apache & OA Core server

5. Retest the issue--issue still present

The version of forms and pl/sql:


WIPDJMDF.fmb 120.118.12020000.52
wipbmrtb.pls 120.23.12020000.10
wipbmrub.pls 120.28.12020000.9




EXPECTED BEHAVIOR

The Discrete Job form should take a couple of seconds to save.




STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility: Work In Process.
2. Navigation: Discrete -> Discrete Jobs.
3. Click on New.
4. Enter Assembly, start quantities, mrp quantities, start and completion date.
5. Click on Save and form hangs



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