MRPRPROP: Reorder Point Report Failing For 1 Of 7 Inventory Orgs - Error APP-MRP-22050: Date falls outside the boundaries of the wor... (Doc ID 2269914.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

One reorder point planning report is failing for one inventory org. Others are completing successfully

MRPRPROP: Reorder Point Report
+---------------------------------------------------------------------------+

Current system time is 24-MAY-2017 08:29:33

+---------------------------------------------------------------------------+

+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
P_ORG_ID='465'
P_ITEM_SELECTION='1'
P_DEMAND_CUTOFF_DATE='2017/05/24 00:00:00'
P_SUPPLY_CUTOFF_DATE='2017/05/24 00:00:00'
P_RESTOCK='1'
P_DEFAULT_DELIVERY_TO='165'
P_FORECAST='FORECAST'
P_FIRST_SORT='1'
P_SECOND_SORT='0'
P_THIRD_SORT='0'
P_LOW_ITEM='aaaa'
P_HIGH_ITEM='bbbbb'
P_CATEGORY_SET='1'
P_CAT_STRUCT_NUM='101'
P_INCLUDE_PO='1'
P_INCLUDE_WIP='2'
P_INCLUDE_IF='1'
P_INCLUDE_NONNET='2'
P_DISPLAY_DESCRIPTION='2'
P_DISPLAY_ADD_INFO='2'
P_USER_ID='146557'
------------

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.US7ASCII

'.,'

Enter Password:
REP-1425: 'c_demand_qtyformula': Error running DO_SQL package - 'Error opening SQL cursor.
ORA-20001: APP-MRP-22050: Date falls outside the boundaries of the wor' .
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1425: 'c_demand_qtyformula': Error running DO_SQL package - 'Error opening SQL cursor.
ORA-20001: APP-MRP-22050: Date falls outside the boundaries of the wor' .

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