Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.
Summary:
My Query:
select per.person_number,
per_name.FULL_NAME
PER_ABSENCE_ENTRY_ID ,
abs.absence_type_id,
apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.start_date,'DD-MON-YYYY') start_date,to_char(apae.end_date,'DD-MON-YYYY') end_date,duration,
haouf.name department,
haotl.name LE,
pplf.LEGISLATION_CODE
--PLDG.name LDG
from
ANC_PER_ABS_ENTRIES apae,PER_PERIODS_OF_SERVICE pps,PER_ALL_PEOPLE_F per,
PER_ALL_ASSIGNMENTS_M paam,
ANC_ABSENCE_TYPES_VL abs,
HR_ALL_ORGANIZATION_UNITS_F_VL HAOUF,
HR_ORGANIZATION_UNITS_F_TL haotl,
per_person_names_f per_name,
0