OPLA 3.5 After CDC Load, GATE_USRDEF_LIST0 Data For All Rows Has Changed To 'UNDEFINED' (Doc ID 2261368.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Product Lifecycle Analytics - Version 3.5.0 to 3.5.0 [Release 3.5.0]
Information in this document applies to any platform.

Symptoms

On : 3.5.0 version, OPLA CDC load data discrepancies

ACTUAL BEHAVIOR
---------------
Select * from PPM_ACTIVITY_D where GATE_USRDEF_LIST0!='UNDEFINED'
After CDC load, the query is not returning any results and the data for all rows has changed to 'UNDEFINED'

EXPECTED BEHAVIOR
-----------------------
After CDC load, the query should return all rows in results without any issue.

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

1. Mapped GATE_USRDEF_LIST0 to Gates. Sub Gate Type and run Full ETL.
2. Data is coming as expected in PPM_ACTIVITY_D table for GATE_USRDEF_LIST0.
3. Run  CDC load
4. Data is not populating in STAGE itself in ODM_PRG_GATES for LIST0_ID.

After FULL load, the below query returns correct data for that list.
Select * from PPM_ACTIVITY_D where GATE_USRDEF_LIST0!='UNDEFINED'

After CDC load, the above query is not returning any results and the data for all rows has changed to 'UNDEFINED', Observed data discrepancies for one of the list under Gates.


Changes

 

Cause

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 hundreds of Community platforms