Reporting on Passport Services in OBI
Summary
Reporting on Passport Services in OBIContent
I am building a report in OBI to show the Passport Result Value for our Background Vendor. My issue is that I want to pull in the name of the requisition that the background was requested on. Whenever I try to use Submission Passport fields I never get any results. I am not sure why and Oracle support never explains they just tell me that I get results using Candidate Passport fields instead because they do give results.
My problem with the Candidate Passport fields is that the results carry across through all reqs the person has applied to. We also have other passport services so I end up getting a row for each req they have. I was able to create a report I needed in Business Objects but I had to use a few max formulas and overall max filter to achieve it. I can't quite figure out how to accomplish that in OBI.