My Oracle Support Banner

'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 later
Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


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

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


To view full details, 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 a vibrant support community of peers and Oracle experts.