My Oracle Support Banner

ATP Processing Error while booking an order for a Product Family Member Item (Doc ID 2746328.1)

Last updated on FEBRUARY 10, 2021

Applies to:

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

Symptoms

On 12.2.9

While attempting to book a sales order for an ATO Item which is a member of a product family, scheduling fails.

Order booking goes through in an Org where the product families are not used\defined.

ERROR

-----------------------

Scheduling failed: ATP Processing error. Available Date: XX-XXX-20

Session files show the below:

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

Customer is upgrading from 12.1.3 to 12.2.9 and states that the issue is happening in 12.1.3 instance as well.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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