My Oracle Support Banner

Trying to Drill Trough From Smart View Shows Error "You can only drill from Smart View into detail balances, but not to Account Inspector. All chart of accounts segment values must be detail values. (GL-781721)" (Doc ID 2383076.1)

Last updated on NOVEMBER 21, 2019

Applies to:

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

Symptoms

On :  11.12.1.0.0 version, Financial Reporting and Analysis

When attempting to drill down from any Smart View report, the following error occurs.

ERROR
-----------------------
"You can only drill from Smart View into detail balances, but not to Account Inspector. All chart of accounts segment values must be detail values. (GL-781721)"

Having AFLOG enabled shows in the server logs the error:



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a Smart View Report
2. Click on a balance column (f.e Actual) and click on Drill-through icon in the ESSBASE Menu tab.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see detail transactions that generated a balance.

Other Facts:
1. The error is happening on ALL smart view reports

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
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.