I am receiving the above error when trying to run the below SQL within APEX (SQL Commands, Classic Report, Interactive Report & Interactive Grid) which I cannot see why as the same SQL works without any issues in SQLDeveloper.
SELECT ppt.USER_PERSON_TYPE AS "Person Type",
ppf.LAST_NAME AS "Last Name",
ppf.FIRST_NAME AS "First Name",
ppf.ORIGINAL_DATE_OF_HIRE AS "Date of Hire",
ROUND((SYSDATE - ppf.original_date_of_hire) / 365,2) AS "Years Service",
ppf.EMPLOYEE_NUMBER AS "Employee Number",
fnd.EMAIL_ADDRESS AS "Email",
pjs.NAME AS "Job Title",
hrl.LOCATION_CODE AS "Location",
xad.SAMACCOUNTNAME AS "SAMACCOUNTNAME",
fnd.USER_NAME AS "FND USERNAME",
xad.EMPDN AS "EMPDN",
fnd.CREATION_DATE AS "FND Creation Date",
ppf2.FIRST_NAME AS "Supervisor First Name",
ppf2.LAST_NAME AS "Supervisor Last Name",
ppf2.EMPLOYEE_NUMBER AS "Supervisor Employee Number"
FROM per_all_people_f ppf,
per_all_assignments_f paa,
per_all_people_f ppf2,
per_jobs pjs,
hr_h2pi_locations_v hrl,
per_person_type_usages_f pptu,
per_person_types ppt,
xxc_ad_integration xad,
fnd_user fnd
WHERE ppf.PERSON_ID = paa.PERSON_ID AND
pjs.JOB_ID = paa.JOB_ID AND
SYSDATE BETWEEN paa.EFFECTIVE_START_DATE AND paa.EFFECTIVE_END_DATE AND
SYSDATE BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE AND
hrl.LOCATION_ID = paa.LOCATION_ID AND
paa.ASSIGNMENT_NUMBER IS NOT NULL AND
ppf2.PERSON_ID = paa.SUPERVISOR_ID AND
SYSDATE BETWEEN ppf2.EFFECTIVE_START_DATE AND ppf2.EFFECTIVE_END_DATE
AND ppf.PERSON_ID = pptu.PERSON_ID AND
ppf.CURRENT_EMPLOYEE_FLAG = 'Y' AND
pptu.PERSON_TYPE_ID = ppt.PERSON_TYPE_ID AND
pptu.EFFECTIVE_END_DATE >= SYSDATE AND
ppt.SYSTEM_PERSON_TYPE = 'EMP' AND
ppf.PERSON_ID = xad.PERSONID AND
ppf.PERSON_ID = fnd.EMPLOYEE_ID
ORDER BY 1,6 asc