My Oracle Support Banner

Financial Reporting (FR) Export In Query-Ready Mode Displays Sub Variable In "[yyyy].[yyyy]" Instead Of "yyyy" Format in Excel. (Doc ID 2752296.1)

Last updated on FEBRUARY 16, 2021

Applies to:

Oracle Financial Consolidation and Close Cloud Service - Version 18.01.42 to 21.02.85 [Release 18.0 to 21.0]
Oracle Planning and Budgeting Cloud Service - Version 18.01.42 to 21.02.85 [Release 18.0 to 21.0]
Hyperion BI+ - Version 11.1.2.4.903 to 11.2.4.0.000 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms


After performing "Export in Query-ready mode" on an FR report, Smart View displays substitutional variable "Year" in format of "[yyyy].[yyyy]" instead of "yyyy" in an Excel worksheet.   For example, it displays "[2020].[2020]" in Excel instead of "2020".  

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.