About Managing Users, Groups, Application Roles, and Data Access

As the service administrator or security administrator, one of your initial tasks is to ensure that users have appropriate access to use Oracle Fusion Analytics Warehouse.

Users need access to objects and data. Access to objects include subject areas or elements of subject areas such as folders and attributes, front-end decks, cards, KPIs, and the legacy Oracle BI Enterprise Edition dashboards and answers. You grant access to the users by assigning groups to them. The groups inherit the permissions from the data and duty roles mapped to them. You can merge your security setup only with the main semantic model.

About Users

Users accessing Oracle Fusion Analytics Warehouse must exist in Oracle Identity Cloud Service.

You can create the users or synchronize them with the Oracle Identity Cloud Service instance associated with your Oracle Fusion Analytics Warehouse instance from different sources:
  • You can synchronize the Oracle Applications Cloud users with the Oracle Identity Cloud Service instance.
  • You can manually create users in the Oracle Identity Cloud Service instance directly or create users in the Oracle Identity Cloud Service instance using the Oracle Fusion Analytics Warehouse user interface.
  • You can synchronize the users from other 3rd-party systems with the Oracle Identity Cloud Service instance.

Users gain their access to Oracle Fusion Analytics Warehouse based on the Oracle Fusion Analytics Warehouse-specific system groups assigned to them. They gain access to different functionality, objects, and data in Oracle Fusion Analytics Warehouse based on the job-specific groups assigned to them.

You can assign the predefined system groups, groups available in the Oracle Identity Cloud Service instance associated with your Oracle Fusion Analytics Warehouse instance, and custom groups that you create in Oracle Fusion Analytics Warehouse. See Associate Users and Groups.

About Groups

Oracle Fusion Analytics Warehouse uses groups to provide users access to subject areas, objects, and data.

Oracle Fusion Analytics Warehouse uses the following three types of groups:
  • System groups created in Oracle Identity Cloud Service specifically for Oracle Fusion Analytics Warehouse. These system groups are associated with system roles that provide a set of privileges to the users to perform system tasks after signing into Oracle Fusion Analytics Warehouse, such as administering system settings, performing functional setup, managing security, and modeling data. See System Groups and System Roles.
  • Job-specific groups such as Vice President of Sales, Human Resources Analyst, and Procurement Buyer. The job-specific groups are job roles from Oracle Applications Cloud mapped as groups in Oracle Identity Cloud Service. See Job-Specific Groups.
  • Other groups that are generic groups created in Oracle Identity Cloud Service not specifically for Oracle Fusion Analytics Warehouse, such as IDCS_Administrators and All_Tenant_Users.

System Groups

Oracle Fusion Analytics Warehouse creates the system groups in Oracle Identity Cloud Service while provisioning your Oracle Fusion Analytics Warehouse instance.

System groups are associated with system roles that provide a set of privileges to users. The system roles serve two purposes:
  • Authenticate a user to Oracle Fusion Analytics Warehouse.
  • License a user to use Oracle Fusion Analytics Warehouse based on the system group they are assigned.
See System Roles.
You must add the users to the corresponding system groups based on the tasks they perform in Oracle Fusion Analytics Warehouse. See Assign Users to a Group and Assign Groups to Users. Use the Users or Groups tabs on the Security page to add users to these system groups:
System Group Code System Group Name Description Associated Oracle Fusion Analytics Warehouse System Role*
FAW_FUNCTIONAL_ADMINISTRATORS FAW Functional Administrator Fusion Analytics Warehouse Functional Administrators FunctionalAdmin
FAW_SECURITY_ADMINISTRATORS FAW Security Administrator Fusion Analytics Warehouse Security Administrators SecurityAdmin
FAW_MODELERS FAW Modeler Fusion Analytics Warehouse Modelers Modeler
FAW_MODELER_ADMINISTRATORS FAW Modeler Administrator Fusion Analytics Warehouse Modeler Administrators ModelerAdmin
FAW_SERVICE_ADMINISTRATORS FAW Service Administrator Fusion Analytics Warehouse Service Administrators ServiceAdmin
FAW_LICENSED_ERP_AUTHORS FAW Licensed ERP Authors Fusion Analytics Warehouse ERP Licensed Authors Author
FAW_LICENSED_ERP_CONSUMERS FAW Licensed ERP Consumers Fusion Analytics Warehouse ERP Licensed Consumers Consumer
FAW_LICENSED_HCM_AUTHORS FAW Licensed HCM Authors Fusion Analytics Warehouse HCM Licensed Authors Author
FAW_LICENSED_HCM_CONSUMERS FAW Licensed HCM Consumers Fusion Analytics Warehouse HCM Licensed Consumers Consumer

*See System Roles.

Job-Specific Groups

Job-specific groups are job roles synchronized from Oracle Applications Cloud into Oracle Identity Cloud Service.

Oracle Fusion Analytics Warehouse uses the following job-specific groups:

Job-Specific Group Code Job-Specific Group Name Description Associated Application Roles Associated Application Role Names Functional Area
ORA_GL_FINANCIAL_ANALYST_JOB Financial Analyst Has Author privileges

Author

OA4F_FIN_AP_BUSINESS_UNIT_DATA

OA4F_FIN_AR_BUSINESS_UNIT_DATA

OA4F_FIN_GL_ACCESS_SET_DATA

OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY

OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_DUTY

OA4F_FIN_GL_BUDGETS_ANALYSIS_DUTY

OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_DUTY

OA4F_FIN_GL_PROFITABILITY_ANALYSIS_DUTY

General Ledger Account Analysis Duty

General Ledger Balance Sheet Analysis Duty

General Ledger Budget Analysis Duty

General Ledger Detail Transactions Analysis Duty

Profitability Analysis Duty

GL
ORA_GL_GENERAL_ACCOUNTANT_JOB General Accountant Has Author privileges

Author

OA4F_FIN_AP_BUSINESS_UNIT_DATA

OA4F_FIN_AR_BUSINESS_UNIT_DATA

OA4F_FIN_GL_ACCESS_SET_DATA

OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY

OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_DUTY

OA4F_FIN_GL_BUDGETS_ANALYSIS_DUTY

OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_DUTY

OA4F_FIN_GL_PROFITABILITY_ANALYSIS_DUTY

General Ledger Account Analysis Duty

General Ledger Balance Sheet Analysis Duty

General Ledger Budget Analysis Duty

General Ledger Detail Transactions Analysis Duty

Profitability Analysis Duty

GL
ORA_GL_GENERAL_ACCOUNTING_MANAGER_JOB General Accounting Manager Has Author privileges

Author

OA4F_FIN_AP_BUSINESS_UNIT_DATA

OA4F_FIN_AR_BUSINESS_UNIT_DATA

OA4F_FIN_GL_ACCESS_SET_DATA

OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY

OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_DUTY

OA4F_FIN_GL_BUDGETS_ANALYSIS_DUTY

OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_DUTY

OA4F_FIN_GL_PROFITABILITY_ANALYSIS_DUTY

