Query to get Payment Reversal
Introduction Business requested to provide the Payment reversal information Cause of the issue: Business want to cross check with Payment reversals How do we solve: We have created…
Read MoreQuery to get AR Adjustments
Introduction Business requested to provide the date for AR Adjustments for a particular period Cause of the issue: Business want to tally the data with uploaded Adjustments. How…
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 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 MoreUser Status Query – Oracle Fusion
The below query extracts the list of employee users along with their user status and employee status SELECT pu.username USER_NAME ,papf.person_number EMPLOYEE_NUMBER ,ppn.first_name EMPLOYEE_FIRST_NAME ,ppn.last_name EMPLOYEE_LAST_NAME ,DECODE(SUSPENDED,'Y', 'Inactive User','N', 'Active…
Read MoreQuery to get tax registration at supplier level – Oracle Fusion
The below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications. SELECT HP.party_name supplier_name ,SUP.segment1 supplier_number ,ZR.TAX_REGIME_CODE ,ZR.REGISTRATION_NUMBER tax_registration_number ,ZR.EFFECTIVE_FROM…
Read MoreBursting query for BIP report(HCM) in Fusion
Introduction : The below queries will help us to upload the output file in UCM server and send mail to respective mail id in fusion. Upload file to UCM: select…
Read MoreQuery to get HCM Extract Input Values in BI Report
Introduction This Post Provides the SQL Query that returns HCM Extract Input Values in BI Report Query SELECT TO_DATE (par_val.flow_param_value, ‘YYYY-MM-DD’) FROM pay_flow_instances flow, pay_flow_parameters flw_par, pay_flow_param_values par_val WHERE…
Read More