Timecard Approved Data in BI Publisher Report

Question

Team,

We are trying to get Timecard Approval Date, Approver Name Details. But we are unable to find the table name.

The below MOS says that it's not feasible to get it from BIP. Is

Fusion Time and Labor: Need Report on current Approver details on Fusion Time And Labor Approvals (Doc ID 2066055.1)

Please share if there is a way to fetch these details in BIP reports. Any help would be appreciated.

Thanks.

Manoharan · Answer

@Nathan CCC

We have tried with the below SQL but no rows returned.

Nathan CCC · Answer

Hi,

Here is the SQL for timecard approval date

"Reported Time Cards"."Time Card Approved Time"

This is the current timecards.

https://docs.oracle.com/en/cloud/saas/human-resources/24c/faohb/Workforce-Management--Reported-Time-Cards-Real-Tim-SA-56.html#Workforce_Management__Reported_Time_Cards_Real_Tim_SA_56_d1e19413

You can also query historic

https://docs.oracle.com/en/cloud/saas/human-resources/24c/faohb/Workforce-Management--Historical-Reported-Time-Car-SA-58.html#Workforce_Management__Historical_Reported_Time_Car_SA_58_d1e18154

You can add this logical query in your bipublisher report in OTBI with a data model with data set of type analysis or a data set of type sql with data source oracle bi ee. It is good practice to use the subject areas if you can. If as a last resort you for some reason must resort to using application tables and views then view log in manage sessions to get the physical sqls(s) generated by the metadata repository database (rpd) to answer this logical query.

select all 0 s_0

, "Worker"."Assignment Number" as worker_assignment

, cast("Reported Time Card Details"."Time Card Id" as character) as timecard_id

, "Reported Time Card Details"."Day Start Time" as day_start

, "Reported Time Card Details"."Day Stop Time" as day_end

, "Reported Time Card Details"."Day Id" as day_id

, cast("Reported Time Entry Details"."Time Entry Id" as character) as timeentry_id

, "Time Card Status"."Time Card Status Name" as timecard_status

, "Time Card User Status"."Time Card User Status Name" as timecard_user_status

, "Reported Time Cards"."Time Card Approved Time" as timecard_approved_date

, "Reported Time Cards"."# of Reported Time Entries" as n

from "Workforce Management - Reported Time Cards Real Time"

where 1 = 1

and ("Worker"."Assignment Number" = '')

order by 1 desc nulls last, 2 asc nulls last, 3 asc nulls last, 4 asc nulls last, 5 asc nulls last, 6 asc nulls last

fetch first 7 rows only

A timecard has none to many approvers. Each day may have different approver(s). Each timecard entry in that day may have different approver(s). For example, it may go to the project manager of the project or task selected on the entry and/or to the line manager of the worker assignment for which timecard is submit etc. The number of approvers is a function of how your application implementation consultant has setup the workflow in business process "Approve Time".  You can see the "assignees" of the "recent" timecard workflow task in Tools work area Transaction Console. Your administrator from time to time may have "archived" the workflow task from here.

To get the worklist transactions use

"Human Capital Management - Transaction Administration Real Time"

To view the archived worklist transactions

"Human Capital Management - Approval Notification Archive Real Time"

To view the current workflows you can query the workflow tables and views

see How to Create BI Publisher Report on Workflow Notifications ? (Doc ID 2135790.1)

fa_fusion_soainfra.wftask etc