Tuesday, September 22, 2009

Is Thers a Document That Defines All System Administrator Concurrent Requests?

No document exists that list all the concurrent programs definitions and descriptions.There are many programs and are handled by many different teams, there is documentation for eachindividual program, but nothing that summarizes all together.A search through My Oracle Support application with the concurrent program executable name will return references that contain details of the particular program..The following is a query that summarizes all the concurrent programs and a brief description ofthem plus their respective executable file. This is the same information that you can be obtained throughapplications if you navigate programs one by one.


SQL> select cp.concurrent_program_name, cpt.user_concurrent_program_name, cpt.description,ex.executable_name, ext.user_executable_name, ext.descriptionfrom fnd_concurrent_programs cp, fnd_concurrent_programs_tl cpt,fnd_executables ex, fnd_executables_tl extwhere cp.concurrent_program_id = cpt.concurrent_program_idand ex.executable_id = ext.executable_idand cp.executable_id = ex.executable_id;

The System Administrator’s Guide does summarize some of the common programs utilized andtheir description, for example:

- Function Security Reports

- Active Responsibilities Report

- Active Users Report

- Signon Audit Concurrent Requests Report

- Signon Audit Responsibilities Report

- Report Group Responsibilities Reportand so on.

You may use Concurrent Program Details Report, which will list every concurrent report, to find out more details on a specfic report.The "Concurrent Program Details Report" provides details on how the program is registered and the"description" abstract of the registered program.For usage, you need to reference applications manuals.

No comments: