Introduction: This blog has the SQL query that can be used to pull the data of employees whose manager assignment is inactive even if the manager is active. Cause of the issue: Business wants to [...]

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

HCM Data Loader (HDL) Keys Supported Key Types: HCM Data Loader (HDL) supports 4 different types of keys as listed below  GUID – Oracle Fusion Global Unique ID Oracle Fusion Surrogate ID [...]