Currently Being Moderated
Hi all,
I am trying to do a full load for subject area " Financial - General Ledger ", but faild at SDE_ORA_Stage_GLHierarchy_Extract.
Looked at the session log in Informatica, found getting error when executing the following SQL statement
ORA-00920: invalid relational operator
SELECT
RG_REPORT_CALCULATIONS.LAST_UPDATE_DATE,
RG_REPORT_CALCULATIONS.LAST_UPDATED_BY,
RG_REPORT_CALCULATIONS.CREATION_DATE,
RG_REPORT_CALCULATIONS.CREATED_BY,
ROWNUM ROW_NUM,
RG_REPORT_CALCULATIONS.AXIS_SET_ID,
RG_REPORT_CALCULATIONS.AXIS_SEQ,
LEVEL LEVEL_NUM,
RG_REPORT_CALCULATIONS.AXIS_SEQ_LOW,
RG_REPORT_CALCULATIONS.AXIS_SEQ_HIGH,
RG_REPORT_AXIS_SETS.STRUCTURE_ID CHART_OF_ACCOUNTS
FROM
RG_REPORT_CALCULATIONS,
RG_REPORT_AXIS_SETS
WHERE RG_REPORT_CALCULATIONS.APPLICATION_ID='101' AND
RG_REPORT_AXIS_SETS.AXIS_SET_ID = RG_REPORT_CALCULATIONS.AXIS_SET_ID
CONNECT BY NOCYCLE PRIOR RG_REPORT_CALCULATIONS.AXIS_SET_ID = RG_REPORT_CALCULATIONS.AXIS_SET_ID
AND PRIOR RG_REPORT_CALCULATIONS.AXIS_SEQ BETWEEN RG_REPORT_CALCULATIONS.AXIS_SEQ_LOW AND RG_REPORT_CALCULATIONS.AXIS_SEQ_HIGH
AND (RG_REPORT_CALCULATIONS.AXIS_SEQ<>RG_REPORT_CALCULATIONS.AXIS_SEQ_LOW OR RG_REPORT_CALCULATIONS.AXIS_SEQ<>RG_REPORT_CALCULATIONS.AXIS_SEQ_HIGH)
I also try the statement against the OLTP database, get the same error.
Can anyone help me out?
Thanks in advance,
Roger