Fusion general ledger financials OTBI : Error executing custom OTBI analysis In Upgraded CLONED R10 Instances - nQSError: 77031 ADFException-3001: ViewObject "FscmTopModelAM.AccountBIAM.FLEX_TREE_VS_GL_BALANCING_VI" not found. (Doc ID 2102100.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

Fusion ERP GL R10 Cloud OTBI - post upgrade and CLONE - analysis error
POD - upgraded and cloned stage POD

Steps
-------------
custom OTBI analysis against SA "General ledger - Transactional Balances Real Time"
was running fine in R9 instance in both our DEV1 and TEST non production instances.

After our non-prod instances are upgraded to R10, this report is throwing error in execution in both the instances.

This report is running fine in Production which is in R9.

Below is the error message we are receiving while running the report

Error
-----------

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: ADFException-3001: ViewObject "FscmTopModelAM.AccountBIAM.FLEX_TREE_VS_GL_BALANCING_VI" not found. (HY000)

What works
------------------------

Same custom analysis works fine in R9 in test and prod

Changes

 Upgrade and CLONE on stage

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