API 'INV_REPLENISH_DETAIL_PUB.line_details_pub' Cannot Run Properly More Than Once In The Same Session

(Doc ID 1461338.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The programmatic interface (API) for warehouse management (WMS) to allocate quantity (INV_REPLENISH_DETAIL_PUB.line_details_pub) cannot run properly more than once in the same session.

Workaround
Start another session and re-run the API.
* If a new session is not started, the API can return different result when run multiple times in the same session.

Expected Behavior
WMS API (INV_REPLENISH_DETAIL_PUB.line_details_pub) should return the same result when run multiple times in the same session.

Steps
1. Allocate the move order using INV_REPLENISH_DETAIL_PUB.line_details_pub

Return Status: S
Detailed Quantity: 400
Number of rows: 2

2. Cancel the allocation through form (Tools > Cancel Allocations)

3. Re-allocate the move order using INV_REPLENISH_DETAIL_PUB.line_details_pub

Return Status: S
Detailed Quantity: 200
Number of rows: 1

4. But if user does it in another session, cancel the allocations and rerun the API, the result will be same as the step 1.

Changes

 

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