"Select Error: ASA Error -142: Correlation name 'item' not found" on web/application server when trying to run a report or form in Expedition. The form or report appears blank on the workstations. (Doc ID 899327.1)

Last updated on JULY 12, 2016

Applies to:

Primavera Contract Management - Version: 9.1 and later   [Release: 9.0 and later ]
Primavera Contract Management - Version: 9.1 and later    [Release: 9.0 and later]
All Platforms

Symptoms

Modify reports or forms containing a table with two outer joins. Resolving "correlation not found" issues in forms or reports

There are several ways to revise the SQL to handle the necessary conditions. As long as the table in question does not have more than one outer join, the query should work in java.

"Select Error: ASA Error -142: Correlation name 'item' not found" on web/application server when trying to run a report or form in Expedition. The form or report appears blank on the workstations.

Error may occur for tables other than 'item'

(The report may have worked in previous versions of Expedition or InfoMaker)


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms