My Oracle Support Banner

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

Last updated on NOVEMBER 25, 2019

Applies to:

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


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 (
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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.