SIM ItemLocMod Message Modify Improperly UIN Settings In STORE_ITEM Table (Doc ID 2460601.1)

Last updated on MAY 16, 2022

Applies to:

Symptoms

SIM ItemLocMod message modify improperly Unique Identification Number(UIN) settings in STORE_ITEM table, UIN_REQUIRED has been set to 'N', if changing the status of an item/loc from Inactive to Active.
ItemLocCre works as expected

Steps To Recreate:

1. Make sure that parameter AUTO_DEFAULT_UIN_ATTRIBUTES is set to true in .
2. Choose item which is managed in SIM with UINs (store-dept-class is managed with UINs in store_uin_admin_dept table) and item-location not yet exists in the system.
3. Create item-location for chosen item (point 2) in Inactive status (I). Do not specify any details about UIN management. All the details should be defaulted from SIM settings.
4. Confirm that Item-location has been created correctly and all the details about the UIN are correctly set (exists row in store_uin_admin_item and STORE_ITEM.UIN_REQUIRED is set to 'Y').
5. Activate item-location using ItemLocMod message (do not provide any details about UIN management in the message).
6. Check that item-location has been activated as expected. Correct behavior.
7. Check that STORE_ITEM.UIN_REQUIRED has been set to 'N', witch is incorrect.
   
   

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.