Why Does Deletion of Records Happen on Fact Tables When Change Data Capture(CDC) Runs?
(Doc ID 2898167.1)
Last updated on SEPTEMBER 27, 2022
Applies to:
Oracle Product Lifecycle Analytics - Version 3.6.1 and laterInformation in this document applies to any platform.
Goal
Why Does the deletion of records happen on FACT tables when CDC runs?
Example FACT tables below:
Change Order (xCO) : PC_ECO_F, PC_MCO_F, PC_ECR_F, PC_ECO_ITEM_F, PC_MCO_ITEM_F, PC_ECR_ITEM_F, ITEM_ECRSS_F
CAPA : PQM_NCR_F, PQM_CAPA_F, PQM_CAPA_ITEM_F
Complaints: PQM_PR_F, PQM_PR_ITEM_F, ITEM_F
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 |