Default value for Fiscal Year Dashboard Prompt is always 2008 in OBIA 11.1.1.7.1 (Doc ID 1907061.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

Source = EBS 12.1.3
Target = OBIA 11.1.1.7.1
OBIEE Admin Tool = 11.1.1.7.0

In OBIA reports, many prompts are Fiscal Year. The Default value for the Fiscal Year prompt is always 2008. It should be 2014.

The CURRENT_FSCL_YEAR variable is always 2008.  How can I change this?

Using <Note 958968.1> Fiscal Year Prompt Reverts to Default value 2008 - Initialization Block Shows it Depends on CURRENT_FSCL_YEAR variable which details the solution to the problem, however there are problems changing the initialization blocks so  that these return proper values instead of the defaults.

Currently the Variables values are:

CURRENT_FSCL_YEAR = 2008 (default)
MCAL_CAL_WID = 1006
LEDGER___EBS = -999
OU_ORG___EBS = -999
EBS_SSO_INTEGRATION_MODE = 'Not Integrated'
OLABTBO = 'PROD_DW'

Cause

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