My Oracle Support Banner

W_PDS_PRODUCT_JOB Fails with "Unique Constraint (RABE01USER.PK_W_RTL_ITEM_PARENT_TMP) Violated" (Doc ID 3005871.1)

Last updated on APRIL 29, 2024

Applies to:

Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 23.2 and later
Oracle Retail AI Foundation Cloud Service - Version 23.2 and later
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version 23.2 and later
Information in this document applies to any platform.

Goal

The W_PDS_PRODUCT_D_JOB for process LOAD_PDS_PROD_DIMENSION_PROCESS is failing with the following error:

 

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!

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