My Oracle Support Banner

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

Last updated on JUNE 19, 2018

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
API:INV_REPLENISH_DETAIL_PUB.Delete_Details: INVTOTXB.pls


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.
Video - Move Order API vs. Form (04:56)


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.
Note: This is working correctly.


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.
Note: Expected BOTH the allocation to be removed AND the quantity allocated changed to zero.


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

...
INV_REPLENISH_DETAIL_PUB.delete_details(
...

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.