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 18.104.22.168.1 and later
Information in this document applies to any platform.
On : 22.214.171.124.1 version, DataWarehouse
Setting Future Dates for HR Analytics does not work as per Business Intelligence Applications Configuration Guide (126.96.36.199.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 188.8.131.52.1 is as follows:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!