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 HCMJanuary 30, 2019
  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 ExtractsApril 25, 2019
  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… Read more: Resolve A system error occurred during processing in Extracts
• Configure GMFZT logging for an HCM ExtractApril 25, 2019
  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… Read more: Configure GMFZT logging for an HCM Extract
• New features in HCM Extracts in 19B releaseMay 10, 2019
  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… Read more: New features in HCM Extracts in 19B release
• Importing Changes Only HCM Extract post 20A updateApril 10, 2020
  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,… Read more: Importing Changes Only HCM Extract post 20A update
• Scheduling and Cancelling an existing schedule of HCM ExtractApril 16, 2020
  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… Read more: Scheduling and Cancelling an existing schedule of HCM Extract
• Skip Output file of HCM Extract when no data is fetchedApril 17, 2020
  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… Read more: Skip Output file of HCM Extract when no data is fetched
• Basics of Changes Only Functionality in HCM ExtractApril 17, 2020
  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… Read more: Basics of Changes Only Functionality in HCM Extract
• Using Table based Valueset when DBI is unavailableApril 21, 2020
  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… Read more: Using Table based Valueset when DBI is unavailable
• Most frequently used User Entities in HCM ExtractsMay 10, 2020
  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?May 11, 2020
  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 ExtractsMay 12, 2020
  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 ExtractsMay 12, 2020
  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 ExtractsMay 13, 2020
  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 guideMay 18, 2020
  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 ExtractsMay 22, 2020
  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 ModelJune 4, 2020
  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 ModuleJune 9, 2020
  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 OutputJune 30, 2020
  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 FlowJuly 1, 2020
  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?July 2, 2020
  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 FunctionalityJuly 14, 2020
  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 ExtractJuly 24, 2020
  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 ExtractsJuly 29, 2020
  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 schedulesJuly 31, 2020
  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 ReportsAugust 10, 2020
  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 ExtractOctober 28, 2020
  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 burstingOctober 29, 2020
  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 20DNovember 12, 2020
  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 refreshNovember 16, 2020
  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 20DNovember 24, 2020
  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 ExtractsFebruary 15, 2021
  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?February 23, 2021
  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 InfographicsMarch 14, 2021
  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 referenceApril 25, 2021
  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 referenceApril 27, 2021
  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 FlowsMay 31, 2021
  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 updateSeptember 7, 2021
  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 ExtractsDecember 2, 2021
  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?June 12, 2023
  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?June 29, 2023
  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?February 21, 2024
  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.
• Advanced Edit not available for HCM Extracts from 24DDecember 4, 2024
  Oracle has removed the Advanced Edit option for HCM Extracts from 24D. We will have to live with the Simplified UI going forward.

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