My Oracle Support Banner

Item UDA LOV Values Uploaded Via Item Induction Process Fails With "Record already exists in the staging table" Error (Doc ID 2442222.1)

Last updated on APRIL 19, 2021

Applies to:

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


 After loading the UDA information via the Item Induction Process(ITEM_LOV_UDAs tab in the upload template) the following error occurs.

"Record already exists in the staging table for this item, uda id and uda value. Please delete the record to continue. SVC_UDA_ITEM_LOV."

 Steps To Recreate:

  1. Go to Foundation Data>Data Loading>Download Blank Template.
  2. Select the Type as Item and Template as Item Master.
  3. Click Download.
  4. Create the ITEM_LOV_UDAs in the .ods file.
  5. Go to Items>Upload Items from File
  6. Click Upload.
  7. Go the Foundation Data>Data Loading>Review Status.
  8. Note the above error.




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.