Fusion Analytics Warehouse

Products Banner

FAW HCM incremental loads

Accepted answer


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):


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


Best Answer


  • Orange
    Orange ✭✭✭

    Most likely the data is extracted with REST APIs.

  • DAB
    edited April 14

    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:


    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

  • 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.


  • ArunaMalla
    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
    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.