Concurrent: Report Access Level and R12

Oracle Applications does not allow users to view other's output. Internally Report Review Agent allows(RRA) only the user who submitting the report to view the report output. For those who are very new to Oracle can understood RRA as a default text viewer that Oracle Applications provides, which allows users to view report output and log files. Very often report Review Agent is also referred by the executable FNDFS.
That mean the output cann't be utlized by another user unless untill you have provided the profile option setup for another user.
Sometime business user wants to see other user report submitted by another?
Minimum you have do is you need to alter the value of seeded profile options "Concurrent:Report Access Level".
dgreybarrow Business case
Within Oracle installation , lets say you have four different user profiles been maintained:
  1. Super User : the one who has access to everything
  2. Supervisor : the one who does not have access to all the functions but access to most of Function expect few setup.
  3. User : the one who has access to limitted screens based on their responsibility
  4. Inquiry :o ne who has access to limitted screens based on their responsibility.

But along with that, all the users belongs to any of the above category has access to all the Request details like Log, Output, Details screen and Parameters.
in 11i we are able to see all the Concurrent Job details if we are using single a responsibility. But with different responsibilities assigned accross users, only those users that belong to the same responibility can see the Concurrent Job details submitted by others.
that mean if a)UserA is superUser b) UserB is only User and if UserB has submitted a Job and UserA canot see the details of that job even if he is SuperUser as he belongs to a different responsibility.
Resolutions
Attach Profile options "Report Access Level" either at Responsibility leval or user level.
dgreybarrow Concurrent: Report Access Level
This profile determines access privileges to report output files and log files generated by a concurrent program. The system profile option "Concurrent:Report Access Level" provides 2 options.
1.If you setting this profile option are set to "User" then you can:
View the completed report output for your requests online
View the diagnostic log file for those requests online
Reprint your completed reports, if the Concurrent:Save Output profile option is set to "Yes".
2.If you setting this profile option is set to "Responsibility", access to reports and diagnostic log files is based on the your current responsibility.
This profile option is visible and updatable at the site, responsibility, and user levels.

Report Access Level
The internal name for this profile option is CONC_REPORT_ACCESS_LEVEL
dgreybarrow R12 - Profile option "Concurrent:Report Access Level"
Within R12 environment,the profile option "Concurrent:Report Access Level" is inactivated.
It is replaced by a 'grants' function,that mean the RBAC (User Management) has to be implemented in R12 to replace this profile Options to enabled users to view out users log and output files in the Oracle Forms.
dgreybarrow Suggested Reading
  • Note:555524.1 :How To Configure Access To Request Output Of Specific Responsibility
     
     

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...