General Ledger Account Analysis Duty

General Ledger Balance Sheet Analysis Duty

General Ledger Budget Analysis Duty

General Ledger Detail Transactions Analysis Duty

Profitability Analysis Duty

GL
ORA_AP_ACCOUNTS_PAYABLE_INVOICE_SUPERVISOR_JOB Account Payable Invoice Supervisor Has Author privileges

Author

OA4F_FIN_AP_BUSINESS_UNIT_DATA

OA4F_FIN_GL_ACCESS_SET_ DATA

OA4F_FIN_AP_AGING_ANALYSIS_DUTY

OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY

OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY

OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY

OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY

OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY

OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY

Accounts Payable Aging Analysis Duty

Accounts Payable Expenses Analysis Duty

Accounts Payable Holds Analysis Duty

Accounts Payable Invoices Analysis Duty

Accounts Payable Liabilities Analysis Duty

Accounts Payable Payments Analysis Duty

General Ledger Account Analysis Duty

AP

ORA_AP_ACCOUNTS_PAYABLE_PAYMENT_SUPERVISOR_JOB Account Payable Payment Supervisor Has Author privileges

Author

OA4F_FIN_AP_BUSINESS_UNIT_DATA

OA4F_FIN_GL_ACCESS_SET_DATA

OA4F_FIN_AP_AGING_ANALYSIS_DUTY

OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY

OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY

OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY

OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY

OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY

OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY

Accounts Payable Aging Analysis Duty

Accounts Payable Expenses Analysis Duty

Accounts Payable Holds Analysis Duty

Accounts Payable Invoices Analysis Duty

Accounts Payable Liabilities Analysis Duty

Accounts Payable Payments Analysis Duty

General Ledger Account Analysis Duty

AP

ORA_AP_ACCOUNTS_PAYABLE_MANAGER_JOB Accounts Payable Manager Has Author privileges

Author

OA4F_FIN_AP_BUSINESS_UNIT_DATA

OA4F_FIN_AP_AGING_ANALYSIS_DUTY

OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY

OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY

OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY

OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY

OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY

OA4F_PROC_BUSINESS_UNIT_DATA

OA4F_PROC_SPEND_ANALYSIS_DUTY

Accounts Payable Aging Analysis Duty

Accounts Payable Expenses Analysis Duty

Accounts Payable Holds Analysis Duty

Accounts Payable Invoices Analysis Duty

Accounts Payable Liabilities Analysis Duty

Accounts Payable Payments Analysis Duty

Procurement Spend Analysis Duty

AP

Procurement

ORA_AP_ACCOUNTS_PAYABLE_SPECIALIST_JOB Accounts Payable Specialist Has Author privileges

Author

OA4F_FIN_AP_BUSINESS_UNIT_DATA

OA4F_FIN_AP_AGING_ANALYSIS_DUTY

OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY

OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY

OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY

OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY

OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY

OA4F_PROC_BUSINESS_UNIT_DATA

OA4F_PROC_SPEND_ANALYSIS_DUTY

Accounts Payable Aging Analysis Duty

Accounts Payable Expenses Analysis Duty

Accounts Payable Holds Analysis Duty

Accounts Payable Invoices Analysis Duty

Accounts Payable Liabilities Analysis Duty

Accounts Payable Payments Analysis Duty

Procurement Spend Analysis Duty

AP

Procurement

ORA_AP_ACCOUNTS_PAYABLE_SUPERVISOR_JOB Accounts Payable Supervisor Has Author privileges

Author

OA4F_FIN_AP_BUSINESS_UNIT_DATA

OA4F_FIN_AP_AGING_ANALYSIS_DUTY

OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY

OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY

OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY

OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY

OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY

OA4F_PROC_BUSINESS_UNIT_DATA

OA4F_PROC_SPEND_ANALYSIS_DUTY

Accounts Payable Aging Analysis Duty

Accounts Payable Expenses Analysis Duty

Accounts Payable Holds Analysis Duty

Accounts Payable Invoices Analysis Duty

Accounts Payable Liabilities Analysis Duty

Accounts Payable Payments Analysis Duty

Procurement Spend Analysis Duty

AP

Procurement

ORA_AR_ACCOUNTS_RECEIVABLE_MANAGER_JOB Accounts Receivable Manager Has Author privileges

Author

OA4F_FIN_AR_BUSINESS_UNIT_DATA

OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_DUTY

OA4F_FIN_AR_AGING_ANALYSIS_DUTY

OA4F_FIN_AR_APPLICATIONS_ANALYSIS_DUTY

OA4F_FIN_AR_CREDITMEMO_ANALYSIS_DUTY

OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_DUTY

OA4F_FIN_AR_REVENUE_ANALYSIS_DUTY

Accounts Receivable Adjustments Analysis Duty

Accounts Receivable Aging Analysis Duty

Accounts Receivable Receipts and Applications Analysis Duty

Accounts Receivable Credit Memo Applications Analysis Duty

Accounts Receivable Transactions Analysis Duty

Accounts Receivable Revenue Analysis Duty

AR
ORA_AR_ACCOUNTS_RECEIVABLE_SPECIALIST_JOB Accounts Receivable Specialist Has Author privileges

Author

OA4F_FIN_AR_BUSINESS_UNIT_DATA

OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_DUTY

OA4F_FIN_AR_AGING_ANALYSIS_DUTY

OA4F_FIN_AR_APPLICATIONS_ANALYSIS_DUTY

OA4F_FIN_AR_CREDITMEMO_ANALYSIS_DUTY

OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_DUTY

OA4F_FIN_AR_REVENUE_ANALYSIS_DUTY

Accounts Receivable Adjustments Analysis Duty

Accounts Receivable Aging Analysis Duty

Accounts Receivable Receipts and Applications Analysis Duty

Accounts Receivable Credit Memo Applications Analysis Duty

Accounts Receivable Transactions Analysis Duty

Accounts Receivable Revenue Analysis Duty

AR
ORA_EXM_EXPENSE_MANAGER_JOB Expense Manager Has Author privileges

Author

OA4F_FIN_AP_BUSINESS_UNIT_DATA

OA4F_FIN_EXM_EMPLOYEE_EXPENSE_ANALYSIS_DUTY

Employee Expense Analysis Duty

EXM
ORA_PO_BUYER_JOB Buyer Has Author privileges

Author

OA4F_PROC_BUSINESS_UNIT_DATA

OA4F_PROC_SPEND_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY

Procurement Spend Analysis Duty

Procurement Purchase Order Analysis Duty

Procurement Purchase Agreement Analysis Duty

Procurement Purchase Receipts Analysis Duty

Procurement

ORA_PO_PROCUREMENT_MANAGER_JOB Procurement Manager Has Author privileges

Author

OA4F_PROC_BUSINESS_UNIT_DATA

OA4F_PROC_SPEND_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY

Procurement Spend Analysis Duty

Procurement Purchase Order Analysis Duty

Procurement Purchase Agreement Analysis Duty

