Blog / Category
Fusion Report
19 articles in this category
User_Info_Details_Report
Introduction This report displays employee master information such as employee ID, name, person type, position, job grade, manager, contact details, employment…
Query to get work order information without projects report in fusion.
SELECT WWOB.WORK_ORDER_NUMBER WO_NUMBER ,WWOT.WORK_ORDER_DESCRIPTION WO_DESCRIPTION ,WWST.WO_STATUS_NAME WO_STATUS ,HOU.NAME ORG_NAME ,CASE WHEN ROW_NUMBER() OV…
Query to get vendor master with missing GST Numbers report in fusion.
SELECT Qry_rslt.”Supplier Name” ,Qry_rslt.”Supplier Number” ,Qry_rslt.”Supplier Site Name” ,Qry_rslt.”Supplier Status” ,Qry_rslt.”Inactive Date” ,Qry_rslt.”Proc…
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 so…
Query 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…
Query 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: Bu…
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…
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…
User 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_N…
Query 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…
Bursting 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…
Query 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’) F…
Employee’s Supervisor Details Query
Introduction This Post Provides the SQL Query that returns Employee’s Supervisor Details Query SELECT papf.person_number employee_number, ppnf.full_name employe…
Getting HCM Extract Input Values in Fast Formula
Introduction This Post Provides the Detail to get HCM Extract Input Values in Fast Formula Sample Fast Formula PERSON_NUMBER_PARAM = GET_PARAMETER_VALUE(‘PERSON…
Query to get Last Run Parameter Value in BI Report
Introduction This Post Provides the SQL Query to get Last Run Parameter Value in BI Report Query SELECT TO_DATE (SUBSTR (rpj.VALUE, INSTR (rpj.VALUE, ‘”}’) – 10…
Employee Assignment Details Query
Introduction This Post Provides the SQL Query that returns the Assignment Details of the Employees Query SELECT peo.person_number employee_number, loc.in…
REVENUE TRANSFER REPORT (FUSION)
Introduction This Post illustrates the steps required to get the Revenue Transfer Report in Fusion Application. Script to REVENUE TRANSFER REPORT (FUSION) Purpo…
SGA Details – JROD COPY
/****************************************************************************************************** This section provides details from AP for NON-Empl…