Scheduling ATO Fails ATP Processing Error - Session File Shows Create_ATP_Pegging ORA-1403 (Doc ID 970918.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Oracle Order Management - Version 11.5.10.2 and later
Oracle Global Order Promising - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to schedule the Order Line which ATP available is far beyond the Request Date, the following error occurs.
This does not occur for all ATO models, only some of them.

ERROR
-----------------------
In Order Management we see:
Scheduling failed: ATP Processing error. Available Date: 23-MAR-10.

ATP Session files shows:

Create_Atp_Pegging:  Number of rows inserted-1 0
Create_Atp_Pegging: 100 error encountered while creating ATP Pegging : ERROR =  ORA-01403: no data found
Schedule: error := User-Defined Exception
Schedule: Resetting G_INV_CTP and G_ALLOCATED_ATP
Schedule: ATP_PROCESSING_ERROR



STEPS
1. Order Management responsibility
2. Try to schedule the order line.

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