My Oracle Support Banner

ItemLocCre Message Fails In MPS_STAGED_MESSAGE Table In Case UINAttributesImport Batch Is Used To Configure UINs. (Doc ID 2445640.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 16.0.1 and later
Information in this document applies to any platform.


ItemLocCre message fails in MPS_STAGED_MESSAGE table in case UINAttributesImport Batch is used to configure UINs.

The issue can be reproduced at will with the following steps:

  1. Create an item in SIM.
  2. Do not create any item locations for this item.
  3. Run UINAttributesImport batch to configure store dept for UIN.
  4. Batch populates store_uin_admin_item table even if item-location not exists yet in the system.
  5. Try to create item-loc for the location configured in point 3) and item created in point 1).
  6. Message fails with error ORA-00001: unique constraint (SIM16.STORE_UIN_ADMIN_ITEM_UK) violated




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.