How to user access (DML) the oracle apps table data or getting reports?
An oracle apps user can access the table data’s or reports through responsibilities.
The below figure may be help you to understand some more.
Oracle apps login
To connect to the Oracle Applications, you must have an Oracle Apps login ID created by the System Administrator of the Oracle Applications instance.
If the login is successful it will lead you to the responsibility page as shown in figure below. This page will show all the responsibilities that have been assigned to your Login ID by the System Administrator.
Responsibilities control what applications the user can access and - once in - what they can do within the application. They control what screens the user sees, what choices they may make from those screens, what reports they can run, and, at the lowest level...
Every responsibility has application, menu, request group details.
Oracle Applications comprise the applications software or business software of Oracle Corporation.
Oracle Corporation sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle Projects, Oracle CRM, Oracle PO, etc.
Menu controls what screens the user sees, what choices they may make from those screens.
Request group controls, what reports they can run.
A data group is a list of Oracle Applications and the ORACLE usernames assigned to each application.