Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 18 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Can You Create a Report of Time Card Statuses and Approvers in OTBI?
Summary:
Need a report for workers with multiple supervisors to see which supervisors still need to approve a worker's time card and which ones have already done so.
Content (please ensure you mask any confidential information):
Has there been any updates on the KM document, "Fusion Time and Labor: Need Report on current Approver details on Fusion Time And Labor Approvals (Doc ID 2066055.1)" that was last updated on August 17th, 2023?
We would like to be able to create a report that would help us determine which of a worker's supervisors still need to approve their time card, as well as a way to confirm with supervisors whether they have approved their workers' timecards. Ideally, this report would include a worker's name, the status of their time card for a given pay period, and the approval status of that time card from each of their supervisors.
From the Team Time Cards UI, we are not able to see which supervisors have approved a time card and which ones still need to do so. In the KM document mentioned above, it is explained that time card approver names and details are not available for reporting like this, but other customers have inquired and a long term solution is in progress.
Has a solution been developed, or is there a timeline for this information to be accessible using SQL?
Version (include the version you are using, if applicable):
Oracle Fusion Cloud Applications24B (11.13.24.04.0)
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
We need a similar report to trigger Notification based on TC status to the approver. Please confirm if any solution provided
Regards
Namrata
0 -
Hi @NamrataPhukan,
Welcome to the Oracle Analytics Community!
As this thread is more than 1 year old, would recommend you to raise a new post with your requirement details along with screenshots (without sensitive data) etc. so that it will get better visibility and someone from the community will be able to help.
Thank you.
0
