Master Oracle Security, Profile Options, Menus, and Concurrent Processing.
The System Administrator (SysAdmin) module is the backbone of Oracle EBS and Fusion. It controls user access, security, application behavior (via Profile Options), concurrent processing (batch jobs), and the overall configuration of the environment. Every technical and functional consultant must understand these core concepts.
You must have the "System Administrator" responsibility (or IT Security Manager role in Fusion) to perform these setups.
Understand the security hierarchy: Users have Responsibilities (Roles), which have Menus, which contain Functions.
System Administrator
System Administrator
System Administrator
System Administrator
System Administrator
Actor: System Administrator | Module: FND / Security
The foundation of security is the User Account. You create a username, set a password, and optionally link the account to an HR Employee record.
Example: Create user "JSMITH". Link it to the employee record "Smith, John". Assign the "Payables Manager" responsibility.
Navigation Path:
Tools > Security Console > Users
Key Actions:
Search or Create User. Add Roles (e.g., Accounts Payable Manager) to the user.
Actor: System Administrator | Module: FND / Security
A Responsibility determines what a user can do (Menus) and what data they can see (Data Groups / Request Groups).
Example: Create a custom Responsibility "XX_AP_MANAGER" based on the standard Payables Manager, but removing the "Setup" menu.
Navigation Path:
Tools > Security Console > Roles
Key Actions:
Fusion uses Role-Based Access Control (RBAC). You define Job Roles, Duty Roles, and Data Roles.
Actor: System Administrator | Module: FND / Core
Profile Options are system variables that change the behavior of the application. They can be set at Site, Application, Responsibility, or User levels.
Example: Set "MO: Operating Unit" to "Vision Operations" at the Responsibility level so the user only sees data for that specific operating unit.
Navigation Path:
Setup and Maintenance > Manage Administrator Profile Values
Key Actions:
Similar hierarchy: Site, Product, User.
Actor: System Administrator | Module: FND / Concurrent Processing
When a technical developer writes a new report or PL/SQL script, the SysAdmin must register it as a Concurrent Program so users can run it from the front-end.
Example: Register a custom PL/SQL procedure as a concurrent program named "XX Custom AP Interface". Define its parameters (e.g., Date, Supplier).
Navigation Path:
Setup and Maintenance > Manage Enterprise Scheduler Job Definitions
Key Actions:
Define an ESS (Enterprise Scheduler Service) Job, link it to the BI Publisher report or PL/SQL package, and assign it to a Job Role.
Actor: System Administrator | Module: FND / Security
Menus define the navigation tree. Functions define specific actions (like clicking a button). You can use Menu Exclusions to hide specific screens or buttons without modifying the code.
Example: You assign the "Payables Manager" menu to a responsibility, but you add a Menu Exclusion for the "Payments" function so they can enter invoices but cannot pay them.
Navigation Path:
Tools > Structure (for navigation) or Security Console (for privileges)
Key Actions:
Define Privileges and assign them to Duty Roles.
Understand the three-tier architecture that the SysAdmin supports.
Read Guide