top of page



Important SQL Queries related to the ICPs (Individual Compensation Plans)
This article aims to discuss several key SQL queries related to the ICP, which assist in validation within fast formulas and other areas.
Jan 12 min read
306 views
0 comments


Commonly Used Administrator Profile Values in HCM
CMP_DISABLE_PENDING_APPROVALS_CHECK_IN_MANAGE_CONTRIBUTION Enable the option to allow individuals to submit additional personal...
Feb 2, 20241 min read
134 views
0 comments


How to Create a BIP Report in Oracle Fusion Hcm
Let’s discuss how to BIP Report in oracle fusion HCM Step by step. 1. Go to the oracle login page and fill the id and password then sign...
Nov 8, 20232 min read
413 views
1 comment


Enabling Environmental Health and safety (EHS) module in HCM
Lets collectively enable the Health & Safety module in the HCM applicaion in this blog. Before Starting implementing health and safety...
May 19, 20232 min read
85 views
0 comments


Running your first SQL Query in Oracle Fusion HCM
Let's Discuss how to run SQL query in oracle fusion HCM Step by step. Step 1 : Go to the oracle login page and fill the user id and...
May 4, 20231 min read
297 views
0 comments


Eligibility profile in Fusion HCM application : Basics
An Eligibility profile in Fusion HCM (specifically Core HR, Absence Management, Compensation and other modules) is used to define the...
Apr 7, 20232 min read
231 views
0 comments


SQL query to Get the Payroll Frequency and Name of any Employee
Below query will give the Employee details with the Payroll Relationship details assigned to them. SELECT peo.PERSON_NUMBER,...
Dec 12, 20221 min read
595 views
0 comments


HDL Template for Fusion HCM Mass Load
HDL stands for HCM Data Load, an easy way to load mass data for different objects in Fusion application. This article is to compile all...
Aug 23, 20221 min read
358 views
0 comments


SQL Query to Get Department, Grade, Job details
This article will provide SQL query snippet to pull up Department, Grade, Job details. There are two scenarios : Latest Department,...
Jan 8, 20223 min read
26,107 views
0 comments


HR Functions Are Not Bound by Company Size
Entrepreneurs and startup CEOs are notorious for being a “jack of all trades,” adept at solving many different types of problems while...
Sep 24, 20213 min read
41 views
0 comments


Compa-Ratio : Calculation, Connection, Configuration, UI Display
Compa-Ratio also known as Comparative or Comparison Ration. Employees within the organization works on their specific grades, and each...
Sep 20, 20211 min read
700 views
0 comments


Debugging Fast Formula when logs are not generating
But there are cases which does not generate logs, and it becomes very difficult to debug and traverse our FF code. Examples are - Checklist
Jun 12, 20201 min read
2,497 views
1 comment


Scheduled Processes in HCM
Scheduled processes are available with purpose to serve routine tasks on specific time with no manual intervention.
Jun 11, 20201 min read
1,447 views
0 comments


Include aggregate functions in Table Type Value Sets
Include aggregate functions in Table Type Value Sets
Jun 2, 20202 min read
4,349 views
4 comments
bottom of page