EGL: nVision Error: '904 - ORA-00904: invalid column name' When Running a Report Using a Scope.
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****
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:
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 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
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