BPM Transaction Report (R13) Struggle — Cloud Customer Connect
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

BPM Transaction Report (R13) Struggle

edited Aug 14, 2018 7:14AM in Reporting and Analytics for HCM 5 comments

Summary

Making use of the SOAINFRA tables to replace HRC_TXN_HEADER_archive and HRC_TXN_data_archive

Content

Greetings Everyone,

Hope you are all well

Since we are upgrading to R13 in a couple of weeks, I've been blessed with rewriting some BIP extracts.

One of those being a report on HR related transactions from BPM and I ran into a bit of a corner.

The tables that have been made redundant - HRC_TXN_HEADER_archive and HRC_TXN_data_archive need to be replaced with FA_FUSION_SOAINFRA.WFTASKHISTORY and FA_FUSION_SOAINFRA.WFTASK.

Here's where the 'fun' starts. I'm missing key data like module_identifier, object_id, subject_id to effectively join person details.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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