Oracle Fusion HCM

Creating Workers Oracle Fusion HCM API

Creating Workers in Oracle Fusion HCM via REST API Creating and Managing Workers in Oracle Fusion HCM Using REST APIs Instead of the Guided UI Flow Introduction / Issue Onboarding…

How to Add or Remove a User Role Using Oracle Fusion SCIM REST API with Postman

How to Add or Remove a User Role Using Oracle Fusion SCIM REST API with Postman Introduction / Issue In Oracle Fusion Applications, every user’s access is controlled by the…

Inactive Manager Assignment Query – Oracle Fusion

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…

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’) FROM pay_flow_instances flow, pay_flow_parameters flw_par, pay_flow_param_values par_val WHERE…

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 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,…

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_NUMBER’) CHANGES_ONLY_PARAM = GET_PARAMETER_VALUE(‘CHANGES_ONLY’) EFFECTIVE_DATE_PARAM = GET_PARAMETER_VALUE(‘EFFECTIVE_DATE’) L_VALUE =…

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, 10), ‘MM-DD-YYYY’) eff_date…

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.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,…