Try to Access Supply/Demand From ATP Pegging Shows No Data And Errors With ORA-01403
Last updated on JANUARY 13, 2017
Applies to:Oracle Global Order Promising - Version 11.5.10 and later
Information in this document applies to any platform.
Form:MSCOSCWB.FMB - ATP Inquiry
ATP based on planning data or ATP based on Collected Data
When attempting to do ATP inquiry from Source instance (Scheduling / ATP Inquiry) the ATP shows correct result. However, upon expanding the pegging tree, right clicking on one of the Supply line and trying to open the Supply/Demand window.
Also, the Horizontal Plan can be opened OK by right click. But upon double clicking in the Total Demand cell, the following error is displayed.
ORA 01403: no data found
- Do ATP inquiry from Source instance (Scheduling / ATP Inquiry) the ATP shows correct result.
- Expanding the pegging tree, right clicking on one of the Supply line and trying to open the Supply/Demand window
- The error is raised by the system.
Please note the following profile options in the Source instance-
MRP:Debug Mode = Yes (user level)
MSC: ATP Debug Mode = Debug Only (user level)
MRP: Calculate Supply Demand = Yes (Site level)
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