Hi Ionut,

Very Grateful for Quick and Precise Answer , Point no 3 Is solve my problem it has Restriction check box check.

Appreciate your help.

Thanks

Altaf Shaikh

Hi Altaf,

Please find below a few points to check :

1. Check Locator Setup (based on your post i assume this is fine)Ensure the locator is accurately defined for the correct Organization and Subinventory.
   Go to: Inventory > Setup > Organizations > Locators
   Make sure the Locator Type and attributes (such as Active, Enabled, etc.) are set properly.
2. Assign Locator to Subinventory (based on your post i assume this is fine Go to: Inventory > Setup > Organizations > Subinventories
   Query the concerned subinventory.
   In the Locators section, ensure your new locator appears and is checked as Enabled.
3. Subinventory Locator ControlCheck if the Subinventory uses Locator Control: Prespecified/Restricted/None.
   If set to Prespecified or Restricted, only assigned locators will appear in LOV during transactions.
   If None, no locator will be prompted.Make sure the subinventory is not set to None if you want to see locators.
4. Check Start Date/End DateConfirm that your locator's Start Date is today or earlier, and End Date is blank or in the future.
5. Organization AccessEnsure that you have roles and organization access for the one where locators are defined
6. Check Data in SQL

SELECT *
FROM MTL_ITEM_LOCATIONS
WHERE SUBINVENTORY_CODE = '&subinventory_code'
AND DESCRIPTION = '&locator_name';

 If this returns no rows, your locator is not assigned properly.

7. Compile Value Sets and Flexfields (Stock Locators)

Check if Stock Locators flexfield is compiled successfully, you can try to unfreeze and freeze to trigger recompiling.

8. Validate other transactions like miscellaneous receipt into the newly created locator

If none of the above helps, you can raise a service request to look into it further.

Regards,

Ionut

Very useful information, Thanks Lonut

Thanks, Ionut-Oracle

its resolved my issue.

Thanks for your useful information.

Hi Qamar,

Thanks for following the correct approach to issue out the on hand prior to updating the serial attribute.

Regarding performing miscellaneous receipt with serial number in bulk, i recommend using Material Transactions Interface to do it.

You need to populate mtl_transactions_interface and mtl_serial_numbers_interface tables with the needed data, then launch the Inventory Transactions Manager (INCTCM) through the Interface Managers Window or wait for some time for it to process the records (customers usually have this manager scheduled to run every 5 minutes).

Please refer to the below note for sample scripts of inserting the data in the interface tables :

Sample WMS Open Interface Insert Scripts -- How To Insert Into Transaction Open Interface MTL_TRANSACTIONS_INTERFACE Table (Doc ID 357535.1)

Focus on Scenario 6:  Misc. Receipt (with LPN and serial).

In case you do not use Warehouse Management or the organization is not WMS enabled, you can ignore populating the LPN columns.

Regards,

Ionut