EAP: First Operand of . is NULL Error Occurs When Try to View SQL of PS Query APY2030_TRIAL_PAYMENT_REGISTER

(Doc ID 2092769.1)

Last updated on MARCH 18, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

 Below error occurs when try to view SQL of PS queries APY2030_TRIAL_PAYMENT_REGISTER or BCH1000_EFT_PAYMENT_DETAIL

Steps:
------
  1: Go to Query Manager
  2: Open the PS Query APY2030_TRIAL_PAYMENT_REGISTER or BCH1000_EFT_PAYMENT_DETAIL
  3: Click on View SQL tab
  
Error:
------
First operand of . is NULL, so cannot access member ColumnNumber. (180,236) QRYFUNCTIONS.QRYQUERYFUNCS.FieldFormula Name:WriteLevel PCPC:61168 Statement:896
Called from:QRYFUNCTIONS.QRYQUERYFUNCS.FieldFormula Name:WriteQueryToApi Statement:1015
Called from:QRY_SQL.Activate Statement:10

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