Reporting Issue: Job Requisition's Inbound Staffing Process - Completed unavailable at Action Event Level
Hi all!
For a client requirement I am currently merging two reports about Job Requisitions. One of these reports, targetting existing Job Requisitions, is built on the All Job Requisitions Data Source (Job Requisition BO), and the other on the All Business Process Transactions Awaiting Persons, filtered by Transaction Status not Successfully Completed).
Since these two reports return mostly similar fields, the requirement is to use only the second report on the Action Event BO and widen the filter to also include Successfully Completed transactions.
Some of the fields from the first report are only accessible at the Job Requisition BO level. This field has been retreived at the Action Event BO level by building an ESI cacl field on the Action Event's Transaction Targets field, and using an EE calc field to enforce the Job Requisition type and be able to drill in to the Job Requisition's fields, as per this community article (and because after hours or research I couldn't find any other option to do this) : https://collaborate.workday.com/t5/General/Bridging-the-Object-Model-with-Super-Business-Objects-How...
It all works like a charm, except for the Job Requisition field Inbound Staffing Process - Completed. The first report has some calculated fields built on this multi-instance field that I need to add to the new merged report - here is one of them as an example (they are all similar LRV fields):
However all these fields, as well as the Inbound Staffing Process - Completed field, remain empty whenever I use them in my merged report from the CF EE Job Requisition (BOC) field.
I tried accessing the Staffing Business Process from the Action Event BO but it returned only Blank values.
I am unsure why this field is not accessible from the retreived Job Requisiton BO (CF EE Job Requisition (BOC) field). These are unfortunately the only fields that I am unable to merge and any workaround this issue would be higly appreciated!