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
Fetching employee using BIP query if employee have Job changes and Termination — 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

Fetching employee using BIP query if employee have Job changes and Termination

Received Response
11
Views
2
Comments
edited Mar 31, 2022 12:06PM in Reporting and Analytics for HCM 2 comments

Summary:

Fetch the details of employee who have job changes and termination details of employee

Content (required):

Hi,

I am working on BIP query to fetch the details of employee only when employee have either job changed or termination based on below scenarios.

1)If employee has only job change then there should be only one row with old and New Job details and termination related fields should be blank

2)If employee has both job change and termination then the report should fetch two rows one for job change and one for termination.

3)If employee has only termination but no job change then it should fetch only one row with termination details column and job related column should be blank.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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