ATP Processing Error, No Pegging Information Available, in Global Order Promising ORA-06532 ORA-01403 (Doc ID 456531.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

When attempting to perform an ATP Inquiry, the system returns the following error message:

'ATP Processing Error'.

Also, found the following errors in the ATP session file:

ERROR
Schedule: l_fst_src_pegging_ids.count0
Schedule: error := ORA-06532: Subscript outside of limit
Schedule: Resetting G_INV_CTP and G_ALLOCATED_ATP
Schedule: ATP_PROCESSING_ERROR
Schedule: Select EXCEPTION KR: others
Schedule: error := ORA-01403: no data found
ORA-06532: Subscript outside of limit
Schedule: l_tmp_pegging_id is -1

 

 

Steps To Reproduce

The issue can be reproduced at will with the following steps:

  1. Create an Item with the field ATP Check as "Resource Only".
  2. Create a Routing with some resources with CTP.
  3. Run the Data Collection and run the ATP Plan.
  4. After that, check the "ATP Inquiry";  the system returns the error:
        'ATP Processing Error'

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