Skip to Main Content
Forums

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)

Scotty CFeb 26 2025 — edited Feb 27 2025

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.

Is there a specification available for this Procedure (Function)?

As what is being displayed on the report, it is rounded and has no decimal places.

Eg. If total time is 36.34 entered for the week for an employees timecard - the approval report will show 36 in the reported_total column, which is not very useful, and inaccurate.

Thanks
Scott

Comments

Post Details

Added on Feb 26 2025
#approval, #function, #fusion, #oraclefusion, #procedure, #redwood, #saas, #sql, #timecard
2 comments
293 views