Fusion Financials FR Reporting - Unable To Migrate FR Reports From Stage To Production :Connection Warning message: The new database connection does not have the following dimensions (Doc ID 2061641.1)

Last updated on MAY 11, 2017

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.1.4.0.0 and later
Oracle Fusion Financials Common Module Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

Fusion Cloud Financials R9 - Unable to move/migrate a FR report from Stage to Prod , due to mismatch of key flex field LABELS (Name, Prompt and Short Prompt )


Steps

-------


The labels for Account KFF differ comparing Stage to Prod (Name, Prompt and Short Prompt ), they were changed after initial set up inProduction
Migrate reports to Production environment.
followed “Migrating Financial Reports: Instructions” chapter from https://docs.oracle.com/cd/E60665_01/financialscs_gs/OCCAR/F1563518AN15240.htm#F1376859AN159CD

Attempt to set up the database connection to Essbase for the migrated report

Error
-----------
When I try to connect report via Manage Connection in Workspace:

"Warning: The new database connection does not have the following dimensions
Group Account SL
Changing the datasource may cause reports to fail or produce unexpected results. Do you want to change the db connection ?"

 

Work-around attempted but it failed
------------------------------------------------
Tried to rename the 3 fields of prod environment: “Account SL” ”Group Account SL”, but once this modification was done, was unable to publish account hierarchy (kff was deployed and I also ran XML essbase job) :

process ends in error :

 see Essbase log.txt in attachment.   excerpt:

"buildGen2DtldNodeForUDAs(): START Building dimension  ... :: Group Account SL\par
####################### buildGen2DtldNodeForUDAs() : Incremental Buld for dimension Group Account SL  Start at Tue Sep 22 15:55:36 UTC 2015##########\par
buildGen2DtldNodeForUDAs(): Exception :: Cannot incremental build. Essbase Error(1007083): Dimension build failed. Error code [1090003]. Check the server log file and the dimension build error file for possible additional info.\par
publishTreeVersions():::  Error in building Gen2 node of this version.. \par
publishTreeVersions(): Executing cmd:alter database 'DMFranceSecondaryLedgerAc'.db  unlock all objects\par
publishTreeVersions(): Result:true\par
publishTreeVersions(): Executing cmd:alter application  'DMFranceSecondaryLedgerAc'  enable connects\par
publishTreeVersions(): Result:true\par
#################################### publishHierarchyVersions() :publishTreeVerCall End and took 120.656 Seconds############################\par
PublishHierarchyVersions: Error:: One or more versions did not get published successfully for Chart Of Account : DM France Secondary Ledger Accounting Flex Key Instance and Segment Group Account SL  Cannot incremental build. Essbase Error(1007083): Dimension build failed. Error code [1090003]. Check the server log file and the dimension build error file for possible additional info.\par
Releasing Root AM...\par"

Tried to change labels back to “Account SL” and then became able to publish hierarchies again.



Changes

ERP implementation team changed KFF Labels after the initial setup, so the Labels differsReport was created against a cube in Stage, where the Account Labels differs compared to Prod

 the only difference comes from 3 labels: Name, Prompt and Short Prompt which are set up to

“Group Account SL” in stage and
“Account SL” in prod.




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