You are currently viewing Learn HCM Extracts online
Learn HCM Extracts online

In this article I will guide you through learning HCM Extracts and some of the advanced features of HCM Extracts including user entities, dbis, valuesets, Fast Formula, delivery options etc.

Links to the HCM Extracts articles:

  • Basics of HCM Extracts in Fusion HCM
    Do you know the basics of HCM Extracts and types of extracts? How to implement Changes only fucntionality? Read on to know more details.
  • Resolve A system error occurred during processing in Extracts
    Many a times we get errors when we run HCM Extract and one of the common errors is “A system error occurred during processing. Contact your help desk” and it does not show up any other clue on why the extract is failing. If we dig into details and add the GMFZT logging at system…
  • Configure GMFZT logging for an HCM Extract
    In this post we will look into setting up the GMFZT logging for HCM Extracts. This logging will show the diagnostic results of extract run in the log file, which will be internally used by the Oracle team to look into issues if we raise an SR for HCM Extract issues. We can setup the…
  • New features in HCM Extracts in 19B release
    We will look into the new features introduced in 19B for HCM Extracts. Oracle has completely revamped the User Interface for HCM Extracts. Below are the features that have been added: We can add multiple Database Items at one go by selecting the DBIs and clicking on Add button. We would get the XML tag…
  • Importing Changes Only HCM Extract post 20A update
    When we migrate the HCM Extracts to other PODs, we normally export the HCM Extracts from Source instance and Import them to the Target instance. However there has been some changes from 20A which needs to be considered while importing the HCM Extracts, else the changes only functionality won’t work for imported extracts. From 20A,…
  • Scheduling and Cancelling an existing schedule of HCM Extract
    In this article we will look at how to schedule and cancel an existing schedule of HCM Extract. If you haven’t gone through the basics of HCM Extract, please have a look by clicking here Table of Contents Scheduling an HCM Extract: Navigate to Payroll > Checklist orMy Client Groups > Data Exchange > Submit ExtractsSearch…
  • Skip Output file of HCM Extract when no data is fetched
    In this article we will look into how modifying the HCM Extract not to generate output file when data is not fetched by HCM Extract. Normally a blank file will be generated by the HCM Extract when there is no data fetched by the Extract. If you want to know the basics of HCM Extract…
  • Basics of Changes Only Functionality in HCM Extract
    In this article we will cover the interesting and quite confusing topic of HCM Extracts (Changes Only Functionality) in detail. If you are new to HCM Extracts, please go through the below links to get an idea on it before reading further: We mainly use HCM Extracts for the changes only and multi threaded processing…
  • Using Table based Valueset when DBI is unavailable
    When we develop integrations using HCM Extracts, we normally come across many scenarios where in we are unable to get all the attributes required using the Database Items (DBIs) for the integration using a single/multiple User Entities (UEs). If you are new to HCM Extracts, I would suggest you to read through the below articles…
  • Most frequently used User Entities in HCM Extracts
    Do you know the list of Person, Assignment, Setup, History and Future User Entities in HCM Extracts? Want to know the most frequently used UEs? Read on to know more details.
  • How to view the output of HCM Extract run by other users?
    Do you know how to view output of HCM Extract which is run by other user in Fusion HCM? Is it possible to view output like that? Read on to know more details.
  • How to link/connect the User Entities in HCM Extracts
    Do you know how to link/connect the User Entities and which UEs can be used as Root Data Groups and which ones cannot and how to identify them? Read on to know more details
  • Fix for assertion failure error in HCM Extracts
    Have you faced the error “An assertion failure was detected at location ProcReportPayAct.childRequestStatus:1” in HCM Extracts? Do you know how to resolve it in a couple of steps? Read on to know more details.
  • Top 50 Interview questions and answers on HCM Extracts
    Top 50 Interview Questions with answers on HCM Extracts with real time scenarios in Fusion HCM. Can you answer them if you were asked during an interview? Read on to know more details.
  • HCM Extracts Dynamic Output Filename guide
    Do you know how to get the dynamic name for output file in HCM Extracts using %y%m%d parameters? Do you know the full list of parameters? Read on to know more details.
  • SQL Query to find scheduled HCM Extracts
    Do you know how to find out the scheduled HCM Extract details of other users also? Who scheduled it, what are the parameters, etc. Read on to know more details
  • Achieve complex requirements using Custom Global Reports Data Model
    Do you know that we can customize the global reports Data Model and modify the seeded Data Set query to achieve complex requirements? Read on to know more details.
  • Payroll Flow and HCM Extracts Mapping for Payroll Module
    Here is the list of Payroll flows mapped to the HCM Extract and BI Report for Payroll Module. Use this exhaustive list to find out extract and customize the templates when you have requirement.
  • Hiding XML nodes in HCM Extract Output
    Do you know how to hide the XML tags on HCM Extract output? Can you hide all tags or is there any restriction? Read on to know more details.
  • Running the latest extract version using Payroll Flow
    Have you faced issues with multiple versions of extracts? How do you migrate the extract changes to other instances when the target instance already has the extract? Read on to know more details.
  • How to convert HCM Extract Export XML to Readable format?
    Can you read through the HCM Extract Export XML file? Do you know you can do it easily with the help of XSL tool? Read on to know more details.
  • Deleted Data Report using Audit Functionality
    Do you know that you can fetch deleted data for business objects in Fusion if Auditing is turned ON? Read on to know more details.
  • Passing Logged in User details to HCM Extract
    Do you know that you can get the Logged In User details in HCM Extract? Why the seeded functions which return user details in BIP does not work in advanced filter directly? Read on to know more details.
  • How to handle FF not compiled error for HCM Extracts
    Do you know how to resolve the Fast Formula is not compiled error for HCM Extracts? What are the alternatives if the issue doesn’t get resolved at all. Read on to know more details.
  • How to handle Daylight Savings timings for HCM Extract schedules
    Do you know how to handle the extract schedules during the Daylight Savings Time (DST)? The schedule timings vary by an hour during the DST. How to automatically handle the schedule timings? Read on to know more details.
  • HCM Extracts Design and Run Time Diagnostics Reports
    Do you know how to analyze the extract to see if there are any design or run time issues? There is a Seeded Diagnostics Report which displays this info. Read on to know more details.
  • Implementing Bursting feature for HCM Extract
    Do you know how to implement Bursting feature in HCM Extract? Do we need to create Custom Data Model for it? Read on to know more details.
  • Resolve HCM Extract No data error when using bursting
    Do you know if there is a solution to resolve the Extract getting errored out when no data is fetched when using bursting feature? Read on to know more details.
  • Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D
    Do you know that you can fetch the HDL Imports and HCM Extract Run Details using OTBI from 20D? Read on to know more details.
  • Solve manual FTP server update issue for HCM Extracts post every P2T refresh
    Tired of manually updating HCM Extracts after every P2T refresh? Do you know there is an automated solution for it? Read on to know more details.
  • Renaming HCM Extracts is a possibility from 20D
    Do you know that you can rename HCM Extracts to a different name from 20D? Have you tried this feature yet? Read on to know more details.
  • Resolve Fast Formula not compiled issue in HCM Extracts
    Do you know how to resolve the “FF not compiled error” in HCM Extracts even though you see all status as compiled? Read on to know more details.
  • How to generate CSV output from BI Reports/HCM Extracts?
    Do you know how to generate CSV output from BI Report/ HCM Extracts? Do you know all possible ways of doing it? Read on to know more details.
  • HCM Extracts Infographics
    Check out the HCM Extract Infographics to get an idea on the HCM Extracts features, types, building blocks, delivery options, changes only modes and Output types supported.
  • Sample Extract Criteria Fast Formulas for ready reference
    Do you know how to use Extract Criteria Fast Formulas? We can exclude/include the data retrieved by the user entity. Check out samples FFs to include active employees, include based on DFF, only top of stack, exclude ees based on BU, exclude termed ees before 7 days and include US employees only.
  • Sample Flow Schedule Fast Formulas for ready reference
    Do you know how to use Flow Schedule Fast Formulas? We can Schedule extracts at adhoc frequency. Check out Sample Flow schedule FFs for every 30 min, every 5 min, only weekdays, 1st of every month and between a specific time.
  • How to enable Error/Warning Notifications for HCM Extracts/ Payroll Flows
    Do you know how to enable Error/Warning notifications for HCM Extracts. This feature will be very useful when integrations are scheduled to know the status. Read on to know more details.
  • How to capture Vendor name in HCM Extracts post 21D update
    Do you know the new feature of capturing Vendor names in HCM Extract post 21D update? Read on to know more details.
  • SQL Query to fetch Delivery Option details for HCM Extracts
    Do you know how to fetch the delivery options for HCM Extracts using BI Report? Read on to know more details.
  • How to get list of Fast Formulas used in HCM Extract?
    Do you know how to get the Fast Formulas used in a HCM Extract? If there are multiple Data Groups and multiple Records, it will be tough to get the list manually? This SQL query comes as a saviour in those tough times to get the list easily. Read on to know more details.
  • How to query the HCM Extract Errors?
    Do you know how to extract the HCM Extract errors? Where would you check the errors of the extract on the application? Read on to know more details.
  • How to enable Advanced Edit for HCM Extracts in 24A?
    Have you found the Advanced Edit option for HCM Extracts after 24A update? Are you missing this option? Read on to know how to enable this option after 24A update.

The above list keeps refreshing whenever latest content is being added on HCM Extracts. Keep checking for latest updates.