Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

FAW HCM incremental loads

Accepted answer
412
Views
6
Comments
Orange
Orange Rank 5 - Community Champion
edited August 2024 in Oracle Fusion Data Intelligence

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

Tagged:

Best Answer

Answers

  • Orange
    Orange Rank 5 - Community Champion

    Most likely the data is extracted with REST APIs.

  • DAB
    DAB Rank 1 - Community Starter
    edited April 2023

    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
    kishoregogineni Rank 2 - Community Beginner

    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
    ArunaMalla Rank 3 - Community Apprentice

    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 Rank 5 - Community Champion

    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.