E-QR: Joining a Query in Composite Query, "First Operand Of . Is NULL" Error
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms