You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!