My Oracle Support Banner

E1: TDA: Overview of Business Views Available within Business View Design (Doc ID 646081.1)

Last updated on MARCH 02, 2024

Applies to:

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


This document provides an overview of Business Views and covers the different join types available in Business View Design Aid.


The document is intended for the EnterpriseOne developer who will be creating business views and the system administrator who will be troubleshooting applications that make use of join business views.  


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
 Business View
 Adding a Business View
 Table Join
 Simple Join
 Right Outer Join
 Left Outer Join
 SQL 92 Left Outer Join (Available from EnterpriseOne release 8.9 and above)
 Table Union
 Table Union ALL
 Select Distinct
 Primary Key Fields

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