Hi,
After 11gR2 upgrade we got error in insert statement.
INSERT INTO SDE_TBL_FLEXTRIMSITROUT
(BRANCHCD,
SOURCECD,
CURRENTNO,
BATCHNO,
DEPTCD,
CCY,
INITIATIONDATE,
AMOUNT,
ACCOUNT,
ACCOUNTBRANCH,
TXNCD,
DEBITCREDIT,
LCYEQUIVALENT,
EXCHRATE,
VALUEDATE,
INSTRUMENTNO,
RELCUST,
ADDLTEXT,
TXNMIS1,
TXNMIS2,
TXNMIS3,
TXNMIS4,
TXNMIS5,
TXNMIS6,
TXNMIS7,
TXNMIS8,
TXNMIS9,
TXNMIS10,
COMPMIS1,
COMPMIS2,
COMPMIS3,
COMPMIS4,
COMPMIS5,
COMPMIS6,
COMPMIS7,
COMPMIS8,
COMPMIS9,
COMPMIS10,
COSTCODE1,
COSTCODE2,
COSTCODE3,
COSTCODE4,
COSTCODE5,
RELATEDACCOUNT,
RELATEDREF,
USERREFERENCE,
ACCTPOSTOVERWRITE,
EXCHRATEOVERWRITE,
VALUEDATEOVERWRITE,
ACCTBALOVERWRITE,
ITRREFER,
RefinanceAmount,
PROCESSID)
VALUES
(vBranchCode,
cCreateNewTrimsITR_rec.APPLSYS,
ROWNUM,
nBatchNo,
cCreateNewTrimsITR_rec.DEPT,
vCcy,
TO_DATE(cCreateNewTrimsITR_rec.TRANSDATE, 'YYYYMMDD'),
nAmount,
vAccount,
vAccountBranch, --added by subhashish
vTxnCd,
cDebitCredit,
nLcyEquivalent,
nExchRate,
TO_DATE(cCreateNewTrimsITR_rec.VALUEDATE, 'YYYYMMDD'),
vInstrumentNo,
--' ' || SUBSTR(cCreateNewTrimsITR_rec.ITRREFER,2,11),
vFlxCntry || cCreateNewTrimsITR_rec.APNO,
vDesc,
cCreateNewTrimsITR_rec.TRANSOUC,
RPAD(' ', 9),
vExpenseMIS,
vProductMIS,
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 9),
RPAD(' ', 20),
cCreateNewTrimsITR_rec.THEIRREF,
RPAD(' ', 16),
cActPostOverwrite,
cExchRateOverWrite,
cValueDateOverWrite,
cAcctBalOverWrite,
cCreateNewTrimsITR_rec.ITRREFER,
cCreateNewTrimsITR_rec.REFIAMOUNT,
nFlexOutProcessId);
Error : ORA-00976: Specified pseudocolumn or operator not allowed here
As per checking, found there is an issue in 11gR2 with insert query using rownum in values.
Do anyone know how to solve this issue ?