Wheebox Assessment tests (ORC-HCM) Query
Introduction: This SQL query is used to fetching the data for candidates who are applied various assessment tests (Wheebox) at the time of recruiting like one candidate can apply two…
Read MoreQuery to get Data Accesses of Users – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data access details of all the users irrespective of their status. Cause of the issue: Business…
Read MoreEmployee Recall Query – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data of employees who are recalled to join the organization. Cause of the issue: Business wants…
Read MoreHow To Get Business Unit Of Customer in Fusion Receivables
Introduction: Customer & Business Unit link Table in Oracle Fusion. Cause of the issue: Since the customer is not assigned to a BU in Fusion. Customer Site is assigned to…
Read MoreTravel Expenses Query – Fusion Expense Module
Introduction: This blog has the SQL query that can be used to pull Travel expense data from Fusion Expense Module. Cause of the issue: Business wants a report that contains…
Read MoreEmployee Expenses Query – Fusion Expense Module
Introduction: This blog has the SQL query that can be used to pull employee expenses data from Fusion Expense Module. Cause of the issue: Business wants a report that contains…
Read MoreQuery to Extract Absence and Long Leave details in Oracle Fusion HCM
Query: SELECT empl_leave_trxn_id, employee_id, leave_name, leave_type_id, To_char(start_datetime, ‘DD-MON-YYYY’) from_date, To_char(end_datetime, ‘DD-MON-YYYY’) to_date – ,CASE WHEN absence_type =’Permission Leave’ THEN TO_CHAR(START_DATETIME, ’DD-MON-YYYY HH24:MI:SS’) ELSE from_date END from_date – ,CASE WHEN absence_type =’Permission Leave’ THEN TO_CHAR(END_DATETIME, ’DD-MON-YYYY HH24:MI:SS’) ELSE TO_date END to_date , absence_type –,CASE WHEN absence_type !=’Permission Leave’ THEN days ELSE NULL END days , CASE WHEN absence_type NOT LIKE ‘Permission%’ THEN days ELSE NULL END days – ,reason – ,CASE WHEN absence_type =’Permission Leave’ THEN (days *60) ELSE NULL END permission_minutes – ,CASE WHEN absence_type LIKE ’Permission%’ THEN (days *60) ELSE NULL END permission_minutes , CASE WHEN absence_type LIKE ‘Permission%’ THEN Round(( days * 60 ), 0) ELSE NULL END permission_minutes, reason, transaction_date, comments_and_description, CASE WHEN absence_status_cd = ‘ORA_WITHDRAWN’ THEN ‘WITHDRAWN’…
Read MoreGrade Creation Notification in Fusion HCM via Alert Composer
Objective: The intent of this document is to understand how notification works in Oracle Fusion Alert Composer. Scenario: Here we can see grade creation in fusion and see the notification…
Read MoreFusion HCM Candidate Query
Introduction: This SQL query is used to fetching the data for candidates who are attended various assessment tests at the time of recruiting. In this assessment name is used as…
Read MoreCreating payable invoice auto approval BPM rule in Oracle Fusion
Creating payable invoice auto approval BPM rule in Oracle Fusion: In this document, we discuss in detail the invoice approvals workflow functionality in Oracle Fusion Payables If the invoice is…
Read More