Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Search Operations in JDE with filter / row security

edited Jun 24, 2025 7:16PM in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered

Hello,

Suppose I have defined row security (Inclusive ) on a user with access to specific company data say Company ABC. When this user opens a JDE application and does a Search, is the database response faster if he puts in a company filter day CO =ABC in the search or it does not matter since the SQL query generated even if he does not do a search will have CO=ABC as part of the row security.

If Row security is defined, does putting a company filter make performance better or it does not matter ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center