Fusion OTBI Report - Journal - Drill Down Not Working
Last updated on OCTOBER 19, 2017
Applies to:Oracle Fusion General Ledger Cloud Service - Version 220.127.116.11.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 18.104.22.168.0 and later
Oracle Fusion Application Toolkit - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms