Scheduling ATO Fails ATP Processing Error - Session File Shows Create_ATP_Pegging ORA-1403
Last updated on NOVEMBER 09, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 220.127.116.11 and later
Oracle Order Management - Version 18.104.22.168 and later
Oracle Global Order Promising - Version 12.1.3 and later
Information in this document applies to any platform.
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.
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
1. Order Management responsibility
2. Try to schedule the order line.
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