Summary:
Can anyone please explain how to load the custom data from Oracle HCM Cloud to FAW?
Hi Amrit , what type of custom data do you have in Cloud HCM ? What fields have you stored this data in ? Are there any DFFs used to store this data ?
Hi Nupur,
I am looking for the DFFs and EFFs and the historical data that we have in Oracle HCM Cloud.
Thanks and Regards,
Amrit
Hi Amrit ,
Certain DFFs are supported Out of the box in the product. Can you please share which DFFs and EFFs you intend to bring in the warehouse ?
Hi @Amrit,
As Nupur mentioned, certain DFF's are available OOTB with FAW. If not, you would have to identify the VO object the DFF is available in, and, then create a data augmentation(using FAW console) to pull in the data. In some cases, you would also have the ability to select the Subject Area you would want to extend, and, the table automatically gets added to the subject area as well.
Hi @Amrita Gupta-Oracle could you please share the document that details about data augmentation related to EFFs. i can identify the view objects related to my EFFs but when i use it and select the columns i need to add. it fails with a very basic error "This Augmentation is rejected since at least one attribute selected in this datastore is not supported for extraction. Please de-select some of the attributes and retry". This error message does not help identifying the columns that is not extractable. Is there a way to identify if an EFF column is extractable or not?
Hi @Ram Bolisetty
Below is the oracle documentation related to data augmentation.
Also, have you selected the options as below -
However, for the error that you are facing, the best option would be to raise a SR with support. Since we cannot view the logs, troubleshooting the error is also not possible.
Please review the below blogs on EFF and DFF in FAW
https://blogs.oracle.com/analytics/post/enabling-descriptive-flexfields-in-oracle-fusion-analytics-warehouse
https://blogs.oracle.com/analytics/post/enabling-extensive-flexfield-in-fusion-analytics-warehouse
https://blogs.oracle.com/analytics/post/enabling-extensive-flexfield-in-fusion-analytics-warehouse-part2
Hello, Starting with the OAC September 2026 update, you’ll notice some changes to the Workbook authoring experience. The Data, Visualize, and Present tabs will no longer be displayed at the top of the Workbook. Here’s how you can navigate between these experiences going forward. Presenting and configuring a presentation…
Learn how Fusion Data Intelligence supports customization and extensibility across content, data, semantic modeling, and security. This session explains why customers extend FDI, how the FDI architecture enables governed customization, and how to choose among OAC self-service, Data Augmentation, Semantic Model Extensions,…
Under the Workforce - Absence Management subject area, the Total Duration of Absence (Days) field does not return data for Life Leave and Annual Leave Half Pay. As an alternative, I used the Absence Duration field, which successfully captures all leave types. However, it does not correctly retrieve leave records that span…
Hello Experts, I am having issue while working with HCM - Workforce Core in which I am using Person Number and Department Name. The value getting is not in line with the data in my fusion environment. Please guide what I am missing. 26C.
Team, I heard we can use the AI assistance for generating the Start model in the SME. So how to enable this feature as our instances are already in 26.R2 version. Using this blog for reference: Guided Star Schema Generation: Bringing AI-Assisted Design to Semantic Model Customization | analytics Regards, Guru
