My Oracle Support Banner

OTAC/TEE: Requisitions with Missing Approved Dates (Doc ID 2345851.1)

Last updated on JANUARY 21, 2020

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 19A and later
Information in this document applies to any platform.

Symptoms

Problem Description:

A query based on the Recruiting Subject Area in Oracle Business Intelligence (OBI) 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:

1.  A query to display open requisition in a point in time is returning requisitions that were filled or sourcing at that time.

Refer to How to Report on Requisitions in Open Status at a Specific Point in Time for more information on this topic.

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:

  • Average Time From Req. First Approval To Offer Accept
  • Average Time to Hire
  • Average Time to Start
  • Time From Req. First Approval To Offer Accept
  • Time to Hire
  • Time to Start

The above fields can be found under Candidate Facts > Candidate Cycle Time folder in the Recruiting Subject Area.

  • Average Time Since First Approval
  • Average Time Since First Approval (Minus TOH)
  • Time Since First Approval
  • Time Since First Approval (Minus TOH)
  • Time Closed Since First Approval
  • Time On Hold Since First Approval

The above fields can be found under Requisition Facts > Requisition Aging folder in the Recruiting Subject Area.

  • Average Time To Fill
  • Average Time To Last Position Accepted
  • Time To Fill
  • Time To Last Position Accepted

The above fields can be found under Requisition Facts > Requisition Cycle Time folder in the Recruiting Subject Area.

 

For zones that have the Recruiting (Legacy) Subject Area, another symptom will be that the same requisitions contain a value for Req. First Fully Approved Date in this Subject Area.  If a value is missing from both Subject Areas, submit a Service Request to the Oracle Taleo Reporting Support Team for further diagnosis.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.