'Unable To Find A Calendar Date' While Scheduling a Sales Order
(Doc ID 563072.1)
Last updated on JANUARY 07, 2018
Applies to:
Oracle Global Order Promising - Version 11.5.10 and laterOracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Symptoms
While attempting to perform and ATP check, the following error is encountered:
- 'Unable to find a calendar date'
Session file from <Note 122372.1> shows the following:
Schedule: l_sourcing_org_id :=29421
Schedule: p_instance_id := 1
Schedule: Sysdate not found in Calendar
***** Begin Assign_Atp_Output_Rec Procedure *****
***** Begin Extend_Atp Procedure *****
***** End Assign_Atp_Output_Rec Procedure *****
Schedule: NO_DATA_FOUND: Stmt = 170
Schedule: Do I come here 13
Schedule: after the fix to remove the data
Call_Schedule: inside return status error
Call_Schedule: after setting group error
Call_Schedule: error from ATP := 47
Schedule: l_sourcing_org_id :=29421
Schedule: p_instance_id := 1
Schedule: Sysdate not found in Calendar
***** Begin Assign_Atp_Output_Rec Procedure *****
***** Begin Extend_Atp Procedure *****
***** End Assign_Atp_Output_Rec Procedure *****
Schedule: NO_DATA_FOUND: Stmt = 170
Schedule: Do I come here 13
Schedule: after the fix to remove the data
Call_Schedule: inside return status error
Call_Schedule: after setting group error
Call_Schedule: error from ATP := 47
Another example of ATP session file where the error can occur
ATP_Check: temp l_net_demand : 1
ATP_Check: Right before pegging
ATP_Check: Right after pegging
ATP_Check: l_ptf_date := 15-DEC-09
ATP_Check: l_ptf_enabled :=
ATP_Check: inside net_demand > 0
ATP_Check: Forward ATP Qty :=
ATP_Check: ATP Date : FUTURE :
MAtching cal date not found, in atp_check
Schedule: error := User-Defined Exception
Schedule: NO_MATCHING_DATE_IN_CAL
ATP_Check: Right before pegging
ATP_Check: Right after pegging
ATP_Check: l_ptf_date := 15-DEC-09
ATP_Check: l_ptf_enabled :=
ATP_Check: inside net_demand > 0
ATP_Check: Forward ATP Qty :=
ATP_Check: ATP Date : FUTURE :
MAtching cal date not found, in atp_check
Schedule: error := User-Defined Exception
Schedule: NO_MATCHING_DATE_IN_CAL
Cause
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
| Symptoms |
| Cause |
| Solution |
| Data Checks for Calendar Setups |
| Evaluate Data Check Results - APSCHECK and SQL Results and Solve |
| ATO/CTO/PTO Setups Are Incomplete or Incorrect and Causing ATP To Fail To Find Calendar Date |
| MOST COMMON ATO SETUP ERROR |
| ATP Rule has Infinite Supply Time Fence setting that points to NULL values. |
| References |