Oracle Transactional Business Intelligence

Products Banner

Report for vacant positions and open job requisitions

Received Response



I was wondering if anyone has a report that shows active vacant positions with active open job requisitions?

We are looking to pull:

  • Active position currently vacant, with no requisition attached. Include latest incumbents’ name, person number and assignment end date. Also include any future dated incumbents’ person name, person number and assignment start date.
  • Active position not currently vacant, with requisition attached (Draft – In Progress, Approval – Pending, Approval, Job Formatting – In Progress, Posting – In Progress, Open – Not Posted, Open – Scheduled, Open – Posted)

Many thanks.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):


  • Would love to see this as well! Currently pulling active positions and joining recruiting subject area, but as soon as we add req number, it removes positions that don't have a req!