Oracle Transactional Business Intelligence
HELP! Deletion, Merging and Incomplete Submissions
We configured the system to hide incomplete submissions in recruiting and also perform data auto-deletion tasks/merging. We however noticed that many records are showing in OBI that are not showing in Recruiting and # candidates became so high (not matching #candidates in recruiting). We were then advised to filter by Submission is Complete 'Yes', Missing Identification 'No' and Record Status 'Available'. Doing this again caused another issue, the total no of reqs reduced due to the filters.
Report users are now looking for a way to report all reqs and accurately get the total no of candidates that correctly match what is seen in Recruiting.
We were again advised to remove all filters and use # Submission Completed instead of # Candidates. This helped us to report on all reqs but the #Submission Completed still a little high as it is still picking up a few deleted candidate records and missing ids. I am open to try all suggestions or may be it is something that can't be achieved. So far I have advised users to use pure reqs reports to report on reqs and use submissions attached to reqs to report accurately report the nos of candidates/submissions. Unfortunately, they need a single report to do this.
I really don't know if it is possible to report on all reqs and still have it showing correct no of candidates/submissions due to the deletion tasks and incomplete submission configuration.