Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
report to show timecards that aren't approved (when the last editor was not the worker him/herself)
Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time administrators team. Want to share in case this can be helpful to others. You may have to modify the SQL accordingly to fit the requirements of your organization.
Content (required):
with SUBMISSIONS_WITH as (
select
HWM_EXT_TIMECARD_HDR_V.ORIG_TM_REC_GRP_ID TM_REC_GRP_ID,
to_char(HWM_TM_SUBMITTED_TS_V.SUBMITTED_TIMESTAMP, 'mm/dd/yyyy HH12:MI PM') SUBMITTED_TIMESTAMP,
HWM_EXT_TIMECARD_HDR_V.LAST_UPDATED_BY UPDATER_USERNAME,
0