My Oracle Support Banner

E1: RDA: Data Selection Issue When Same Table Is Linked Twice To the Same Business View Join. This Issue Is Specific to Web Client (Doc ID 2659670.1)

Last updated on APRIL 15, 2020

Applies to:

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


This is a custom report based on a business view which has a join of F3002 (Bill of Material Master Table) and F4101 (Item Master Table). The F4101 table is linked to this business view twice, first time with parent and second time with child item.

When this UBE is executed from a Web Client, the data selection of F4101 table which is linked with child item is not considered. System always overrides data selection to be related with table which was connected first to this business view.

However this issue doesn't occur when the UBE is submitted from Fat Client.

Here is the SQL when submitted from the Web Client




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.