Fusion OTBI Report - Journal - Drill Down Not Working

(Doc ID 2264807.1)

Last updated on OCTOBER 19, 2017

Applies to:

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

Symptoms

Created a report to display journal details and made journal name has a drill down column. and we are also able to drill down to see the journal details for some of the journals at the same time we could not drill down the other set of journals, getting an error message.

The drill down functionality is not working in order to to see the journal details for some of the journals at the same time the drill down for other set of journals is generating an error message.

Note: Journal mentioned in the below error exists in the system and it also meets the report filters.

ERROR
-----------------------
No Result
The specified criteria didn't result in any data. This is often caused by applying filters and/or selection steps that are too restrictive or that contain incorrect values. Please check your analysis filters and selection steps, and try again. The filters or selection steps currently being applied are shown below
Journal User Source Name is equal to AutoCopy, Manual, Spreadsheet
and Posting Status Code is equal to P
and Ledger Name is equal to CA_CAD_PRM
and Accounting Period Name is equal to JUN-16
and Journal User Source Name is equal to / is in AutoCopy
and Journal User Category Name is equal to / is in Manual
and General Ledger Journal is equal to / is in AA_CP CONCESSION AMORTIZATIONManual
and Journal Batch is equal to / is in Spreadsheet A 300000002306145 70888 N 01-JUL-2016 10:51:54
and Journal Created By is equal to / is in Arsalan Arif

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