No Data Returned in Apps Schedulded Workbook Using E-Bus GL Business Area Folders (Doc ID 803815.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Discoverer - Version 10.1.2.1 to 11.1.1.7.0 [Release 10.1.2 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 26-Jun-2012***

E-Business Intelligence - Version: 12.0


Symptoms

Scheduled a Discoverer workbook connected as an Apps user/responsibility in E-Business Suite and see the following message in the results - "The query caused no data to be returned."

Running the same workbook directly without scheduling works fine and returns data as expected.

Oracle Discoverer 10g / 11g connected to Oracle Applications R12 with GL Security (gl_security_pkg.validate_access enabled ).

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