My Oracle Support Banner

Getting Duplicate Error in PRICE HIST File (Doc ID 2817674.1)

Last updated on NOVEMBER 02, 2021

Applies to:

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

Goal

While trying to load PRICE_HIST data through Data Conversion (DC) tool using PRICE_HIST entity and providing ID column as null in the file, only first row is getting processed and second record is failing with duplicate record error.

Can we make the DC tool to default the value for ID using <RMS SCHEMA>.PRICE_HIST_ID_SEQ sequence while loading PRICE_HIST data ?
 

Solution

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