So you're working with Discoverer 10g integrated with the Oracle eBusiness Suite on Release 12. You've installed and set everything up per Metalink/MOS Note 373634.1 "Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12" plus created a custom application and responsibility to have it's own menu items corresponding to your Discoverer Workbooks/Worksheets.
You login to your new responsibility and click on your new menu entry that you created per Metalink/MOS Note "How to Create a Link to a Discoverer Workbook in Apps R12" and what do you get when you query subledger data such as Payables Invoices, or secured General Ledger data?
This sheet currently contains no data.
Well, its a quick fix. Simply save the following value in the "Initialization SQL Statement - Custom" profile option at Responsibility level for your new Responsibility.
begin gl_security_pkg.init; mo_global.init('M'); end;
Note: this may depend on your setup of the following profile options:
- GL Ledger Name
- GL: Data Access Set
- MO: Operating Unit
- MO: Security Profile
All sorted!
References
- Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12
- How to Create a Link to a Discoverer Workbook in Apps R12
Related Posts
- Discoverer Plus 10g: contact with Server lost: DiscoApplet Error DiscoNetworkException CORBA.COMM_FAILURE. ICX Territory!
- Discoverer Plus window not appearing or Jinitiator JVM conflicts on the Oracle eBusiness Suite: Java JRE EnableSecureStaticVersioning
- Setting your Oracle Applications session: fnd_global.apps_initialize (org_id)
