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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 MoreIntroduction 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 More/****************************************************************************************************** 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