Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- 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
