EMM: WM_PM Abend At Step WM_PM_LBR.UPDNXTDT.WRKDAY (Doc ID 2123124.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 and later
Information in this document applies to any platform.


In release 9.2 PUM 13, Demo, PM Schedule projection process WM_PM is failing for daily schedules when the projection is run for the date range that includes a holiday with the following message:

ORA-00001: unique constraint



Business Impact:
Because of this, we cannot create a PM for a date range which includes a holiday. However a date range without a holiday works.

Steps to replicate:

1. Ensure that Business Calendar is Specified in the WO definition page and “Use Business Day” option is selected.
2. Open the Business Calendar that was associated with the WO definition.
3. Ensure that there is at least one holiday listed that falls in the date range for which projection process will run.

In this example, we are going to run the projection for the date range “12\01\2015 to 12\31\2015”. We have specified 12\25 as the holiday in the calendar .
4. Set up the Location Schedule with the schedule type of “Daily”, Location Schedule definition – Advanced Options Page
5. Set up the run control to run the projection process for the schedule # 0000000006 created in previous step.
6. Run the projection for the date range 12\01 and 12\31.

Note: 12\25 is defined as holiday in the business calendar that is associated with the WO BU definition.
Result: WM_PM Process went into “No Success” with this error:

ORA-00001: unique constraint




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