ATP Processing Error, ORA-06532: Subscript outside of limit, found in ATP Session File (Doc ID 1943411.1)

Last updated on DECEMBER 21, 2016

Applies to:

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


On Oracle Global ATP Server, you are getting the ATP processing error when you check ATP on the Sales order line ,you are using ATO models and we have narrowed down that when you choose the specific component/operation we are getting the ATP process error. This has been working for us since a month and as for as we know there has been no change in the item attributes and BOM and Routing /resources.

The specific operation which has the issue is Welding operation which has the CTP enabled resource.
You are seeing this error for all the CTP enabled resources.

ATP Processing error

ATP session file shows

Get_Res_Requirements: l_requested_res_qty := .07225375
date: 27-OCT-14 qty: 16.96666666666666666666666666666666666666
date: 28-OCT-14 qty: 23.94999999999999999999999999999999999999
...............  rest of daily resource tally until end of plan horizon......

date: 27-OCT-15 qty: 23.94999999999999999999999999999999999999
date: 28-OCT-15 qty: 23.94999999999999999999999999999999999999
date: 29-OCT-15 qty: 23.94999999999999999999999999999999999999
date: 30-OCT-15 qty: 23.94999999999999999999999999999999999999
date: 31-OCT-15 qty: 6.98333333333333333333333333333333333333
Insert_Details: x_atp_dates.COUNT  318
Insert_Details: indx 0
Get_Res_Requirements inside when others
error := ORA-06532: Subscript outside of limit
ATP_CHECK: IN Error block for OTHERS
ATP_Check: error := User-Defined Exception
something wrong in the ATP_Check 2, sqlcode= 1
Schedule: error := User-Defined Exception
Schedule: Resetting G_INV_CTP and G_ALLOCATED_ATP
Schedule: l_tmp_pegging_id is 98459
Schedule: Now deleting- calling remove invalid SD REC


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

  1. Order Management Responsibility
  2. Check ATP on Sales Order lines

It is heavily impacting testing and cross functional, other ATP issues testing.  Sev1 SR's for other issues and backlog conversion.


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