E-QR: In Query Designer, Left Outer Join Must Be The Last Joined To The Last Record In The Query. (Doc ID 2823197.1)

Last updated on NOVEMBER 29, 2021

Applies to:

Symptoms

 In Application Designer/psqed.exe, Go menu, Query Tool, when doing an outer join to the table except last table, the application will through below message.

The same issue does not occur in PIA (web application).

The issue can be reproduced at will with the following steps:

1. Open Application Designer by going to %ps_home%\bin\client\winx86\pside.exe .

2. Select 'Go' menu.

3. Go to Query.

Or Open Query Designer by going to %ps_home%\bin\client\winx86\psqed.exe .

4. Select File > New to create a new Query.

5. For example, Start with the VOUCHER table and add the VOUCHER_LINE table as a standard join.

6. Selecting the VOUCHER table try to add the VENDOR table as an ‘outer join’, below message appear,

Cause

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