OBIA 11g: Setting Future Dates For HR Analytics Does Not Work as Per Documentation
Last updated on APRIL 24, 2018
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
On : 220.127.116.11.1 version, DataWarehouse
Setting Future Dates for HR Analytics does not work as per Business Intelligence Applications Configuration Guide (18.104.22.168.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
- 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"
- Documentation states that the default code in this initialization block is as follows:
from "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_DAY_D_Common"
where DAY_DT = CURRENT_DATE
This is incorrect. The default code in 22.214.171.124.1 is as follows:
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 hundreds of Community platforms