Get Started with Redwood for Oracle Cloud HCM Begin Now
Fetch Employees not a part of Talent Profile Section
Summary:
We have created a Custom Section using the Skill Template under the Talent Profile Page. As followed fields
HPI.ATTRIBUTE1 AS TRAINING_NAME,
HPI.ATTRIBUTE2 AS BRANCH,
HPI.ATTRIBUTE3 AS DESIGNATION,
HPI.ATTRIBUTE4 AS VENUE,
HPI.ATTRIBUTE5 AS TRAINING_TYPE,
HPI.ATTRIBUTE6 AS STATUS,
TO_CHAR(HPI.ATTRIBUTE_DATE1,'DD-MM-YYYY') AS START_DATE,
TO_CHAR(HPI.ATTRIBUTE_DATE2,'DD-MM-YYYY') AS END_DATE
We are trying to Fetch the employees who are not part of this section, We have Used NOT IN & IS NULL conditions.
Did not work I have attached the query we are using for this case. Kindly help me with this.
1