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

Regd tracking name change in OTBI

edited Nov 3, 2020 11:34AM in Reporting and Analytics for HCM 2 comments

Summary

Regd tracking name change in OTBI

Content

Hi ,

We have name change report where we track any changes to person name in past 7 days and display the person's details on the report.

We use Workforce Management - Person Real Time subject area for this purpose and have a condition:

"

"Workforce Management - Person Real Time"."Person Names"."Last Update Date" BETWEEN 

TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE) AND CURRENT_DATE

"

So, any changes to person names folder will show up.

But now the request is to add the old values of the names to the OTBI report.

I dont think it is possible as even in front end I can see old values in Person name history.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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