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
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.

HCM Workflow Report

edited Jul 12, 2020 9:02AM in Reporting and Analytics for HCM 5 comments

Summary

All HCM transactions current status of the workflow and approval details

Content

Hi,

I'm trying to create a report to display all HCM transactions Current status of the workflow and the Approval details. 
when run the below query some of the transaction getting the mismatch status between TAC UI and from the report. 
UI level status is Approved by someone but HRC_TXN_DATA table level still it is showing as pending.

By using the below query,

some transactions HRC_TXN_HEADER.transaction id is not associated with the identificationkey of  wftask or fnd_bpm_task_b. So not able to get the exact status and the approval details.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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