PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

CONNECT_BY_ISLEAF functionality available in PSQUERY?

We are currently on HCM 9.1/ PT 8.50

We are in the process of upgrading to HCM 9.2/PT 8.53

I have started using the CONNECT_BY_ISLEAF in sqlplus but would like to be able to do similar in PSQUERY.

Here is my SQL that I use in SQLPLUS:

SELECT last_name||Emplid "Employee", CONNECT_BY_ISLEAF "IsLeaf",

       LEVEL, SYS_CONNECT_BY_PATH(last_name||emplid, '/') "Path"

  FROM ps_employees

  WHERE LEVEL <= 4

  START WITH emplid = '012345'

  CONNECT BY PRIOR emplid = supervisor_id AND LEVEL <= 5

  ORDER BY "Employee", "IsLeaf"

/

An HR user is now asking for SQL Developer access because he is unable to do things like this in PSQUERY.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center