PQM_CAPA_ITEM_F Table Have Duplicate Records Inserted After Running ETL in OPLA
(Doc ID 2892000.1)
Last updated on AUGUST 26, 2022
Applies to:Oracle Product Lifecycle Analytics - Version 3.6.1 and later
Information in this document applies to any platform.
Duplicated data found in PQM_CAPA_ITEM_F table of OPLA (Oracle Product Lifecycle Analytics)
Duplicated data not to exist in PQM_CAPA_ITEM_F table of OPLA
The issue can be reproduced at will with the following steps:
- Launch ODI Studio, and execute ETL
- After ETL is complete, log into MDS schema through sql developer, and run below sql
- In the sql result, can see there are duplicated rows and it shows two rows for each copy.
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