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…
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 MoreEmployee’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 employee_name, papf_s.person_number manager_emp_number, ppnf_s.full_name manager_name FROM per_all_people_f papf, per_person_names_f ppnf, per_all_assignments_m paam,…
Read MoreGetting 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_NUMBER’) CHANGES_ONLY_PARAM = GET_PARAMETER_VALUE(‘CHANGES_ONLY’) EFFECTIVE_DATE_PARAM = GET_PARAMETER_VALUE(‘EFFECTIVE_DATE’) L_VALUE =…
Read MoreQuery 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, 10), ‘MM-DD-YYYY’) eff_date…
Read MoreEmployee 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.internal_location_code location_code, loc.location_name LOCATION, per_name.last_name, per_name.first_name, per_name.middle_names middle_name, pa.address_line_1, pa.address_line_2,…
Read MoreREVENUE 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) Purpose of this report is to derive all projects…
Read MoreSGA Details – JROD COPY
/****************************************************************************************************** This section provides details from AP for NON-Employee related invoices. *******************************************************************************************************/ SELECT (SELECT period_name FROM gl_periods WHERE apd.accounting_date BETWEEN start_date…
Read More