Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
BPM Transaction Report (R13) Struggle
Summary
Making use of the SOAINFRA tables to replace HRC_TXN_HEADER_archive and HRC_TXN_data_archiveContent
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.
Tagged:
0