My Oracle Support Banner

E1: RDA: Same Column Name from Two Tables in Business View Join Results in Issue with Data Returned to Column on Report Executed on AS400 (Doc ID 2816790.1)

Last updated on OCTOBER 31, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
IBM i on POWER Systems


In a business view simple join, when the same column name is included from both tables, the column content of the Secondary table is incorrect, it is overwritten with the column content of the Primary table when a report using the business view is run on the AS/400.  

When report is run Local, contents of the same column name from both tables are correct.




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.