Procurement Purchase Receipts Analysis Duty

Procurement
ORA_PON_CATEGORY_MANAGER_JOB Category Manager Has Author privileges

Author

OA4F_PROC_BUSINESS_UNIT_DATA

OA4F_PROC_SPEND_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY

Procurement Spend Analysis Duty

Procurement Purchase Order Analysis Duty

Procurement Purchase Agreement Analysis Duty

Procurement Purchase Receipts Analysis Duty

Procurement

ORA_PO_PROCUREMENT_CONTRACT_ADMIN_JOB Procurement Contract Administrator Has Author privileges

Author

OA4F_PROC_BUSINESS_UNIT_DATA

OA4F_PROC_SPEND_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY

Procurement Spend Analysis Duty

Procurement Purchase Order Analysis Duty

Procurement Purchase Agreement Analysis Duty

Procurement Purchase Receipts Analysis Duty

Procurement

ORA_PO_PURCHASE_ANALYSIS_ABSTRACT Purchase Analysis Has Author privileges

Author

OA4F_PROC_BUSINESS_UNIT_DATA

OA4F_PROC_REQ_BUSINESS_UNIT_DATA

OA4F_PROC_SPEND_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY

OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY

Procurement Spend Analysis Duty

Procurement Purchase Order Analysis Duty

Procurement Purchase Receipts Analysis Duty

Procurement

ORA_INV_WAREHOUSE_MANAGER_JOB Warehouse Manager Has Author privileges

Author

OA4F_PROC_INV_ORG_DATA

OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY

OA4F_SCM_INV_BUSINESS_UNIT_DATA

OA4F_SCM_INV_INVENTORY_ORG_DATA

OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_DUTY

OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_DUTY

FAW_SCM_Author

Procurement Inventory Organization Data Security

Procurement Purchase Receipts Analysis Duty

Supply Chain Business Unit Data Security for Materials Management Business Function

Supply Chain Inventory Organization Data Security

Inventory Transactions Analysis Duty

Inventory Balances Analysis Duty

Procurement

Inventory

ORA_FA_ASSET_ACCOUNTING_MANAGE_JOB Asset Accounting Manager Has Author privileges

OA4F_FIN_FA_ASSET_BOOK_DATA

OA4F_FIN_FA_ASSETS_ANALYSIS_DUTY

OA4F_FIN_FA_ASSETS_TRANSACTIONS_DUTY

Fixed Asset Book Data Security

Fixed Asset Analysis Duty

Fixed Asset Transactions Analysis Duty

FA
ORA_FA_ASSET_ACCOUNTANT_JOB Asset Accountant Has Author privileges

OA4F_FIN_FA_ASSET_BOOK_DATA

OA4F_FIN_FA_ASSETS_ANALYSIS_DUTY

OA4F_FIN_FA_ASSETS_TRANSACTIONS_DUTY

Fixed Asset Book Data Security

Fixed Asset Analysis Duty

Fixed Asset Transactions Analysis Duty

FA
ORA_PJF_PROJECT_MANAGER_JOB Project Manager Has Author privileges

OA4F_PPM_PROJECT_MANAGER_DATA

OA4F_PPM_PROJECTS_COSTS_DUTY

OA4F_PPM_PROJECTS_COMMITMENTS_DUTY

Project Manager Data Security

Project Costing Costs Analysis Duty

Project Costing Commitments Analysis Duty

Projects
ORA_PJF_PROJECT_ADMINISTRATOR_JOB Project Administrator Has Author privileges

OA4F_PPM_PROJECT_BUSINESS_UNIT_DATA

OA4F_PPM_PROJECT_ORGANIZATION_DATA

OA4F_PPM_PROJECTS_COSTS_DUTY

OA4F_PPM_PROJECTS_COMMITMENTS_DUTY

Project Business Unit Data Security

Project Organization Data Security

Project Costing Costs Analysis Duty

Project Costing Commitments Analysis Duty

Projects
ORA_PJF_PROJECT_ACCOUNTANT_JOB Project Accountant Has Author privileges

OA4F_PPM_EXPENDITURE_BUSINESS_UNIT_DATA

OA4F_PPM_PROJECTS_COSTS_DUTY

OA4F_PPM_PROJECTS_COMMITMENTS_DUTY

Project Expenditure Business Unit Data Security

Project Costing Costs Analysis Duty

Project Costing Commitments Analysis Duty

Projects
ORA_CST_COST_ACCOUNTANT_JOB Cost Accountant Has Author privileges

Author

OA4F_SCM_CST_COSTING_ORG_DATA

OA4F_SCM_CST_INVENTORY_VALUATIONS_ANALYSIS_DUTY

OA4F_SCM_CST_ITEM_COST_ANALYSIS_DUTY

Supply Chain Costing Organization Data Security

Inventory Valuations Analysis Duty

Item Cost Analysis Duty

Cost Management
ORA_INV_INVENTORY_MANAGER_JOB Inventory Manager Has Author privileges

Author

FAW_SCM_Author

OA4F_SCM_INV_BUSINESS_UNIT_DATA

OA4F_SCM_INV_INVENTORY_ORG_DATA

OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_DUTY

OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_DUTY

Supply Chain Business Unit Data Security for Materials Management Business Function

Supply Chain Inventory Organization Data Security

Inventory Balances Analysis Duty

Inventory Transactions Analysis Duty

Inventory
ORA_DOO_ORDER_ADMINISTRATOR_JOB Order Administrator Has Author privileges

Author

OA4F_SCM_OM_BUSINESS_UNIT_DATA

OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY

OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY

Supply Chain Business Unit Data Security for Sales Business function

Order Management Analysis Duty

Order Management Holds Analysis Duty

Order Management
ORA_DOO_ORDER_MANAGER_JOB Order Manager Has Author privileges

Author

OA4F_SCM_OM_BUSINESS_UNIT_DATA

OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY

OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY

Supply Chain Business Unit Data Security for Sales Business function

Order Management Analysis Duty

Order Management Holds Analysis Duty

Order Management
ORA_FND_INTEGRATION_SPECIALIST_JOB Integration Specialist Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems. Has author privileges.

Author

OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY

- Common
ORA_PER_HUMAN_RESOURCE_ANALYST_JOB Human Resource Analyst Has Author privileges

Author

OA4F_HCM_HR_ANALYST_VIEW_ALL_DATA

OA4F_HCM_ABSENCE_ANALYSIS_DUTY

OA4F_HCM_ABSENCE_DIV_ANALYSIS_DUTY

OA4F_HCM_GOALS_ANALYSIS_DUTY

OA4F_HCM_PERFORMANCE_ANALYSIS_DUTY

OA4F_HCM_PROFILE_ANALYSIS_DUTY

OA4F_HCM_SALARY_BASIS_ANALYSIS_DUTY

OA4F_HCM_SALARY_BASIS_DIV_ANALYSIS_DUTY

OAF4_HCM_GAINS_LOSS_TRANSACTION_ANALYSIS_DUTY

