Employee 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 MoreOracle Fusion AP Recurring Invoice Process
Recurring Invoices You can enter invoices for periodic business expenses for which you may not receive invoices, such as rent. To enter recurring invoices, first define a recurring invoice template,…
Read MoreThe payroll relationship or assignment isn’t eligible for the element Statutory Deductions on the date YYYY-MM-DD
Introduction: While create Manage Users to hire a new employee the following error occurs “the payroll relationship or assignment isn’t eligible for the element Statutory Deductions on the date YYYY-MM-DD”…
Read More