ATP Processing Error When Scheduling An Order - ATP Session file Shows ORA-6533 and ORA-2064 (Doc ID 811499.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

***Checked for relevance on 17-May-2011***

On 11.5.10.2 in Production:
When attempting to enter line and check ATP, the following error occurs.

ERROR
Scheduling failed. ATP processing error

STEPS
The issue can be reproduced at will with the following steps:
1. Enter a line and check ATP

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot enter a line

.In the ATP session file generated on the APS Destination instance we see the following error


**********Begin Delete_Row Procedure************
Delete_Row: p_plan_id := -1
 identifier := 38544907
 p_config_line_id := 
Ato model line id := 
DELETE_SUMMARY_ROW: Inside delete summary row
DELETE_SUMMARY_ROW: p_identifier := 38544907
DELETE_SUMMARY_ROW: p_instance_id := 1
DELETE_SUMMARY_ROW: l_inventory_item_id.count := 1
DELETE_SUMMARY_ROW: l_user_id := -1
DELETE_SUMMARY_ROW: l_sysdate := 15-APR-09
DELETE_SUMMARY_ROW: Row found, delete it from summary
DELETE_SUMMARY_ROW: l_ivnevtory_item_id := 399253
DELETE_SUMMARY_ROW: l_organization_id := 1
DELETE_SUMMARY_ROW: l_demand_class := @@@
DELETE_SUMMARY_ROW: l_sd_date := 15-APR-09
DELETE_SUMMARY_ROW: l_sd_qty := 1
DELETE_SUMMARY_ROW: l_instance_id := 1
DELETE_SUMMARY_ROW: update failed, now try insert
Delete_Row :-2064: ORA-02064: distributed operation not supported


ATP session file generated on the ERP source instance shows

 l_status_flag := 2
Records Retrieved := 0
Before calling Custom_Post_ATP_API
Enter Custom_Post_ATP_API
Exit Custom_Post_ATP_API
after calling Custom_Post_ATP_API
l_custom_ret_sts := S
l_modify_flag := 2
Error in Call_ATP_No_Commit :-6533
Call_ATP_No_Commit: ORA-06533: Subscript beyond count

Call_ATP_No_Commit: shipset count 1
Call_ATP_No_Commit: Exception x_return_status : S

Changes

Customer setup Distributed installation for the first time where APS applications are on separate instance from ERP Source applications.

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