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 [...]

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, [...]

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’) [...]

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), [...]

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, [...]