My Oracle Support Banner

E-QR: Joining a Query in Composite Query, "First Operand Of . Is NULL" Error (Doc ID 2338114.1)

Last updated on JULY 27, 2022

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

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
Symptoms
Cause
Solution
References


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