Setting Up Fixed Asset Security for PeopleSoft

Financial Analytics supports security over fixed asset books in Fixed Asset subject areas. The list of asset books that a user has access to is determined by the grants in PeopleSoft.

The following BI duty role is applicable to the Fixed Asset subject areas for PeopleSoft: Fixed Asset Accounting Manager PSFT.

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 Fixed Asset security for PeopleSoft, enable Oracle PeopleSoft 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: Fixed Asset Book

  • Oracle E-Business Suite: Fixed Asset Book EBS

  • Oracle PeopleSoft: Fixed Asset Book PSFT

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