BI Repository Variables Such as CURRENT_ENTERPRISE_YEAR, CURRENT_MONTH Giving Wrong Results

(Doc ID 2338149.1)

Last updated on APRIL 24, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

BI Dynamic Repository variables such as CURRENT_ENTERPRISE_YEAR, CURRENT_MONTH etc is giving wrong values.

E.g. CURRENT_MONTH might display 2017 / 11, but it is December and current_month variable should display 2017 / 12

E.g. CURRENT_ENTERPRISE_YEAR gives value as 2011 and it should display 2018
 

Solution

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