ORA-01403: Scheduling Failed ATP Processing Error (Non ATO item) When Assemble To Order Is Checked In OM Validation Org (Doc ID 1305329.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Global Order Promising - Version 11.5.10 and later
Information in this document applies to any platform.

Symptoms




In an R11.5.10 Production Instance (Decentralized APS Environment, with Capable to Promise Based on Planning Output)
with the following rollup patch installed:

Bug 8686151 - APS ATP RUP#27 PATCH FOR 11.5.10 BRANCH

When trying to schedule a sales order, get the following errors in the destination session file:

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
Schedule: l_tmp_pegging_id is 678550857
Schedule: Now deleting- calling remove invalid SD REC

This is when trying to perform ATP for a standard item (in the Sales Orders form).

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