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.
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:
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:
The above fields can be found under Candidate Facts > Candidate Cycle Time folder in the Recruiting Subject Area.
The above fields can be found under Requisition Facts > Requisition Aging folder in the Recruiting Subject Area.
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.
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