Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to get Department of Level1 , level2 and level 3 position in position Hierarchy — Cloud Customer Connect
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

How to get Department of Level1 , level2 and level 3 position in position Hierarchy

Received Response
21
Views
10
Comments

Summary:

We have a requirement to fetch following fields in OTBI,

  1. Person Number
  2. Assignment Number
  3. Position Name
  4. Level1 Org: Populate department of the position One level below the CEO position hierarchy, If there is no level below CEO, populate the department name of the position holder
  5. Level2 Org: Populate department of the position Two level below the CEO position hierarchy, If there is no 2nd level below CEO, populate the department name of the position holder
  6. Level3 Org: Populate department of the position Three level below the CEO position hierarchy, If there is no 3rd level below CEO, populate the department name of the position holder

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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