Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 230 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
how to get marital status change date field in OTBI analysis
how to get marital status change date field in OTBI analysis
Answers
-
Hi @Anup Karmankar,
Welcome to the Oracle Analytics Community.
Can you please check the 'Person Legislative Information' folder under 'Workforce Management - Person Real Time' Subject Area? Here's a screenshot highlighted in Yellow.
Hope this help.
Thank you.
0 -
I am creating a daily scheduled agent report in OTBI to bring in Marital status updates from the previous day, but am having trouble with the formula to use in the last updated column to bring in just Marital status changes. I was able to create one for last updated address changes, but having trouble with marital status changes. Anyone have any suggestions?
0 -
Please share which subject area you are using, if it is coming from Person Real time, then can you try:
"Person"."Marital Status Change Date" = TIMESTAMPADD(SQL_TSI_DAY, -1, CURRENT_DATE)
0
