SQL Query to get the parent departments

SELECT DISTINCT dhou.ATTRIBUTE2 as Project_Code, dhou.ATTRIBUTE3 as Expense_Code, dhou.name AS DEPT_NAME, dhou1.name AS PARENT_DEPARTMENT_NAME


Grade Structure

The Grades are used to record the compensation for employees in the enterprise. You can define one or more grades that are applicable to jobs and positions. A list of valid grades can be used to restrict the grades that can be selected when you set up assignments or employment details for an employee. The recording of the Pay scale, Grade Scale, and Scale Rate would be recorded as Progression Grade Ladder in HCM Fusion.


Added a salary statement with zero increase

We have identified the issue why it's coming, and we have identified that this issue is coming because a salary section was added in the change assignment. For whenever we do the change assignment and if we do not enter any data in the salary section still system identifies that there is a change in salary so it's added a zero increase, that's why we have removed the


An employee is not able to see the existing absence record

We have researched and found that the employee is having 2 sick leaves with the same absence type, one is completed status and another one is In Progress status, so in the case by default system will show you the latest one. That's why we need to select all to see other absence records.


How to configure the Vacation rule for an employee

We have given the steps to configure the vacation rule in BPM worklist with the below steps  1. Login to Fusion Application as administrator.  2. Navigate to Worklist Application (BPM): Application Home -> Bell Icon Notifications-> More details  3. Go to your Username > Preferences > Other Rules


HR is not able to apply a leave for an employee

You need to perform the below steps in order to fix this issue.  1. Withdraw all the future absence records  2. Remove the attached work schedule and assign it again  3. Resubmit all the withdrawal absence  4. Now try to add the Sick absence


The absence duration must be greater than zero (ANC-3405003)

When the user had submitted the absence, he had a work schedule of Time type and now that has changed into Duration (Elapsed) type. The Start/End Time fields of the absence were changed to Start/End Duration. All absences with a date equal or greater than the new work schedule start date need to be re-submitted


Absence is not showing without selecting All

Since we have researched and found that the employee is having 2 sick leaves with the same absence type, one is completed status and another one is In Progress status, so in this case, by default system will show you the latest one. That's why we need to select all to see other absence records.


Employee cannot add the absence in the future date

We have an absence type called Vaccine, and the client wants that this absence-type employee can add the day of vaccination not before that. For that, we have written a fast formula in order to achieve this requirement. DEFAULT FOR IV_START_DATE is '0001/01/01 00:00:00' (Date


Not able to delete the withdrawn absence record

There are some steps that we need to follow. - My Client Groups - Absence  - Configure Absence Batch Parameter


How to configure the CEO approval rule for absence

((absencesApprovalsRequest.absenceType == "Holiday") OR (absencesApprovalsRequest.personId != 100000000000000))


Delete absence enrollment overview

From Release 12, you can delete invalid enrollment permanently. Important: Deleting enrollment removes all data including accruals, adjustments, initialized balance, and absence details for the plan enrollment. Evaluate all your options before deleting an enrollment.


Absence Work Schedule

A work schedule determines the time when a worker is available and unavailable for work and includes: · Shift · Patterns · Calendar Event


Client wants that employee cannot add the absence type in the future date, it should be today’s day only. We have written the fast formula.

FORMULA NAME: ABC Formula FORMULA TYPE: Global Absence Entry Validation DESCRIPTION: This formula validates the absence type Name Date First Name Last Name 01/01/1951


Can we create Absence Pattern

No, it’s delivered by Oracle


What are the delivered Absence Pattern

Illness or injury Childbirth or placement Generic absence


Deferred processing on initial entry

Whenever an employee applies for leave, wait for some background process to run then update the leave application or you don’t want to differed it, so differed means you postponing the process, if you don’t differ it then it will immediately sent to the manager for approval and once the manager approved then it will be updated in the system and deducted the balance


Additional payload attribute

If you want to load any additional attributes for the absence management, DFF something like that then you have this rule.


Can learners be bulk enroll to a course using spreadsheet or CSV

Yes, enable the below profile option STEPS TO ENABLE Enable the profile option WLF_ENABLE_DEST_PERSON_LIST using these steps: Navigate to the Setup and Maintenance work area. Search for and click the Manage Administrator Profile Values task. Search for the WLF_ENABLE_DEST_PERSON_LIST profile option code and select the profile option in the search results. In...