Try to Access Supply/Demand From ATP Pegging Shows No Data And Errors With ORA-01403 (Doc ID 1383776.1)

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


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)

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