E-QR: Joining a Query in Composite Query, "First Operand Of . Is NULL" Error

(Doc ID 2338114.1)

Last updated on DECEMBER 11, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

When creating a composite query of three queries, an error was occurring when attempting to run:

First operand of . is NULL, so cannot access member ColumnNumber. (180.236)
PSCPQMAIN_WRK_CPQNAME.FieldFormula Name:PopulateCPQ PCPC:26157 Statement:342
Called from:CPQ_PAGETAB_WRK.CPQ_SQL_TAB.FieldChange Statement:28

This error came after adding the third query joined to the first query.  The composite query did not give an error when it contained just the first two queries.

The three queries ran successfully individually from Query Manager.

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