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
Need Report for Number of times hire-date changed and all hired dates changed(in one field) — 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

Need Report for Number of times hire-date changed and all hired dates changed(in one field)

Received Response
15
Views
7
Comments
edited May 14, 2021 10:44AM in Reporting and Analytics for HCM 7 comments

Content

Hello ,

We need the report of, Number of times hire-date changed and all hired dates changed(in one field). Is it possible in BIP?

If yes, pls share me the sample SQL our reference.

Here is the below columns:

Standard ID

First Name

Last Name

Projected Hire Date/Actual Hire Date

Number of times hire-date changed

All hired dates changed(in one field)

A002321

John

Doe

3/31/2021

4

3/7/2021; 3/10/2021; 3/17/2021; 3/31/2021

 

Thanks,

Janardhana

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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