Inventory Management - EBS (MOSC)

MOSC Banner

How to move inventory from one locator location to another?

Using Oracle EBS R12.2.12, we discovered a few items in the wrong locator bin. We have all other items in the sub-inventory in one locator and want to move these to the same. However when we try a move we get this error:

error entering a stock locator APP-FND-01048: Use of this combination restricted by WHERE clause ' ( (DISABLE_DATE > SYSDATE OR DISABLE_DATE IS NULL) AND NVL(SUBINVENTORY_CODE,'@#?') = NVL(:tomai_main_lines_blk.to_subinventory_code, '@#?') AND INVENTORY_LOCATION_ID IN ( SELECT SECONDARY_LOCATOR FROM MTL_SECONDARY_LOCATORS WHERE INVENTORY_ITEM_ID = :tomai_main_lines_blk.INVENTORY_ITEM_ID AND ORGANIZATION_ID = :PARAMETER.ORG_ID ) AND NVL(mtl_item_locations.project_id, "-99)" = NVL(:tomai_main_lines_blk.project_id, "-99)" AND NVL(mtl_item_locations.task_id, "-99)" = NVL(:tomai_main_lines_blk.task_id, "-99)" AND inv_material_status_grp.is_status_applicable( :parameter.wms_installed , NULL , :tomai_main_lines_blk.transaction_type_id , NULL , NULL , :parameter.org_id , :tomai_main_lines_blk.inventory_item_id , NULL , INVENTORY_LOCATION_ID , NULL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center