Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Report for vacant positions and open job requisitions

Received Response
331
Views
1
Comments

Summary:

Hi,

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):

Answers

  • KatieH
    KatieH Rank 1 - Community Starter

    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!