My Oracle Support Banner

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

Last updated on MARCH 26, 2018

Applies to:

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


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:

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: 


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 analysis.




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

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