Try to Access Supply/Demand From ATP Pegging Shows No Data And Errors With ORA-01403
(Doc ID 1383776.1)
Last updated on DECEMBER 04, 2019
Applies to:
Oracle Global Order Promising - Version 11.5.10 and laterInformation in this document applies to any platform.
Form:MSCOSCWB.FMB - ATP Inquiry
Symptoms
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
STEPS
- 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)
Changes
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 |
Changes |
Cause |
Solution |