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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

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!