Time Cards Approver Name and Approval Timestamp

ks1075

We are tying to perform reporting on the Approver Name and Timestamp for Submitted Time Cards but unable to achieve the same either through OTBI or BIP. Appreciate any help on this piece. Thanks in advance.

Nathan CCC

Hi,

A timecard uses the business process management workflows to do approvals. As with any workflow a task have multiple approvers. And as you know with any workflow an assignee may may delegate or assign to another person. In addition to this because you can edit an approved timecard then submit for approval again a timecard may have multiple approvals over time. So "approver" is not an "attribute" of a timecard. It is a child entity with multiple values regards who approved or rejected or was assigned a timecard when on which version of a timecard.

You have an out of the box subject area "Human Capital Management - Transaction Administration Real Time" and "Human Capital Management - Approval Notification Archive Real Time". This gives you the data you see on the Tools work area Worklist and Transaction Console. But this only gives the approval status not the assignee persons who approved or rejected. Object ID and Subject ID can be used to join out back to the transactions and persons depending on each process category type. For example, timecards, absence etc

select all 0 s_0

, "Transaction Details"."Transaction ID"

, "Time"."Date"

, "Transaction Details"."Process Category"

, "Transaction Details"."Process Name"

, "Transaction Details"."Submitted by User Name"

, "Transaction Details"."Transaction Status"

, "Transaction Details"."Approval State"

, "Transaction Details"."Approval Status"

, cast("Transaction Details"."Object ID" as character) as object_id

, cast("Transaction Details"."Subject ID" as character) as subject_id

from "Human Capital Management - Transaction Administration Real Time"

where 1 = 1

and "Transaction Details"."Process Category" = 'Project Time Card Approval'

order by "Time"."Date" desc nulls last

fetch first 7 rows only

If you need more data that is not in these subject areas then you will need to query the "secret" workflow tables to get additional information about the various steps in an approval workflow. These tables are not documented in your tables and views user guide. For example, for "active" approvals fa_fusion_soainfra.wftask You may need a union to other tables to get historic data. For more information see How to Create BI Publisher Report on Workflow Notifications ? (Doc ID 2135790.1)