Create Payables Invoice Aging Period
Introduction. Use the AP Invoice Aging report to analyze the cash flow of unpaid invoices and your uncleared payments. The report organizes uncleared items into time periods that you define,…
Read MoreEmployee Revoke (Core Hr-HCM)
Introduction: This SQL query is used to fetching the data for Employees who are Revoked means cancelled the termination those employees will fetch based on last update date. SQL…
Read MoreWheebox 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 More