EGL: Question on using Row Level Security and Query Security Record on PS_JRNL_HEADER, PS_JRNL_LN, AND PS_LEDGER.
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?
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