My Oracle Support Banner

Report Manager - Users To Value Security Does Not Take Effect To Restrict The Expansion Value (Doc ID 1546024.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Report Manager - Version 12.0.0 and later
Information in this document applies to any platform.


Report Manager - Users to Value security does not take effect to restrict the expansion value

After assigning a value set to participate in the Users to Value security and assign certain user as a viewer in one value, this user can see all expansion values on the report submitted.

The issue can be reproduced at will with the following steps:
1- Login to Report Manager responsibility and go to Security Workbench
2- Cost_Center values set added to participate in the Users to Value security. Click Security Listing Report to show the security created.
3- Click Go without searching criteria to see all security created.

4- REPMGR user added as a viewer for one value (1011005), so this user expected to see only this value.
5- Now start to submit the financial report. Go to Financial Report Submission.
6- Enter Report Name Example:  “Exp Report Head Office Compare”, content set “Head Office Exp”, Period “Jan-13”, Row order “Balance Sheet”, then click Next
7- Choose the template and Timeframe, then go to Security and choose “Cost_Center” User to Value Security. Click Next
8- Select a new storage location and enter the report name.
9- Choose a new folder created the click Next
10- Create new Menu Item for the report “NADEC Expenses Report 001” and assign it to responsibility “NADEC Expenses Report”. Click Next
11- Click Submit.
12- Click Ok.
13- Login as REPMGR user.
14- Go to the new Menu Item created “NADEC Expenses Report 001” 
15- Expect to see one value “1011005” since this user assigned as a viewer to this value only, although, the user can see all expansion values.



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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.