Setting Up Accounts Payable Security for Oracle Fusion Applications

Oracle Fusion Applications security is enabled by default so there is no change required in the setup. If more than one source system is deployed, then you must also enable the initialization blocks of those source systems.

Financial Analytics supports security over Payables Invoicing Business Unit in Accounts Payable subject areas. This Business Unit is the same as Business Unit in Oracle Fusion Applications, and the list of Business units that a user has access to is determined by the grants in Oracle Fusion applications. Accounts Payable supports the ability to drill down on Purchase Order Number to the associated Purchase Order Details in Procurement and Spend Analytics. In order for this drill to work, the Procurement and Spend Analytics offering must be licensed and implemented. The Payables user must be granted at least one of the Procurement and Spend BI Duty Roles.

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

  • OBIA_ACCOUNTS_PAYABLE_MANAGERIAL_ANALYSIS_DUTY

These Duty Roles control the subject areas and dashboard content to which the user has access. These Duty Roles also ensure the data security filters are applied to all the queries. For more information about how 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. The initialization block names relevant to various source systems are given below. For example:

  • Oracle Fusion Applications: Payables Business Unit

  • Oracle E-Business Suite: Operating Unit Organizations EBS

  • Oracle PeopleSoft: Payables 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 RPD file.