My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.