Blog / Category
Expense reports
7 articles in this category
Travel 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 t…
Employee 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 repor…
Script to extract Expenses SLA Details
SELECT aerh.invoice_num “Report_Number”, papf.full_name “Employee_Name”, papf.employee_number “Emp_Number”, hou.NAME “Operating_Unit”, aerh.total “Amount”, aerh…
Function to find the audit time take for the expenses
Introduction: This will displays the Audit time taken for expenses CREATE OR REPLACE FUNCTION TIME_TAKEN(P_REPORT_HEADER_ID IN NUMBER,P_AUDIT_COMPLETE_DATE IN V…
iExpense audit SLA report
Introduction This report is about to find the expense details and time taken to complete the audit. SELECT A.Report_Number, A.Employee_Name, A.Emp_Number, A.Ope…
Script to extract Expenses SLA Details
SELECT aerh.invoice_num “Report_Number”, papf.full_name “Employee_Name”, papf.employee_number “Emp_Number”, hou.NAME “Operating_Unit”…
Export employee data with personal expenses in i-expense and the expense is not claimed
SELECT pap.full_name, pap.email_address, pap.employee_number, aeh.inv…