OBIA 11.1.1.x How do You Implement Departmental Chartfield Security From PeopleSoft? (Doc ID 1987019.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

How do you configure chartfield security on department?

You have implemented chart field security on the department using the following People Book

PeopleSoft Enterprise Application Fundamentals 9.1 PeopleBook

Securing ChartFields

You are now trying to integrate your security for OBIA, putting data level filters based on the query given in

Oracle® Fusion Middleware Configuration Guide for Oracle Business Intelligence Applications
11g Release 1 (11.1.1.7)
Part Number E36171-03

B.3 Informational Task Reference - Security
B.2.93.3 Configuring GL Segment Security

You can see that the security is meant to read from the PS_KSEC_RULES, however these tables are not populated after the configuration. You are seeing our departmental security information in this table: PS_SEC_RULE_ROLE

How should you go about using the PeopleSoft Department Chartfield security?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms