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 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 MoreScript 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.default_currency_code “Currency”, (SELECT meaning FROM apps.fnd_lookup_values WHERE lookup_type = ‘EXPENSE REPORT STATUS’ AND LANGUAGE = ‘US’ AND lookup_code =…
Read MoreFunction 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 VARCHAR2,P_CLAIM_APPROVED_DATE IN VARCHAR2) RETURN VARCHAR2 IS LS_AUDIT_TAKEN VARCHAR2(100):=0; BEGIN SELECT SUM((TO_DATE(B.CASE_TIME,’DD-MON-YYYY HH24:MI:SS’)-TO_DATE(B.End_Dated_time,’DD-MON-YYYY…
Read MoreiExpense 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.Operating_Unit, A.Amount, A.Currency, A.Last_Audited_By, A.Report_submit_date, TO_CHAR(A.Claim_Approved_Date,’DD-MON-YYYY HH24:MI:SS’) Claim_Approved_Date, TO_CHAR(A.Pending_Your_Resolution_Date,’DD-MON-YYYY…
Read MoreScript 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.default_currency_code “Currency”, (SELECT meaning FROM…
Read MoreExport 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.invoice_num, aeh.total total_amount, aeh.amt_due_employee personal_amount, aeh.expense_status_code, aeh.report_header_id, aeh.employee_id, aeh.org_id, aeh.ROWID, round((trunc(sysdate)-trunc(aia.creation_date)))days,aia.creation_date FROM ap_expense_report_headers_all aeh, per_all_people_f pap,ap_invoices_all aia WHERE aeh.employee_id =…
Read More