Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Data Augmentation not pulling data for some records
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
Answers
-
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:
Thank you,
Rajesh L
0