Implement Locator in Existing Subinventories - Stock Exists

 

Change a existing Sub-Inventory to Locator Subinventory in Oralce EBS R12:

The cause is that on-hand quantity or pending transactions or uncosted transactions exist in the subinventory S99.
You can confirm if records exist by the following queries

To implement the solution, please execute the following steps first in a test environment.

Onhand Quantity:

SELECT count(*)
FROM mtl_onhand_quantities_detail
WHERE organization_id = 106
AND subinventory_code = 'S99';

Pending Transactions:

SELECT count(*)
FROM mtl_material_transactions_temp
WHERE organization_id = 106
AND (subinventory_code = 'S99' or transfer_subinventory = 'S99');

Uncosted Transactions:

SELECT count(*)
FROM mtl_material_transactions
WHERE organization_id = 106
AND subinventory_code = 'S99'
AND costed_flag in ('N','E');

ACTION PLAN
------------------------------------

Issue all associated on-hand quantities from the S99 subinventory or move to a temporary subinventory before trying to update the locator control.
Also process any pending transactions or uncosted transactions that are associated to S99 subinventory.

Once the subinventory has 0 on-hand quantities and no pending transactions and no pending uncosted transactions you can update the Locator Control setup from 'None' to 'Prespecified'.