About: Requisitions with Missing Approved Dates (Doc ID 2345851.1)

Last updated on MARCH 26, 2018

Applies to:

Symptoms

A query based on the Recruiting Subject Area in Oracle Business Intelligence is displaying null values in the following fields for specific requisitions that have been approved and are filled, sourcing, or cancelled:

• "Requisition Dates"."First Fully Approved Date"
• "Requisition Status - Historical"."Req. Historical Status End Date" for "Historical Status" = Approved

Other symptoms are:

1. A query to display open requisitions in a point in time is returning requisitions that were filled or sourcing at that time (see Knowledge Document ID 2146387.1: How To: Report on Open Requisitions at a Specific Point in Time)
2. A query containing fields from "Requisition Status History" is displaying a null end date for the "Approved" status/event for requisitions that have been approved
3. Even though the "First Fully Approved Date" is null, a value appears for the "Latest Fully Approved Date"
4. One of the following fields are displaying a null value for specific requisitions that have been approved: 

• "Candidate Cycle Time"."(Average) Time From Req. First Approval To Offer Accept"
• "Candidate Cycle Time"."(Average) Time to Hire"
• "Candidate Cycle Time"."(Average) Time to Start"

• "Requisition Aging"."(Average) Time Since First Approval"
• "Requisition Aging"."Average Time Since First Approval (Minus TOH)"
• "Requisition Aging"."Time Closed Since First Approval"
• "Requisition Aging"."Time On Hold Since First Approval"

• "Requisition Cycle Time"."(Average) Time To Fill"
• "Requisition Cycle Time"."(Average) Time To Last Position Accepted"

Changes

Cause