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

Have a question with regard to Taleo OBI

Received Response


I'm working on a report to get the duplicate records based on the PAN Number.

So the report should give me all the duplicate records. I have used a custom SQL query but im getting error.

Can someone help me there?

Below is the query I used:

"Candidate Flex Fields"."UDF55" IN(SELECT "Candidate Flex Fields"."UDF55" FROM "Recruiting" WHERE "Candidate Identification"."Record Status"= 'AVAILABLE' GROUP BY "Candidate Flex Fields"."UDF55" HAVING COUNT("Candidate Identification"."Candidate Identifier")>1 )

Example data:

What is expected in the report is

To achieve this I used the above query.

Note: Candidate Flex Fields"."UDF55 is the field name for the PAN Number

Howdy, Stranger!

Log In

To view full details, sign in.


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