Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Provide access to Vacation Rule tables in OTBI or directly using SQL

Organization Name
Williams
Description
We are a regulated industry and require signifigant reporting to ensure that we are in compliance with auditors and regulators. One of the areas we are seeing a gap is to audit who has create vacation rules with delegations and reassignments. We need access to this information. Per Oracle Support on SR 3-26580549131 this is not available functionality currently as of 21B release
Use Case and Business Need
This is a regulatory requirement. Failure to meet these requirements can result in fines or failed audits so it is business critical that this information be made available. This will be an issue for other companies in similar industries
Original Idea Number: 96d69a5836
Comments
-
Hi Christopher,
I have a SR open for the same requirement for the past 1.5 year and have recently found in the release notes for 21c that a report will become available that might suits our purpose, below the release notes:
We are receiving the 21c upgrade in dev over the next week so will be able to test it soon.
Best regards,
Rick
1 -
Rick, Thank-you for the quick response. This may well meet our need. I appreciate your post and pointing me to this new feature.
Regards
Chris
0 -
Christopher,
Here are a few more ideas you may want to review and vote for.
Reporting on the use of approval delegation and reassignment of our end users for Audit and back end monitoring control.
https://cloudcustomerconnect.oracle.com/posts/449fa520a4
Full audit trail of adds / changes to vacation rules
https://cloudcustomerconnect.oracle.com/posts/bd9c6b3553
Need ability to query Vacation Rules via OTBI
https://cloudcustomerconnect.oracle.com/posts/8aebc24af2
Centralized management of Vacation Rules (workflow approval delegation)
https://cloudcustomerconnect.oracle.com/posts/e0f61ead3b
Need new Privilege to remove Users ability to define their own Vacation Rules
https://cloudcustomerconnect.oracle.com/posts/4d0f80968d
Make "Allow User to Approve their own transaction" in Edit User Account Details page configurable
https://cloudcustomerconnect.oracle.com/posts/09cb98a979
[Planned Idea] Possibility to run a report against existing vacation rules
https://cloudcustomerconnect.oracle.com/posts/7d12dc1977
Vacation Rule limit or additional configurable pop-up message to user
https://cloudcustomerconnect.oracle.com/posts/58e4014e2f
Disable the reassign button for vacation rules
1 -
Jeff, This is great, I think many of these will eventually come up as requests. I will review and vote for these and have coworkers do the same.
Regards,
Chris
0 -
Hi Rick, have you tested this new report yet? It's not working for us so am curious as to what others are seeing.
Thanks,
Jen
0