EGL: Question on using Row Level Security and Query Security Record on PS_JRNL_HEADER, PS_JRNL_LN, AND PS_LEDGER. (Doc ID 662377.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201069977


****Checked For Relevance on 19-Sep-2012****


Goal

Want to use the record SP_BU_GL_CLSVW as a query security record on PS_JRNL_HEADER, PS_JRNL_LN, AND PS_LEDGER so that when users query against these records, they can only see the Business Units that they are only authorized to see.

Will this create a performance issue and/or affect our batch processing at all?

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