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 MAY 06, 2022
Applies to:Oracle Logistics Inventory Visibility - Version 5.5.04 to 5.5.05.04 [Release 5.5]
Information in this document applies to any platform.
-- 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:
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document