Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Can You Create a Report of Time Card Statuses and Approvers in OTBI?

Question
3
Views
0
Comments

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):