Pick Confirm Items For Internal Requisitions Cause A Performance When Executed From API
Last updated on JUNE 08, 2017
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
On release 12.1.3 using an API to Pick Release:
Pick confirm via Public API fails for certain items on Internal Requisitions, and it is also causing a major performance.
-- Pick confirm API is called from Middleware, 1500-2000 items are called in a single request.
-- Allocation API - Customer is using these APIs and seeing a performance issue.
-- What is working --
Most of the time, this works. Occurs for any random item. Happens for Internal Orders which have >500 quantities.
External Orders do not have any issue and follows a different cycle.
This occurs in Production. Have not been able to replicate the issue in Test environment.
Items are serializable.
The Serial Numbers are passed from the external system to the pick Confirm API as parameter.
This is a Pick Confirm Issue. When tried manually, the addition of IMEIs are very slow and sometimes disconnects. Have to be loaded in a batch of 200s.
Process transaction without errors.
We have tracked the process.
Calling API and start the process as follow
1. Once the Process is called from Middleware, it is all in Oracle.
2. The control does not go back to Middleware unless there is a success or a failure.
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