My Oracle Support Banner

E1: SEC: SQL 92 Left Outer Join Business View and Row Security (Doc ID 663779.1)

Last updated on DECEMBER 29, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

I have an application that is based on a join business view. The application should display records that exist in the primary table even when there are no matching records in the secondary table. This works correctly until a user with row security uses the application. For a user with row security, only records that exist in both the primary and secondary tables are displayed in the application. Why are the results different in the application when row security is defined?

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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