API INV_REPLENISH_DETAIL_PUB.Delete_Details - Deletes Allocations But Does NOT Change Move Order Allocation Quantity (Doc ID 1346196.1)

Last updated on OCTOBER 28, 2024

Applies to:

Symptoms

The API INV_REPLENISH_DETAIL_PUB.Delete_Details will unaollocate the move order by removing pending transactions but the API is NOT updating the allocated quantity (MTL_TXN_REQUEST_LINES.quantity_detailed).

Expected Behavior
Expect that the API (INV_REPLENISH_DETAIL_PUB.Delete_Details) would remove allocations and set the allocated quantity to zero.

What is working
Cancelling allocations on the Transact Move Order form correctly removes allocations and sets the allocated quantity to zero.

Steps:
The following steps show the API vs. Form. The steps work correctly in the form but the API does not clear the allocated quantity.
 


A. Working In Form

1. Navigate to Inventory > Move Orders > Move Orders
2. Create and approve a move order
3. Navigate to Inventory > Move Orders > Transact Move Orders
4. Allocate the move order
5. Select the move order line.
6. Choose Tools > Cancel Allocations
7. The allocation is removed and quantity allocated goes to zero.

B. API Call

1. Navigate to Inventory > Move Orders > Move Orders
2. Create and approve a move order
3. Navigate to Inventory > Move Orders > Transact Move Orders
4. Allocate the move order
5. In SQL, run the API (INV_REPLENISH_DETAIL_PUB.Delete_Details).
6. Commit.
7. The allocation is removed BUT the quantity allocated is unchanged.

Sample API Call
Download a sample of the API call from the Note here - SampleAPI.sql.

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.