When a UPC (Ref Item) Is Deleted from a SKU in RMS, the UPC Is Not Deleted from the SKU in Oracle Retail Back Office
Last updated on DECEMBER 02, 2016
Applies to:Oracle Retail Back Office - Version 13.0 to 13.1 [Release 13.0 to 13.1]
Information in this document applies to any platform.
When deleting items using DIMP to import Oracle Retail Merchandising System (ORMS) bundles, the ID_IDN_PS table is not updated in Oracle Retail Back Office. This prevents the barcode associated with a deleted item from being used by a new item.
Steps to Reproduce:
- Import an RMS bundle to delete an item.
- Check the ID_IDN_PS table for that item number.
- Observe that the UPC is not deleted.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms