Data Augmentation not pulling data for some records

Question

Hi,

I have created a data augmentation to get a column from OTBI to FAW.

Recently, I noticed that some records it is not pulling up the value, even though there is data on the frontend and in OTBI.

Can anyone help me understand or guide me what exactly I can check to get the issue.

Note: - PVO used - HcmTopModelAnalyticsGlobalAM.AssignmentAM.WorkRelationshipPVO

Thanks

Rajesh L-Oracle · Answer

Hi Ruvina, the common reason for some records not pulling via Data Augmention is when FAW marks them as duplicates based on primary key or rejects them due to null value - you will find them as Rejected records in Data Warehouse Refresh Subject Area.

ALSO you must ensure that any column with primary key doesn’t have null values, otherwise the extract process rejects the entire dataset or table. If there are multiple columns with primary keys, then you must ensure that none of those columns have null values. If any of them have null values, then Oracle Fusion Analytics Warehouse rejects the entire extraction job. If Oracle Fusion Analytics Warehouse rejects the extraction job, then the corresponding augmentation is also rejected.

Please use following steps from FAW documentation:

https://docs.oracle.com/en/cloud/saas/analytics/23r3/fawag/view-records-rejected-extraction.html#GUID-D1A3D4FF-01AE-4A4D-92E5-C3F9671DA6D1

https://docs.oracle.com/en/cloud/saas/analytics/23r3/fawag/augmenting-your-data.html#GUID-9629669C-3DCF-451D-BDA3-187366350973

Thank you,

Rajesh L