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.
All posts on HCM Extracts
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 on HCM Extracts Basics of…
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 which are inbuilt functionalities. For…
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 please Click here Even if there…
Configuring Payroll Process Configuration Groups
In this article we will look into setting up Payroll Process Configuration Groups and SQL Query to extract data. Want to learn Fusion Technical tools? Check out the article We use the Payroll Process Configuration groups while submitting HCM Extracts. These Configuration groups specify the multi threading count, BI output maximum size, GMFZT logging etc. We can navigate to this page…
Using Flow Schedule Fast Formula to Schedule Extracts
In this article we will look into how to schedule the HCM Extracts at ad-hoc schedules or complex schedules which cannot be handled using a simple way. In our previous article we saw how to Schedule/Cancel Schedule for HCM Extracts. Click here if you have missed to look at it.The previous article covers scheduling Extract at Once/Daily/Weekly/Monthly frequency only. However if we…
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 Scheduling an HCM Extract: Navigate to Payroll > Checklist orMy Client Groups > Data Exchange > Submit ExtractsSearch for the extract and click Next Submit Extracts…
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, Oracle has added an "Incremental"…
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 as the DBI name. Most…
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 logging using the task "Manage…