My Oracle Support Banner

PQM_CAPA_ITEM_F Table Have Duplicate Records Inserted After Running ETL in OPLA (Doc ID 2892000.1)

Last updated on FEBRUARY 15, 2024

Applies to:

Oracle Product Lifecycle Analytics - Version 3.6.1 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior

Duplicated data found in PQM_CAPA_ITEM_F table of OPLA (Oracle Product Lifecycle Analytics)

Expected Behavior

Duplicated data not to exist in PQM_CAPA_ITEM_F table of OPLA

Steps

The issue can be reproduced at will with the following steps:

  1. Launch ODI Studio, and execute ETL
  2. After ETL is complete, log into MDS schema through sql developer, and run below sql
  3. In the sql result, can see there are duplicated rows and it shows two rows for each copy.

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.