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 JANUARY 08, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.