My Oracle Support Banner

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 27, 2017

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****


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?


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.