Etext template tips and tricks Part 2
Do you know the functions that can be used in etext template? Have you faced issues with getting the sample functions to make them work?
SQL Query to get Source System IDs for all Business Objects
In one of our previous articles, we have seen how to configure Source System Owner in Fusion.Defining Source System Owner for HDL in Fusion Source System Owner and Source System ID are the Source Keys which we use to load/update data using HCM Data Loader (HDL). HRC_INTEGRATION_KEY_MAP is the underlying base table which stores the Source Keys for all business…
New Deadline for Payroll Batch Loader 20D Nov 2020
In this post we will look into the PBL to HDL mapping for business objects and things that we need to take care of before the PBL is decommissioned by 20D. If you check the previous article Oracle has provided a deadline of 20C for decommissioning Payroll Batch Loader aka PBL. However they have now postponed it by a release to…
Modified Task/Action Names in Fusion HCM 20A
We have an undocumented change from 20A which changed the task names across most of the tasks. Oracle has removed the word "Manage" from most of the tasks and Oracle has not documented it in any of the readiness/new feature documents. When a lot of customers posted questions on Cloud Customer Connect then product managers from Oracle responded that this…
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…
Sample HCM Data Loader (HDL) files for all Business Objects
Are you facing issues with loading dat files to HCM Data Loader and need help with the sample files? You can get sample HDL files for most of the business objects in this article.
How to get Position Hierarchy in SQL Query?
We can use the below query to get the Position Hierarchy of a Position traversing up to the top level. SQL Query: SELECT hap.POSITION_CODE ,hap.position_id ,hap.name ,(SELECT name FROM HR_ALL_POSITIONS WHERE POSITION_ID = pphf.PARENT_POSITION_ID ) Parent_Position_NAME ,decode(hap.ACTIVE_STATUS, 'A', 'Active', 'I', 'Inactive') ACTIVE_Status ,pj.manager_level ,pj.name FROM HR_ALL_POSITIONS hap ,PER_JOBS_F_VL PJ ,PER_POSITION_HIERARCHY_F pphf WHERE hap.POSITION_ID = pphf.POSITION_ID AND hap.job_id = pj.job_id AND…
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…