MSCPDCW Fails When Loading Supply On Calendar Boundries ORA-20001

(Doc ID 258419.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Oracle Solaris on SPARC (32-bit)
MSCPDCW
MSCCLBAB.pls

Symptoms

Running ATP data collection with selected options:

Instance: SYM
Number of Workers: 4
Timeout(Minutes): 600
Purge Previously Collected Data: Yes
Collection Method: Complete Refresh
Analyze Staging Tables: No
Approved Supplier Lists(Supplier Capacities): Yes
ATP Rules: Yes
Bills of Materials/Routings/Resources: Yes
Bills of Resources: No
Calendars: Yes
Demand Classes: No
End ITem Substitutions: Yes
Forecasts: Yes
Items: Yes
Key Performance Indicator Targets: No
Master Demand Schedules: No
Master Production Schedules: No
On-Hand: Yes
Planning Parameters: Yes
Planners: Yes
Projects/Tasks: Yes
Purchase ORders/Purchase Requisitions: Yes
Reservations: No
Resources Availability: No
Safety Stock: No
Sales Orders: Yes
Sourcing History: No
Sourcing Rules: Yes
Subinventories: Yes
Supplier Responses: Yes
Trading Partners(Customers): No
Trading Partners(Suppliers): No
Unit Numbers: Yes
Units of Measure: Yes
User Company Association: No
User Supplies and Demands: Yes
Work in Process: Yes

gets the following error:

MSCPDCW module: Planning ODS Load Worker

**Starts**13-NOV-2003 19:45:17
**Ends**13-NOV-2003 19:45:22

ORA-20001: Date falls outside the boundaries of the workday calendar

Cause: The current date is outside the range of valid workdays. The date is either before the start of the workday calendar or after the end of the workday calendar.

Action: Extend the boundaries of your workday calendar.
ORA-20001: Date falls outside the boundaries of the workday calendar

Cause: The current date is outside the range of valid workdays. The date is either before the start of the workday calendar or after the end of the workday calend


Running ATP data collection with all options selected except "User Company Association " does not get the error. 

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