Reporting

Left Outer Join

by tsimpson ()

Submitted By: Hadley Garbart

MICA Issue ID: 1244

Oracle PeopleSoft Issue ID: 201039880

HEUG Issue ID:

Status: Resolved

When testing the way that we have become accustomed to in creating a left outer join (this is a portion from the current query)

[in the where clause]
AND A.EMPLID*=G.EMPLID AND 'A' = 'A' …

the following error results

Query Issue: Large Data Set

by tsimpson ()

Submitted By: Hadley Garbart

MICA Issue ID: 1241

Oracle PeopleSoft Issue ID:

HEUG Issue ID:

Status: Resolved

Issue Description: When trying to run the SR_201 query using Query Viewer, it failed and returned the following warning …

"Query Result Set too Large (50,546)

Reporting Issues

by tsimpson ()

Reporting Issues

Syndicate content