My Oracle Support Banner

UPC Delete on ItemExport Is Not Removing Data from AS_ITM_META_TAG Table (Doc ID 2115785.1)

Last updated on MAY 27, 2020

Applies to:

Oracle Retail Back Office - Version 14.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Back Office (ORBO), while importing an Item Export file, UPC Delete does not remove data from the AS_ITM_META_TAG table.


Steps to Reproduce:

1. Import an ItemExport file similar to the below example into Back Office through data import (DIMP).


3. Check AS_ITM_META_TAG and ID_IDN_PS tables.

4. Note that ID_IDN_PS has 0 rows, but AS_ITM_META_TAG still contains all 8 rows for item 000009912.

The UPC for Item 000009912 (0812066020547) is not removed from AS_ITM_META_TAG after processing UPC Delete extract.

Cause

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
Symptoms
Cause
Solution
References


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