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:

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

1. Do ATP inquiry from Source instance (Scheduling / ATP Inquiry) the ATP shows correct result.
2. Expanding the pegging tree, right clicking on one of the Supply line and trying to open the Supply/Demand window
3. 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.