R12 Discoverer Reports: Gl_security_pkg.Validate_access Reports Not Working (Doc ID 804113.1)

Last updated on APRIL 24, 2015

Applies to:

Oracle Financials Intelligence - Version 12.0.0 to 12.1 [Release 12.0]
Information in this document applies to any platform.

Symptoms

On 12.0.6 Instance:

Upgraded instance from 11.5.9 to R12.0.6 - after the upgrade the discoverer views that call the gl.gl_security_pkg.validate_access - does not bring back any data. When the call is removed, data is returned.

Comment out returns data:
AND gl_security_pkg.validate_access (acct.ledger_id, acct.code_combination_id) = 'TRUE';

When logging into Discoverer it is done with the General Ledger Super User.

When only using the seeded views named glfv_% when attempting 
to query or "report" on them... when this is done data is seen without issue. 
 
Attempting to create and report on custom views...as an example: 
Create a view and attempt to query data on it: 
Test view: 
 
CREATE OR REPLACE VIEW test_gl_security (code_combination_id, 
segment1, 
segment2, 
segment3, 
segment4, 
segment5, 
segment6, 
segment7, 
segment8, 
ledger_id ) 
AS 
SELECT a.code_combination_id, a.segment1, a.segment2, a.segment3, 
a.segment4, a.segment5, a.segment6, a.segment7, a.segment8, 
b.ledger_id 
FROM gl.gl_code_combinations a, gl.gl_ledgers b 
WHERE a.chart_of_accounts_id = b.chart_of_accounts_id 
AND apps.gl_security_pkg.validate_access (b.ledger_id, 
a.code_combination_id 
) = 'TRUE'; 
 
This does not return data while the gl_security_pkg is being used. 
This does return data while the gl_security_pkg is not being used.

FILE VERSIONS 
--------------- 
OracleBI Discoverer 10g (10.1.2.2) 
Oracle Business Intelligence Discoverer Plus 10g (10.1.2.54.25) 
Discoverer Server - 10.1.2.54.25 
Discoverer Model - 10.1.2.54.25 
End User Layer 5.1.1.0.0.0 
End User Layer Library 10.1.2.54.25 
Oracle Databates 10g Enterprise Edition Release 10.2.0.4.0 - 64k 
JVM 1.6.0_12  
gluoaseb.pls: 
$Header gluoaseb.pls 120.20.12000000.2 2007/11/26 10:36:18 dthakker ship $ 
$Header gluoaseb.pls 120.20.12000000.2 2007/11/26 10:36:18 dthakker ship $

Changes

Upgrade from 11i to R12 Financials

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