Oracle Communities

Oracle Analytics and AI

Child Item

FAW HCM incremental loads

Summary:

Where can I see the FAW incremental data load process log in HCM?

Content (required):

When the FAW pipelines run to perform an incremental load, I believe the FAWService account connects to HCM and extracts the relevant data. I expect to be able to see a trace of that process in HCM. I cannot find any ESS process that was triggered. I also cannot find a trace under File Import and Export. I am interested to know what method is used to extract the data, which process is invoked by the FAWService account, and where in HCM can I find a trace of the data extraction. Does anyone know?

Version (include the version you are using, if applicable):

22R3

Code Snippet (add any code snippets that support your topic, if applicable):

Find more posts tagged with

HCM

FDI

Fusion AI Data Platform

Accepted answers

kishoregogineni

FAW uses BICC to export the data out of Cloud HCM application and then uses ODI to load data into the Autonomous data warehouse. please go through below document for more information.

https://www.ateam-oracle.com/post/fusion-analytics-warehouse-extensibility-reference-architecture

All comments

Orange

Most likely the data is extracted with REST APIs.

DAB

There is a subject area in FAW common models called "Common - Warehouse Refresh Statistics" that you can build a report off of to find out some basic information about the data refreshes that are occurring. One data element available in this is something called "Job Identifier" (e.g. 23041406368552). I am not sure where one would find this job. This Oracle LiveLab gives a basic overview to get you started in the data model:

https://apexapps.oracle.com/pls/apex/r/dbpm/livelabs/run-workshop?p210_wid=3210

The LiveLab directions only add a small number of data elements in the example given. Some others I added to my version of the report are :

Warehouse Refresh Date Time, Source Refresh Date Time, Job Identifier, Process Type, Process Description, Functional Area, Module Name, Count of Jobs, Count of Jobs with Reject Records, Table Name, Reject Record Code

kishoregogineni

FAW uses BICC to export the data out of Cloud HCM application and then uses ODI to load data into the Autonomous data warehouse. please go through below document for more information.

https://www.ateam-oracle.com/post/fusion-analytics-warehouse-extensibility-reference-architecture

kishoregogineni

FAW uses BICC to export the data out of Cloud HCM application and then uses ODI to load data into the Autonomous data warehouse. please go through below document for more information.

https://www.ateam-oracle.com/post/fusion-analytics-warehouse-extensibility-reference-architecture

ArunaMalla

date pipelines and ETL are native processes/services of any ERP offering like HCM/SCM.

it's important to note that as an HCM end-user, you generally do not have direct visibility into the internal workings of FAW or the specific data extraction processes it employs. The focus of FAW is on managing workflows, approvals, and integrations within the Fusion Applications suite, including HCM; usually done using ODI (for ETL flows) behind the scenes.

Orange

Thanks everyone, for your insights on how FAW HCM incremental loads work underneath the hood. Even though this is all managed by Oracle, I was just curious and your answers have increased my understanding.