OA4F_HCM_WORKFORCE_CORE_ANALYSIS_DUTY

Absence Management Analysis Duty

Absence Management Diversity Analysis Duty

Goal Management Analysis Duty

Performance Management Analysis Duty

Profile Management Analysis Duty

Salary Basis Analysis Duty

Salary Basis Diversity Analysis Duty

Workforce Core Analysis Duty

Workforce Gains and Losses Transaction Analysis Duty

Workforce
ORA_PER_LINE_MANAGER_ABSTRACT Line Manager Has Author privileges

Author

OA4F_HCM_LINE_MANAGER_DATA

OA4F_HCM_ABSENCE_ANALYSIS_DUTY

OA4F_HCM_ABSENCE_DIV_ANALYSIS_DUTY

OA4F_HCM_GOALS_ANALYSIS_DUTY

OA4F_HCM_PERFORMANCE_ANALYSIS_DUTY

OA4F_HCM_PROFILE_ANALYSIS_DUTY

OA4F_HCM_SALARY_BASIS_ANALYSIS_DUTY

OA4F_HCM_SALARY_BASIS_DIV_ANALYSIS_DUTY

OAF4_HCM_GAINS_LOSS_TRANSACTION_ANALYSIS_DUTY

OA4F_HCM_WORKFORCE_CORE_ANALYSIS_DUTY

Absence Management Analysis Duty

Absence Management Diversity Analysis Duty

Goal Management Analysis Duty

Performance Management Analysis Duty

Profile Management Analysis Duty

Salary Basis Analysis Duty

Salary Basis Diversity Analysis Duty

Workforce Core Analysis Duty

Workforce Gains and Losses Transaction Analysis Duty

Workforce
ORA_PER_HUMAN_RESOURCE_SPECIALIST_JOB Human Resource Specialist Has Author privileges

OA4F_HCM_VIEW_ALL_DATA

OA4F_HCM_ABSENCE_ANALYSIS_DUTY

OA4F_HCM_ABSENCE_DIV_ANALYSIS_DUTY

OA4F_HCM_GOALS_ANALYSIS_DUTY

OA4F_HCM_PERFORMANCE_ANALYSIS_DUTY

OA4F_HCM_PROFILE_ANALYSIS_DUTY

OA4F_HCM_SALARY_BASIS_ANALYSIS_DUTY

OA4F_HCM_SALARY_BASIS_DIV_ANALYSIS_DUTY

OA4F_HCM_WORKFORCE_CORE_ANALYSIS_DUTY

OAF4_HCM_GAINS_LOSS_TRANSACTION_ANALYSIS_DUTY

Author

Absence Management Analysis Duty

Absence Management Diversity Analysis Duty

Goal Management Analysis Duty

Performance Management Analysis Duty

Profile Management Analysis Duty

Salary Basis Analysis Duty

Salary Basis Diversity Analysis Duty

Workforce Core Analysis Duty

Workforce Gains and Losses Transaction Analysis Duty

Workforce
ORA_PER_HUMAN_RESOURCE_MANAGER_JOB Human Resource Manager Has Author privileges

OA4F_HCM_VIEW_ALL_DATA

OA4F_HCM_ABSENCE_ANALYSIS_DUTY

OA4F_HCM_ABSENCE_DIV_ANALYSIS_DUTY

OA4F_HCM_GOALS_ANALYSIS_DUTY

OA4F_HCM_PERFORMANCE_ANALYSIS_DUTY

OA4F_HCM_PROFILE_ANALYSIS_DUTY

OA4F_HCM_SALARY_BASIS_ANALYSIS_DUTY

OA4F_HCM_SALARY_BASIS_DIV_ANALYSIS_DUTY

OA4F_HCM_WORKFORCE_CORE_ANALYSIS_DUTY

OAF4_HCM_GAINS_LOSS_TRANSACTION_ANALYSIS_DUTY

Author

Absence Management Analysis Duty

Absence Management Diversity Analysis Duty

Goal Management Analysis Duty

Performance Management Analysis Duty

Profile Management Analysis Duty

Salary Basis Analysis Duty

Salary Basis Diversity Analysis Duty

Workforce Core Analysis Duty

Workforce Gains and Losses Transaction Analysis Duty

Workforce
ORA_IRC_RECRUITER_JOB Recruiter Has Author privileges

OA4F_HCM_REC_REQ_DATA

OA4F_HCM_REC_ANALYSIS_DUTY

Author

Recruitment Analysis Duty

Talent
ORA_IRC_RECRUITING_MANAGER_JOB Recruiting Manager Has Author privileges

OA4F_HCM_REC_REQ_DATA

OA4F_HCM_REC_ANALYSIS_DUTY

Author

Recruitment Analysis Duty

Talent
ORA_IRC_HIRING_MANAGER_ABSTRACT Hiring Manager Has Author privileges

OA4F_HCM_REC_REQ_DATA

OA4F_HCM_REC_ANALYSIS_DUTY

Author

Recruitment Analysis Duty

Talent
ORA_CMP_COMPENSATION_MANAGER_JOB Compensation Manager Gets access to workforce compensation subject area

OA4F_HCM_COMPENSATION_WORKSHEET_MANAGER_DATA

OA4F_HCM_COMPENSATION_DIV_ANALYSIS_DUTY

OA4F_HCM_COMPENSATION_ANALYSIS_DUTY

Compensation Worksheet Manager Data Security

Workforce Compensation Diversity Analysis Duty

Workforce Compensation Analysis Duty

HCM- Workforce Rewards- Workforce Compensation

Other Groups

The Other Groups category refers to groups created in Oracle Identity Cloud Service for purposes such as administrating Oracle Cloud Infrastructure and Oracle Identity Cloud Service.

These groups are not necessarily Oracle Fusion Analytics Warehouse-specific but you can use them in Oracle Fusion Analytics Warehouse. Examples of this category are the "IDCS_Administrators" and "All_Tenant_Users" groups.

About Application Roles

Application roles consist of duty and data roles.

Duty roles define the duties of a job as an entitlement to perform a particular action; for example, access to an AP Transactions subject area. Data roles provide access to the row-level data in the warehouse tables. Data roles group the users based on the functional access they have through a particular job role and a particular dimension of data. For example, a group of users based on invoices relevant only to their business unit.

Duty Roles

The predefined duty roles to secure the predefined subject areas and the predefined front-end objects are:

Duty Role Code Duty Role Name Duty Role Description Functional Area Gets access to Subject Area Display Name OR Associated Role
OA4F_FIN_GL_BALANCE_SHEET_ANALYSIS_DUTY General Ledger Balance Sheet Analysis Duty Object security role to control presentation catalog access to Financials GL Balance Sheet subject area. GL Financials - GL Balance Sheet
OA4F_FIN_GL_PROFITABILITY_ANALYSIS_DUTY Profitability Analysis Duty Object security role to control presentation catalog access to Financials GL Profitability subject area. GL Financials - GL Profitability
OA4F_FIN_GL_DETAIL_TRANSACTIONS_ANALYSIS_DUTY General Ledger Detail Transactions Analysis Duty Object security role to control presentation catalog access to Financials GL Detail Transactions subject area. GL Financials - GL Detail Transactions
OA4F_FIN_GL_BUDGETS_ANALYSIS_DUTY General Ledger Budget Analysis Duty Object security role to control presentation catalog access to Financials GL Budgets subject area. GL Financials - GL Budgets
OA4F_FIN_GL_ACCOUNT_ANALYSIS_DUTY General Ledger Account Analysis Duty Object security role to control presentation catalog access to GL Account Analysis subject area. GL Financials - GL Account Analysis
OA4F_FIN_AP_AGING_ANALYSIS_DUTY Accounts Payable Aging Analysis Duty Object security role to control presentation catalog access to Financials Accounts Payable Aging subject area. AP Financials – AP Aging
OA4F_FIN_AP_INVOICES_ANALYSIS_DUTY Accounts Payable Invoices Analysis Duty Object security role to control presentation catalog access to Financials Accounts Payable Invoices subject area. AP Financials – AP Invoices
OA4F_FIN_AP_LIABILITIES_ANALYSIS_DUTY Accounts Payable Liabilities Analysis Duty Object security role to control presentation catalog access to Financials Accounts Payable Liabilities subject area. AP Financials – AP Liabilities
OA4F_FIN_AP_PAYMENTS_ANALYSIS_DUTY Accounts Payable Payments Analysis Duty Object security role to control presentation catalog access to Financials Accounts Payable Payments subject area. AP Financials – AP Payments
OA4F_FIN_AP_EXPENSES_ANALYSIS_DUTY Accounts Payable Expenses Analysis Duty Object security role to control presentation catalog access to Financials Accounts Payable Expenses subject area. AP Financials - AP Expenses
OA4F_FIN_AP_HOLDS_ANALYSIS_DUTY Accounts Payable Holds Analysis Duty Object security role to control presentation catalog access to Financials Accounts Payable Holds subject area. AP Financials - AP Holds
OA4F_FIN_AR_AGING_ANALYSIS_DUTY Accounts Receivable Aging Analysis Duty Object security role to control presentation catalog access to Financials Accounts Receivable Aging subject area. AR Financials – AR Aging
OA4F_FIN_AR_TRANSACTIONS_ANALYSIS_DUTY Accounts Receivable Transactions Analysis Duty Object security role to control presentation catalog access to Financials Accounts Receivable Transactions subject area. AR Financials – AR Transactions
OA4F_FIN_AR_APPLICATIONS_ANALYSIS_DUTY Accounts Receivable Receipts and Applications Analysis Duty Object security role to control presentation catalog access to Financials Accounts Receivable Receipts and Applications subject area. AR Financials – AR Receipts and Applications
OA4F_FIN_AR_CREDITMEMO_ANALYSIS_DUTY Accounts Receivable Credit Memo Applications Analysis Duty Object security role to control presentation catalog access to Financials Accounts Receivable Credit Memo Applications subject area. AR Financials – AR Credit Memo Applications
OA4F_FIN_AR_ADJUSTMENTS_ANALYSIS_DUTY Accounts Receivable Adjustments Analysis Duty Object security role to control presentation catalog access to Financials Accounts Receivable Adjustments subject area. AR Financials – AR Adjustments
OA4F_FIN_AR_REVENUE_ANALYSIS_DUTY Accounts Receivable Revenue Analysis Duty Object security role to control presentation catalog access to Financials Accounts Receivable Revenue subject area. AR Financials - AR Revenue
OA4F_FIN_EXM_EMPLOYEE_EXPENSE_ANALYSIS_DUTY Employee Expense Analysis Duty Object security role to control presentation catalog access to Financials - EXM Employee Expenses subject area. EXM Financials - EXM Employee Expenses
OA4F_PROC_SPEND_ANALYSIS_DUTY Procurement Spend Analysis Duty Object security role to control presentation catalog access to Procurement Spend subject area. Procurement Procurement - Spend
OA4F_PROC_PURCHASE_ORDER_ANALYSIS_DUTY Procurement Purchase Order Analysis Duty Object security role to control presentation catalog access to Procurement Purchase Order subject area. Procurement Procurement - Purchase Orders
OA4F_PROC_PURCHASE_AGREEMENT_ANALYSIS_DUTY Procurement Purchase Agreement Analysis Duty Object security role to control presentation catalog access to Procurement Purchase Agreement subject area. Procurement Procurement - Agreements
OA4F_PROC_PURCHASE_RECEIPTS_ANALYSIS_DUTY Procurement Purchase Receipts Analysis Duty Object security role to control presentation catalog access to Procurement Purchase Receipts subject area. Procurement Procurement - Receipts
OA4F_PROC_REQUISITIONS_ANALYSIS_DUTY Procurement Requisitions Analysis Duty Object security role to control presentation catalog access to Procurement Requisitions subject area. Procurement Procurement - Requisitions
OA4F_PPM_PROJECTS_COSTS_DUTY Project Costing Costs Analysis Duty Object security role to control presentation catalog access to Projects Costs subject area. Projects PPM - Project Costs
OA4F_FIN_FA_ASSETS_ANALYSIS_DUTY Fixed Asset Analysis Duty Object security role to control presentation catalog access to Financials Assets Analysis subject area. FA Financials - Assets Analysis
OA4F_FIN_FA_ASSETS_TRANSACTIONS_DUTY Fixed Asset Transactions Analysis Duty Object security role to control presentation catalog access to Financials Assets Transactions subject area. FA Financials - Assets Transactions
OA4F_PPM_PROJECTS_COMMITMENTS_DUTY Project Costing Commitments Analysis Duty Object security role to control presentation catalog access to Projects Commitments subject area. Projects PPM - Project Commitments
OA4F_SCM_INV_INVENTORY_BALANCES_ANALYSIS_DUTY Inventory Balances Analysis Duty Object security role to control presentation catalog access to Inventory Balances subject area. Inventory SCM - Inventory Balances
OA4F_SCM_INV_INVENTORY_TRANSACTIONS_ANALYSIS_DUTY Inventory Transactions Analysis Duty Object security role to control presentation catalog access to Inventory Transactions subject area. Inventory SCM - Inventory Transactions
OA4F_SCM_CST_INVENTORY_VALUATIONS_ANALYSIS_DUTY Inventory Valuations Analysis Duty Object security role to control presentation catalog access to Inventory Valuations subject area. Cost Management SCM - Inventory Valuations
OA4F_SCM_CST_ITEM_COST_ANALYSIS_DUTY Item Cost Analysis Duty Object security role to control presentation catalog access to Item Cost subject area. Cost Management SCM - Item Cost
OA4F_SCM_OM_SALES_ORDER_ANALYSIS_DUTY Order Management Analysis Duty Object security role to control presentation catalog access to Sales Orders subject area. Order Management SCM - Sales Orders
OA4F_SCM_OM_HOLDS_ANALYSIS_DUTY Order Management Holds Analysis Duty Object security role to control presentation catalog access to Sales Holds subject area. Order Management SCM - Sales Orders Holds
OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY Data Warehouse Refresh Analysis Duty Object security role to control presentation catalog access to Common - Warehouse Refresh subject area. Common Common - Warehouse Refresh
OA4F_COMMON_USAGE_TRACKING_DUTY Usage Tracking Analysis Duty Object security role to control presentation catalog access to Common - Usage Tracking subject area. Common Common - Usage Tracking
OA4F_HCM_WORKFORCE_CORE_ANALYSIS_DUTY Workforce Core Analysis Duty Object security role to control presentation catalog access to Workforce Core subject area. Workforce Workforce - Core
OA4F_HCM_WORKFORCE_CORE_DIV_ANALYSIS_DUTY Workforce Core Diversity Analysis Duty Used to prevent access to Diversity related folders from Workforce Core subject area. It cannot be used in conjunction with Workforce Core Analysis Duty. Workforce Workforce - Core
OAF4_HCM_GAINS_LOSS_TRANSACTION_ANALYSIS_DUTY Workforce Gains and Losses Transaction Analysis Duty Object security role to control presentation catalog access to Workforce Gains and Losses subject area. Workforce Workforce Gains and Losses
OA4F_HCM_GAINS_LOSS_TRANSACTION_DIV_ANALYSIS_DUTY Workforce Gains and Losses Diversity Transaction Analysis Duty Used to prevent access to Diversity related folders from Workforce Gains and Losses subject area. It cannot be used in conjunction with Workforce Gains and Losses Transaction Analysis Duty. Workforce Workforce Gains and Losses
OA4F_HCM_REC_ANALYSIS_DUTY Recruitment Analysis Duty Role Object security role to control presentation catalog access to HCM - Talent Acquisition subject area. Talent HCM - Talent Acquisition
OA4F_HCM_ABSENCE_ANALYSIS_DUTY Absence Management Analysis Duty Object security role to control presentation catalog access to Workforce Absence Management subject area. Absence Management HCM - Workforce Absence Management
OA4F_HCM_ABSENCE_DIV_ANALYSIS_DUTY Absence Management Diversity Analysis Duty Used to prevent access to Diversity related folders from Workforce Absence Management subject area. It cannot be used in conjunction with Absence Management Analysis Duty Absence Management HCM - Workforce Absence Management
OA4F_HCM_COMPENSATION_ANALYSIS_DUTY Workforce Compensation Analysis Duty Object security role to control presentation catalog access to Workforce Rewards - Workforce Compensation subject area. Workforce Compensation HCM- Workforce Rewards- Workforce Compensation
OA4F_HCM_COMPENSATION_DIV_ANALYSIS_DUTY Workforce Compensation Diversity Analysis Duty Used to prevent access to Diversity related folders from Workforce Rewards - Workforce Compensation subject area. It cannot be used in conjunction with Workforce Compensation Analysis Duty. Workforce Compensation HCM- Workforce Rewards- Workforce Compensation
OA4F_HCM_PROFILE_ANALYSIS_DUTY Profile Management Analysis Duty Object security role to control presentation catalog access to Talent Profile subject area. Profile Management HCM - Talent Profile
OA4F_HCM_PROFILE_DIV_ANALYSIS_DUTY Profile Management Analysis Duty Used to prevent access to Diversity related folders from Talent Profile subject area. It cannot be used in conjunction with Profile Management Analysis Duty Profile Management HCM - Talent Profile
OA4F_HCM_PERFORMANCE_ANALYSIS_DUTY Performance Management Analysis Duty Object security role to control presentation catalog access to Performance Management subject area. Talent

HCM - Performance Management

HCM - Check-Ins

See "Separate duty roles for Performance Management and Check-Ins subject areas" in What's New for Oracle Fusion Analytics Warehouse.

OA4F_HCM_PERFORMANCE_ANALYSIS_DIV_DUTY Performance Management Diversity Analysis Duty Used to prevent access to Diversity related folders from Performance Management subject area. It cannot be used in conjunction with Performance Management Analysis Duty Talent

HCM - Performance Management

HCM - Check-Ins

OA4F_HCM_GOALS_ANALYSIS_DUTY Goal Management Analysis Duty Object security role to control presentation catalog access to Goals and Career Development subject area. Talent Goal Management Analysis Duty
OA4F_HCM_GOALS_ANALYSIS_DIV_DUTY Goal Management Diversity Analysis Duty Used to prevent access to Diversity related folders from Goals and Career Development subject area. It cannot be used in conjunction with Goal Management Analysis Duty Talent Goal Management Analysis Duty
OA4F_HCM_TALENT_REVIEW_ANALYSIS_DUTY Talent Review Management Analysis Duty Object security role to control presentation catalog access to HCM - Talent Review Meetings subject area. Talent HCM - Talent Review Meetings
OA4F_HCM_TALENT_REVIEW_DIV_ANALYSIS_DUTY Talent Review Management Diversity Analysis Duty Used to prevent access to Diversity related folders from HCM - Talent Review Meetings subject area. You can't use it in conjunction with the Talent Review Management Analysis Duty role. Talent HCM - Talent Review Meetings
OA4F_HCM_SUCCESSION_ANALYSIS_DUTY Succession Management Analysis Duty Object security role to control presentation catalog access to HCM-Succession Management subject area. Talent HCM - Succession Management
OA4F_HCM_SUCCESSION_DIV_ANALYSIS_DUTY Succession Management Diversity Analysis Duty Used to prevent access to Diversity related folders from HCM-Succession Management subject area. You can't use it in conjunction with the Succession Management Analysis Duty role. Talent HCM - Succession Management
OA4F_HCM_CHECKINS_ANALYSIS_DUTY Check Ins Analysis Duty Object security role to control presentation catalog access to Check-Ins subject area. Talent HCM - Check-Ins
OA4F_HCM_CHECKINS_ANALYSIS_DIV_DUTY Check Ins Diversity Analysis Duty Used to prevent access to Diversity related folders from Check-Ins subject area. You can't use it in conjunction with the Performance Management Analysis Duty role. Talent HCM - Check-Ins

Data Roles

The predefined data roles used to secure the predefined objects, custom facts, and custom dimensions are:

Data Role Code Data Role Name Description Functional Area
OA4F_FIN_GL_ACCESS_SET_DATA General Ledger Access Set Data Security Data security role to access ledger set based data GL, AP, and AR
OA4F_FIN_AP_BUSINESS_UNIT_DATA Accounts Payable Business Unit Data Security Data security role to access accounts payable business unit based data AP, EXM, and Procurement
OA4F_FIN_AR_BUSINESS_UNIT_DATA Accounts Receivable Business Unit Data Security Data security role to access accounts receivable business unit based data AR
OA4F_PROC_BUSINESS_UNIT_DATA Procurement Business Unit Data Security Data security role to access procurement business unit based data Procurement
OA4F_PROC_INV_ORG_DATA Procurement Inventory Organization Data Security Data security role to access Receipts subject area basis the receiving organization Procurement
OA4F_PROC_REQ_BUSINESS_UNIT_DATA Procurement Requisition Business Unit Data Security Data security role to access procurement Requisition business unit based data Procurement
OA4F_PPM_PROJECT_BUSINESS_UNIT_DATA Project Business Unit Data Security Data security role to access PPM Project business unit based data Projects
OA4F_PPM_PROJECT_ORGANIZATION_DATA Project Organization Data Security Data security role to access PPM Project Organization hierarchy based data Projects
OA4F_PPM_EXPENDITURE_BUSINESS_UNIT_DATA Project Expenditure Business Unit Data Security Data security role to access PPM Project Expenditure business unit based data Projects
OA4F_PPM_PROJECT_MANAGER_DATA Project Manager Data Security Data security based on the Projects that the Project Manager is assigned Projects
OA4F_FIN_FA_ASSET_BOOK_DATA Fixed Asset Book Data Security Data security role to access fixed asset book based data. FA
OA4F_SCM_OM_BUSINESS_UNIT_DATA Supply Chain Business Unit Data Security for Sales Business function Data security role to access supply chain order management business unit based data Order Management
OA4F_SCM_INV_BUSINESS_UNIT_DATA Supply Chain Business Unit Data Security for Materials Management Business Function Data security role to access supply chain inventory business unit based data Inventory
OA4F_SCM_INV_INVENTORY_ORG_DATA Supply Chain Inventory Organization Data Security Data security role to access supply chain inventory organization based data Inventory
OA4F_SCM_CST_COSTING_ORG_DATA Supply Chain Costing Organization Data Security Data security role to access supply chain costing organization based data Cost Management
OA4F_HCM_LINE_MANAGER_DATA Oracle Fusion Analytics Warehouse HR Line Manager Data Role Human Capital Management data security policy for the supervisor hierarchy Workforce
OA4F_HCM_VIEW_ALL_DATA Oracle Fusion Analytics Warehouse View All Data Role Human Capital Management data security policy to view all data Workforce
OA4F_HCM_COUNTRY_DATA Oracle Fusion Analytics Warehouse HCM Country Data Security Human Capital Management data security policy for the country data security context Workforce
OA4F_HCM_LEGAL_EMPLOYER_DATA Oracle Fusion Analytics Warehouse HCM Legal Employer Data Role Human Capital Management data security policy for the legal employer data security context Workforce
OA4F_HCM_DEPARTMENT_DATA Oracle Fusion Analytics Warehouse HCM Department Data Role Human Capital Management data security policy for the department data security context Workforce
OA4F_HCM_BUSINESS_UNIT_DATA Oracle Fusion Analytics Warehouse HCM Business unit Data Role Human Capital Management data security policy for the business unit data security context Workforce
OA4F_HCM_REC_REQ_DATA Recruitment Job Requisition Data Security Recruitment job requisition data security Talent Acquisition
OA4F_HCM_REC_ALL_REQ_DATA Recruitment Job Requisition View All Data Security Recruitment job requisition to view all data security Talent Acquisition
OA4F_HCM_REC_NON_RESTRICTED_APP_DATA Recruitment Non Restricted Job Application Data Security Recruitment data role to report on non restricted job applications Talent Acquisition
OA4F_HCM_REC_ALL_APP_DATA Recruitment Job Application View All Data Security Recruitment data role to report on all job applications Talent Acquisition
OA4F_HCM_COMPENSATION_WORKSHEET_MANAGER_DATA Compensation Worksheet Manager Data Security Compensation worksheet manager data security Workforce Compensation
OA4F_HCM_SUCCESSION_LINE_MANAGER_DATA Succession Supervisor Data Role Succession Supervisor Data Role Succession

System Roles

The system roles for Oracle Fusion Analytics Warehouse available in Oracle Identity Cloud Service through provisioning of Oracle Fusion Analytics Warehouse are:

Role Name Role Description Purpose Permissions
Administrator Tenant administrator for service instances Creates and manages Oracle Fusion Analytics Warehouse instances and administers Oracle Identity Cloud Service users and roles.
  • Creates and manages Oracle Fusion Analytics Warehouse instances
  • Administers Oracle Identity Cloud Service users and roles
  • Has no access to the Data Pipeline user interface
  • Has no access to the Data Security user interface
  • Has no access to the Job Monitoring Console user interface
  • Has no access to the Console menu
  • Has no access to user and group administration
  • Has no access to decks, cards, KPIs, visualizations, projects, and content
Service Administrator Oracle Fusion Analytics Warehouse service administrator Customer facing (Snapshots, Connections, System Settings) administrator access to Oracle Fusion Analytics Warehouse.
  • Can't create snapshots or modify the data model file (RPD)
  • Can access the Data Pipeline user interface
  • Can access the Data Security user interface
  • Has no access to the Job Monitoring console
  • Can access the Console menu
  • Can access the user and group administration pages
  • Can access the Semantic Model Extensions user interface
  • Has read-only access to the ready-to-use Oracle Analytics Cloud objects (visualization projects, dashboards, and analyses)
  • Requests from Oracle Fusion Analytics Warehouse to Oracle Analytics Cloud are routed through the Service Administrator user
  • Can create, update, and delete the Oracle Analytics Cloud content
  • Has read-only access to the ready-to-use KPIs
  • Can create, update, and delete KPIs
  • Can create, update, and delete decks and cards
  • Can share decks and cards
  • Can create Oracle Analytics Publisher reports
  • Has no access to data modeling
  • Has access to create Oracle Analytics Cloud connections to other non-Oracle Applications sources, such as Excel files and Google drive
  • Has access to create Oracle Analytics Cloud datasets
Functional Administrator Oracle Fusion Analytics Warehouse functional administrator Performs functional configuration (pipeline, reporting) in Oracle Fusion Analytics Warehouse.
  • Can access the Data Pipeline user interface
  • Has no access to the Data Security user interface
  • Has no access to the Job Monitoring console
  • Can access the Console menu
  • Has no access to user and role administration
  • Has no access to the Semantic Model Extensions user interface
  • Has no access to the ready-to-use Oracle Analytics Cloud objects (visualization projects, dashboards, and analyses)
  • Has no access to the ready-to-use KPIs
  • Has no access to decks, KPIs, and Oracle Analytics Cloud projects
  • Can't create any Oracle Analytics Cloud content and KPIs
  • Can't create, update, and delete decks and cards
  • Can't share decks and cards
  • Has no access to Oracle Analytics Publisher
  • Has no access to data modeling
  • Has no access to create Oracle Analytics Cloud connections
  • Has no access to create Oracle Analytics Cloud datasets
Security Administrator Oracle Fusion Analytics Warehouse security administrator Administers system roles and data security.
  • Has no access the Data Pipeline user interface
  • Has access to the Data Security user interface
  • Has no access to the Job Monitoring console
  • Can access the Console menu
  • Has access to user and group administration
  • Has no access to the Semantic Model Extensions user interface
  • Has no access to the ready-to-use Oracle Analytics Cloud objects (visualization projects, dashboards, and analyses)
  • Has no access to the ready-to-use KPIs
  • Has no access to decks, KPIs, and Oracle Analytics Cloud projects
  • Can't create any Oracle Analytics Cloud content and KPIs
  • Can't create, update, and delete decks and cards
  • Can't share decks and cards
  • Has no access to Oracle Analytics Publisher and data modeling
  • Has no access to create Oracle Analytics Cloud connections
  • Has no access to create Oracle Analytics Cloud datasets
Modeler Administrator Oracle Fusion Analytics Warehouse data model administrator Promote data model (RPD) customization to the Oracle Analytics Cloud instance.
  • Has no access to the Data Pipeline user interface
  • Has no access to the Data Security user interface
  • Has no access to the Job Monitoring console
  • Can access the Console menu
  • Has no access to user and role administration
  • Can access the Semantic Model Extensions user interface
  • Can access the ready-to-use Oracle Analytics Cloud objects (visualization projects, dashboards, and analyses)
  • Can access the ready-to-use KPIs
  • Can create KPIs
  • Can create Oracle Analytics Cloud content
  • Can't create, update, and delete decks and cards
  • Can't share decks and cards
  • Can't create Oracle Analytics Publisher reports
  • Has access to data modeling
  • Can apply the data model file (repository file) to the Test environment
  • Can create Oracle Analytics Cloud connections
  • Can create Oracle Analytics Cloud datasets
Modeler Oracle Fusion Analytics Warehouse modeler Modify the semantic model to bring in custom dimensions and attributes.
  • Has no access to the Data Pipeline user interface
  • Has no access to the Data Security user interface
  • Has no access to the Job Monitoring console
  • Can access the Console menu
  • Has no access to user and role administration
  • Can access the Semantic Model Extensions user interface
  • Can access the ready-to-use Oracle Analytics Cloud objects (visualization projects, dashboards, and analyses)
  • Can access the ready-to-use KPIs
  • Can create Oracle Analytics Cloud content
  • Can create KPIs
  • Can't create, update, and delete decks and cards
  • Can't share decks and cards
  • Can't create Oracle Analytics Publisher reports
  • Has access to data modeling
  • Can create Oracle Analytics Cloud connections
  • Can create Oracle Analytics Cloud datasets
Author Oracle Fusion Analytics Warehouse author Create and edit KPIs, cards, decks, visualization projects, reports, and dashboards.
  • Has no access to the Data Pipeline user interface
  • Has no access to the Data Security user interface
  • Has no access to the Job Monitoring console
  • Has no access to the Console menu
  • Has no access to user and role administration
  • Has no access to the Semantic Model Extensions user interface

  • Has read-only access to the ready-to-use Oracle Analytics Cloud objects (visualization projects, dashboards, and analyses); if you need a change, then create a copy using "Save As"
  • Has read-only access to the ready-to-use KPIs
  • Can edit the custom Oracle Analytics Cloud objects (visualization projects, dashboards, and analyses)
  • Can edit the custom KPIs
  • Can change the filter values for existing visualization projects
  • Can add filters for existing visualization projects
  • Can create and edit Oracle Analytics Cloud content, KPIs, decks, and cards
  • Can delete custom KPIs, decks, and cards
  • Can consume KPIs, cards, and decks created by other users on which they have access permissions
  • Can share decks and cards
  • Can create Oracle Analytics Publisher reports
  • Has no access to data modeling
  • Has no access to create Oracle Analytics Cloud connections
  • Has access to create Oracle Analytics Cloud datasets
Consumer Oracle Fusion Analytics Warehouse consumer Read access to Oracle Analytics Cloud content and can create cards and decks.
  • Has no access to the Data Pipeline user interface
  • Has no access to the Data Security user interface
  • Has no access to the Job Monitoring console
  • Has no access to the Console menu
  • Has no access to user and role administration
  • Has no access to the Semantic Model Extensions user interface

  • Has read-only access to the ready-to-use Oracle Analytics Cloud objects (visualization projects, dashboards, and analyses)
  • Has read-only access to the ready-to-use KPIs
  • Has read-only access to the custom Oracle Analytics Cloud objects (visualization projects, dashboards, and analyses)
  • Has read-only access to the custom KPIs
  • Can change the filter values for the existing visualization projects
  • Can't add filters for the existing visualization projects
  • Can't create any Oracle Analytics Cloud content
  • Can't create any KPIs
  • Can create, update, and delete decks and cards
  • Can share decks and cards
  • Has read-only access to Oracle Analytics Publisher
  • Has no access to data modeling
  • Has no access to create Oracle Analytics Cloud connections
  • Has access to create Oracle Analytics Cloud datasets

Refer to the full list of privileges in Mapping of System Roles to Permissions in Fusion Analytics Warehouse. This document is updated typically for each release of Oracle Fusion Analytics Warehouse. Ensure that you are signed into Cloud Customer Connect prior to viewing this document.

About Data Access through Security Assignments

You grant the data security assignments at the user-level.

Data security assignments apply data filters to display only the data corresponding to the security assignment values assigned to the users. For example, John Smith and Marie Pierce are both Accounts Payable Manager in an organization, but John Smith needs to see only the US business unit-specific data and Marie needs to see only the UK business unit-specific data. Even though both have the same functional role, their data security assignments differ. John is assigned all the US business units and Marie is assigned all the UK business units only.

You ensure data-level security with a combination of data roles, security context, and security assignments assigned to the user. Oracle Fusion Analytics Warehouse maps a security context 1:1 onto a data role. You grant the data security assignments within a security context. The user must have the data role through the group assigned to them in order to have access to the security context and its corresponding list of values to pick from. You assign a user one or more job-specific groups. The groups have data roles mapped to them, and when querying data, the semantic layer applies the data filters.

For Enterprise Resource Planning, the ledger, payables business unit, and receivables business unit values are restricted by the ledgers that you selected while setting up the report parameters. To establish the security permissions, you'd need to map users to security assignments. If a user doesn't have security assignment values mapped, then the user doesn't get to see any datasets corresponding to the job role (and implicitly data role) assigned to them. When you add data security assignments to a user, you ensure that the user can access specific data within a security context, such as ledger, payables business unit, or receivables business unit. See Set Up the Reporting Configurations for Enterprise Resource Planning.

For Human Capital Management, the data security is based on the line manager hierarchy defined in Oracle Applications Cloud for the user having the Line Manager role. For Human Capital Management, the data security is based on the talent acquisition hierarchy defined in Oracle Applications Cloud for the user having the Job Application or Job Requisition roles. All users can see their own records using the HCM Show context. A user with the HR Analyst role has access to all Human Capital Management data and no security restrictions are applied to the Human Capital Management data set. A user with the Hiring Manager role has access to non-restricted job applications, while users with the Recruiter and Recruiting Manager role can view all job applications. The business unit, legal employer, department, country security context, and related data roles are restricted by contexts and assigned predicate values. To establish the security permissions, you'd need to map users to security assignments