You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)

edited Jun 3, 2025 7:57AM in Workforce Management 1 comment

An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data model behind this report isTimeApprovalNotificationBulkDM

The dataset I am interested in is SQL :

timecard_totals

The SQL is shown below:

SELECT
tm_rec_grp_id,
label_total,
reported_total, --*****
calculated_total, --*****
is_valid_record,
error_message
FROM
TABLE ( hwm_timecard_report.timecard_totals(
:bindtmrecgrpid1,
:bindtmrecgrpid2,
:bindtmrecgrpid3,
:bindtmrecgrpid4,
:bindtmrecgrpid5,
:bindaprvtmrecgrpid,
:bindTmCardMode,
:bindTmCardFlow,
:bindLoggedInUser ) )
)


The columns populated as show with ***** please can someone confirm what value type is returned from

this procedure (function) and its format. ie. → hwm_timecard_report.timecard_totals.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!