-
-
Reports (BIP) – Query to get Adjustments in Absences
select papf.person_number,ppnf.full_name,absence_plan.name ,apaed1.value,apaed1.type,to_char(apaed1.procd_date,’DD-MON-YYYY’) processed_date,apaed1.created_byfrom anc_per_acrl_entry_dtls apaed1,ANC_PER_PLAN_ENROLLMENT apaed,per_all_people_f papf,per_person_names_f ppnf,(SELECT aapf.absence_plan_id, aapft.NAMEFROM anc_absence_plans_f_tl aapft,anc_absence_plans_f aapfWHERE aapft.absence_plan_id = aapf.absence_plan_idAND aapf.plan_status = ‘A’ — added to pick only Active Absence PlansAND trunc(SYSDATE) BETWEEN aapf.effective_start_date AND aapf.effective_end_dateAND trunc(SYSDATE) BETWEEN aapft.effective_start_date AND aapft.effective_end_dateAND aapft.language = ‘US’) absence_planwhere apaed.plan_id = absence_plan.absence_plan_idand apaed.plan_id = apaed1.pl_idAND ppnf.name_type = ‘GLOBAL’AND ppnf.person_id = apaed.person_idAND ppnf.person_id…
-
REST API – Sample Payloads (Part – 1)
Sample payload for adding DFF attribute value for absence entries: Sample Rest API Payload for adding dff value url will be same : https://abc_test.oraclecloud.com/hcmRestApi/resources/11.13.18.02/absences/ { “personNumber”: “999”, “employer”: “ABC Test Employer“, “absenceType”: “Sick Leave”, “startDateDuration”: “1”, “startDate”: “2019-03-28”, “startTime”: “08:00”, “endDate”: “2019-03-28”, “endTime”: “17:00”, “absenceStatusCd”: “SUBMITTED”,…
-
Reports (BIP) – Query to get UCM Content ID of an absence attachment
Use below query to get absence attachment id of an absence from UCM: