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
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***
On 5.5 CU4 when attempting to update the SKU quantity following an Order Base creation using an automation agent, the following error occurs:
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
- 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms