Setting Up Accounts Receivable Security for Oracle E-Business Suite

Financial Analytics supports security over Billing and Revenue Management Business Unit in Accounts Receivable subject areas. This Business Unit is the same as Operating Unit Organization in E-Business Suite, and the list of Operating Unit Organizations that a user has access to is determined by the grants in E-Business Suite.

The following BI Duty Roles are applicable to the Accounts Receivable subject area.

  • AR Analyst

  • AR Manager

These duty roles control the subject areas and dashboard content to which the user has access. Additionally, they ensure that the data security filters are applied to all the queries. To define new groups and mappings for users and BI roles, see How to Define New Groups and Mappings for Users and BI Roles.

To apply data security filters, enable the appropriate initialization blocks depending on the deployed source system. To enable Accounts Receivable security for E-Business Suite, enable Oracle E-Business Suite initialization block and make sure the initialization blocks of all other source systems are disabled. The initialization block names relevant to various source systems are given below. If more than one source system is deployed, then you must also enable the initialization blocks of those source systems.

  • Oracle Fusion Applications: Receivables Business Unit

  • Oracle E-Business Suite: Operating Unit Organizations EBS

  • Oracle PeopleSoft: Receivables Organizations

  1. In Oracle BI Administration Tool, edit the BI metadata repository (RPD file).
  2. Choose Manage, then Variables to display the Variables dialog
  3. Under Session – Initialization Blocks, open the initialization block that you need to enable.
  4. Clear the Disabled check box.
  5. Save the repository file.