My Oracle Support Banner

Item Translation Delete Through API (Doc ID 2966575.1)

Last updated on AUGUST 09, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Symptoms


When attempting to create the same translation for the same item, after deleting the translation, over API the following error occurs.

ERROR

"Record already exists in the staging table for this item and lang. Please delete the record to continue. SVC_ITEM_MASTER_TL".


STEPS

The issue can be reproduced at will with the following steps:
1 - Create a translation for an item
2 - Delete the translation for that item
3 - Re-create the same translation for that item

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users have to wait for the batch "itm_indctn_purge", before they can create a new translation for the previous deleted translation.

Changes

 

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
Changes
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.