WIP Mass Load ends in warning with ORA-00001 error during MPS release through MPS Workbench (Doc ID 1629260.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, MPS Workbench

Select All for release launches WIP mass load which ends in warning.
Only 1 wip job is created with session_id and not correct job name.

ORA-00001 error can be observed from the Job and Schedule Interface Report.


    Group ID:  4138740                                                                               Report Date:  21-NOV-2013 03:56
                                                Job and Schedule Interface Report                          Page:      1  of       1


                                                       Create Discrete Jobs
 Source Code: MRP
Organization: M1
                                                                                                           Process      Process
 Job             Job Type      Assembly          Quantity Start Date        Completion Date   Kanban Card  Phase        Status
 -------------   ------------  -------------   ---------- ---------------   ---------------   -----------  ---------    --------
 54382306        Standard      YO-TOP-0412          20.00                   03-DEC-13 00:00                Validation   Error
        Error:      ORA-00001: unique constraint (WIP.WIP_ENTITIES_U2) violated in Package wip_massload_pvt Procedure
                    processWJSI

 54382306        Standard      YO-TOP-0412          49.00 15-JUL-13 07:00   28-NOV-13 00:00                Complete     Complete

1 out of 2 jobs were successfully loaded


Also, for other WIP_JOB_SCHEDULE_INTERFACE records which errored out through WIP Mass Load,
all JOB_NAME is set to the same session id as shown below.


STEPS
-----------------------
There are many ways to reproduce the issue.

[Pattern 1]

  1. Open MPS Workbench and query the item to open supply form
  2. Multiple plan orders are viewable. Press "Select all for release"
  3. Note pop up appears. press "OK"
  4. Change Implementation Date of Planned Order (more than one record)
  5. Press "Release"
  6. Decision form pop up and press "Yes".
  7. Caution form pop up and press "OK"


[Pattern 2]

  1. Open MPS Workbench and query the item to open supply form
  2. Multiple plan orders are viewable. Press "Select all for release"
  3. Note pop up appears. press "OK"
  4. Press Save on Menu bar. (FRM:40401: No changes to save)
  5. Press "Release"
  6. Decision form pop up and press "No".


[Pattern 3]

  1. Open MPS Workbench and query the item to open supply form
  2. Multiple plan orders are viewable. Press "Select all for release"
  3. Note pop up appears. press "OK"
  4. Change Implementation Date of Planned Order (more than one record)
  5. Press "Release"
  6. Decision form pop up and press "No".
  7. Press "Select all for release"
  8. Change Implementation Date of Planned Order (more than one record)
  9. Press "Release"
  10. Decision form pop up and press "Yes".
  11. Caution form pop up and press "OK"


[Pattern 4]

  1. Open MPS Workbench and query the item to open supply form
  2. Multiple plan orders are viewable. Press "Select all for release"
  3. Note pop up appears. press "OK"
  4. Press Save on Menu bar. (FRM:40401: No changes to save)
  5. Close supply form.
  6. Decision form pop up and press "No".
  7. Close MPS workbench form
  8. Open MPS Workbench and re-query the item on 1. to open supply form. (Records are turned pink)
  9. Press "Release"

 

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