About ETL Roles

Access to Configuration Manager and Functional Setup Manager is controlled through these duty roles.

Oracle BI Applications has two duty roles for ETL operations:

  • Load Plan Operator Duty

  • Load Plan Administrator Duty

Oracle BI Applications has the following additional duty roles:

  • BI Applications Administrator Duty

  • BI Applications Functional Developer Duty

  • BI Applications Implementation Manager Duty

The security administrator must grant the appropriate duty roles to a user based on the user's job responsibilities. For information on the Configuration Manager and Functional Setup Manager screens that each duty role has access to, see Oracle Business Intelligence Applications Security Guide.

The BI Applications administrator, load plan operator, and load plan administrator users will require appropriate access to ODI. In addition to these users being created in the LDAP system, these users must also be created in the ODI Repository, and they must be granted the Supervisor profile or an appropriate ODI profile. The BI Applications administrator must be granted the Supervisor role in ODI. Work with your security administrator to obtain the appropriate duty roles.

For more information about managing security in ODI, see Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator.