Setting Up Project GL Reconciliation Security for E-Business Suite

Project Analytics supports security over following dimensions in Project GL Recon. In the Oracle BI Applications solution, the 'Business Unit' entity refers to 'Operating Unit Organizations' in EBS. The list of Business Units that a user has access to, is determined by E-Business Suite grants.

The following BI Duty Roles are applicable to the Project GL Recon subject area.

  • OBIA_EBS_PROJECT_EXECUTIVE_ANALYSIS_DUTY

  • OBIA_EBS_PROJECT_MANAGEMENT_ANALYSIS_DUTY

  • OBIA_EBS_PROJECT_DATA_SECURITY

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.

Security Entity GL Recon Cost Fact GL Recon Revenue Fact

Project Business Unit

N

N

Project Organization

N

N

Expenditure Business Unit

N

N

Contract Business Unit

N

N

Project

N

N

Resource Organization

N

N

Ledger

Y

Y

In order for data security filters to be applied, appropriate initialization blocks need to be enabled depending on the deployed source system.

EBS: Project GL Recon Ledger List EBS

Note:

On installation, initialization blocks are enabled for E-Business Suite R12. If you are deploying on a source system other than E-Business Suite R12, then you must enable the appropriate initialization blocks.

You must enable data security for Project GL Reconciliation in E-Business Suite by enabling E-Business Suite data security initialization block listed below. If only one source system is deployed, then you must make sure that all Project Security initialization blocks for other adapters are disabled. If more than one source system is deployed, then you must also enable the initialization blocks of those source systems.

  1. In Oracle BI Administration Tool, edit the BI metadata repository (for example, OracleBIAnalyticsApps.rpd) in online mode, and select Manage, Identity, then Application Roles.
  2. Double-click on OBIA_PROJECT_LEDGER_DATA_SECURITY, navigate to Permissions, then Data Filters, and enable all data security filters.
  3. Save the metadata repository.