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 12.1.3.8 and later
Information in this document applies to any platform.

Symptoms

On Oracle Global ATP Server 12.1.3.8, 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.

ERROR
-----------------------
ATP Processing error

ATP session file shows

Get_Res_Requirements: l_requested_res_qty := .07225375
get_res_avail
get_res_avail_opt
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
ATP_CHECK: ATP_PROCESSING_ERROR
Schedule: error := User-Defined Exception
Schedule: Resetting G_INV_CTP and G_ALLOCATED_ATP
Schedule: ATP_PROCESSING_ERROR
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.

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