When using an Order Base Agent to Update the SKU Upon Order Base Creation the Following Error is Seen: java.sql.SQLException: Missing IN or OUT parameter at index:: 2 (Doc ID 788417.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Logistics Inventory Visibility - Version: 5.5.04 to 5.5.05.04 - Release: 5.5 to 5.5
Information in this document applies to any platform.
***Checked for relevance on 24-Jan-2011***

Symptoms

-- Problem Statement:
On 5.5 CU4 when attempting to update the SKU quantity following an Order Base creation using an automation agent, the following error occurs:

ERROR:
java.sql.SQLException: Missing IN or OUT parameter at index:: 2

-- Steps To Reproduce:

1- Navigate to: Inventory > SKU > SKU > Create an SKU with a package Item ID.
2- Create an agent as bellow:

- Agent Type : Order Base
- Active Check Box (Marked)
- Event : ORDER BASE - CREATED
- Action : UPDATE SKU QUANTITY - ORDER BASE
(when You click on UPDATE SKU QUANTITY - ORDER BASE action, system will ask Quantity Type and Link
Criteria)

- Quantity Type : Committed
- Link Criteria : Order Base to SKU.

3- Create an Order Base with package Item ID that is defined on the SKU record.

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