EGL: nVision Error: '904 - ORA-00904: invalid column name' When Running a Report Using a Scope. (Doc ID 612959.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 7.5 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 720375


***Checked for relevance on 19-OCT-2010***
****Checked for Currency on Dec-18-2014****

****Checked for Currency on Feb-11-2013****

Symptoms


Receive nVision error when running a report using a Scope.

The scope is using a selected detail value. 

The first instance will be created successfully

The Second Instance receives error: SQL error. Stmt #: 446  Error Position: 476  Return: 904 - ORA-00904: invalid column name.

nVision generated an incorrect alias, in this case: A3_4. This is the SQL Select statement for the second instance:

SELECT A.ACCOUNT,SUM(A.POSTED_TOTAL_AMT)
FROM PS_LEDGER A, PSTREESELECT06 L
WHERE A.LEDGER='ACTUALS' AND A.FISCAL_YEAR=1995
 AND A.ACCOUNTING_PERIOD=12 AND A.BUSINESS_UNIT='M04
 AND  L.SELECTOR_NUM=222 AND A.ACCOUNT>= L.RANGE_FROM_06
 AND A.ACCOUNT <= L.RANGE_TO_06
 AND L.TREE_NODE_NUM BETWEEN 101694916 AND 305084745
 AND  A3_4.SELECTOR_NUM=222
 AND A.ACCOUNT>= A3_4.RANGE_FROM_06
 AND A.ACCOUNT <= A3_4.RANGE_TO_06
 AND (A3_4.TREE_NODE_NUM BETWEEN 101694916 AND 305084745
 OR A3_4.TREE_NODE_NUM BETWEEN 1288135591 AND 1969868171)
 AND A.DEPTID='21300' AND A.CURRENCY_CD='USD' AND A.STATISTICS_CODE=' '
GROUP BY A.ACCOUNT

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