My Oracle Support Banner

OBIA 11g: Setting Future Dates For HR Analytics Does Not Work as Per Documentation (Doc ID 2153134.1)

Last updated on APRIL 24, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.8.1 version, DataWarehouse

Setting Future Dates for HR Analytics does not work as per Business Intelligence Applications Configuration Guide (11.1.1.8.1) section -" B.2.34 How to control HR Future-Data Transaction Data Visibility" -

Instructions are located at http://docs.oracle.com/cd/E51479_01/doc.111181/e51480/app_func_tasks.htm#BIACF24520

Issue :

  1. The documentation suggest to check initialization block "HR_WRKFC_MAX_EFFECTIVE_DT" - which is incorrect, the initialization block is called "HR - Future-dated Data Date" - the associated Session Variable is called "HR_WRKFC_MAX_EFFECTIVE_DT"
  2. Documentation states that the default code in this initialization block is as follows:

select DAY_DT
from "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_DAY_D_Common"
where DAY_DT = CURRENT_DATE

This is incorrect. The default code in 11.1.1.8.1 is as follows:
select DAY_DT
from VALUEOF(OLAPTBO).W_DAY_D
where W_CURRENT_CAL_DAY_CODE='Current'
 

Changes

 

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!


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