My Oracle Support Banner

No Data returned in GL Anaylsis workbook when signed in using a user defined Responsibility (Doc ID 817504.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Financials Intelligence - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
Discoverer Version 10



Symptoms

New Setup and use of discoverer work books using seeded End User Layer (EUL). All security setup has been done as per notes:
<Note 313418.1> Using Oracle Discoverer 10.1.2 with Oracle E-Business Suite Release 11i
<Note 290291.1> Implementation Checklist for Oracle Business Intelligence System for Financials Intelligence.
Reviewed <Note.139817.1> Discoverer BIS General Ledger Folders Queries Result In "Query Caused No Data". All appears to be setup correctly.

When signed on using the seeded responsibilities like General Ledger Super User, now data is returned in the GL Analysis workbook without issue. The issue is that a user defined responsibility is needed.. when it is used no data is returned.

Verified that the General Ledger Security Package is causing the issue by finding the following in the sql trace file:

.... AND GL_SECURITY_PKG.VALIDATE_ACCESS( GL_STANDARD_BALANCE.SET_
OF_BOOKS_ID,GL_STANDARD_BALANCE.CODE_COMBINATION_ID ) = 'TRUE' WITH
READ ONLY

With this option set to TRUE,  no data.
With this option set to FALSE, all data.

confirms the issue is with the GL_SECURITY_PKG.

When using the seeded Responsibility with option set to TRUE this is working and data can be seen. When using a user defined responsibility with option set to TRUE no data is returned.. when set to FALSE data is returned.

Need is to have this working for user defined responsibilities.

Attempting to set the  Profile 'Initialization SQL Statement - Custom' to 'begin gl_security_pkg; end;' at responsibility level generates an error:
A connection error has occurred.
- A connection error has occurred.
- Database Error - ORA-20001: Oracle error -6502:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small has been detected in
fnd_global.initialize[fnd_init_sql].
ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.FND_GLOBAL", line 240
ORA-06512: at "APPS.FND_GLOBAL", line 2086 ORA-06512: at "APPS.FND_GLOBAL", line 2170
ORA-06512: at "APPS.FND_GLOBAL", line 2312 ORA-06512: at "APPS.FND_GLOBAL", line 2250 ORA-06512:
at line 1 

so, this cannot be set at this time. 

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.