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 and later
Information in this document applies to any platform.


On : version, DataWarehouse

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

Instructions are located at

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"

This is incorrect. The default code in is as follows:
select DAY_DT
where W_CURRENT_CAL_DAY_CODE='Current'




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.