Employee

Script 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 More

Script 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 More

Employee 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 More

Script 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