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…
Read MoreUser_Info_Details_Report
Introduction This report displays employee master information such as employee ID, name, person type, position, job grade, manager, contact details, employment status, location, and long-term leave details for HR administration…
Read MoreScript to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time
Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migration process/Go-Live the downtime of the server will be…
Read MoreScript to delete the employee record using API in oracle
–Create Table create table papf_16082018 (person_id number, employee_number varchar2(10)); –Insert Data insert into papf_16082018 values (53687,’215677′); commit; update apps.fnd_user set employee_id=null where employee_id in (select distinct p.person_id from apps.per_all_people_f…
Read MoreEmployee data extract based on business group
SELECT hou.name business_unit, papf1.first_name, papf1.middle_names, papf1.last_name, papf1.full_name emp_full_name, pj.name employeee_job_desc, pj.attribute16 wd_job, papf1.employee_number employee_number, papf1.email_address employee_email_hr, fu.email_address employee_email_fnd, fu.user_name …
Read MoreScript to get dependents for Employee
CREATE OR REPLACE FUNCTION APPS.HR_GET_DEPENDENT(p_element_entry_id IN NUMBER, p_contact_number IN NUMBER, p_data_field IN VARCHAR2) RETURN VARCHAR2 IS l_contact_name VARCHAR2(300); CURSOR C1 IS SELECT DEP.Full_Name Contact_Full_Name, DEP.National_Identifier,…
Read More