My Oracle Support Banner

ERE: SQL ERROR IN RE_GENTRANS.INSTRANS.STEP05 BecauseE END CASE ON MSSQL (Doc ID 2504854.1)

Last updated on JANUARY 13, 2020

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Install/Upgrade

ACTUAL BEHAVIOR
---------------
SQL Error in RE_GENTRANS.INSTRANS.Step05

The SQL has an "END CASE" which causes an error on MSSQL databases.
%InsertSelect(RE_GENDTL_TAO , RE_GENTXN_TAO T, RE_CHG_ITEM R, RE_LSA_OPEX_CTG O,TXN_GRP = T.TXN_GRP, TXN_ITEM = '09', BUSINESS_UNIT = T.BUSINESS_UNIT, LS_TXN_DTL_SEQ = O.TERM_OPEX_ID, AMOUNT = CASE WHEN T.SCHED_TYPE = 'R' THEN -1 * %Roundcurrency(%DecMult(O.EST_AMT, T.PRORATION_RATE),T.CURRENCY_CD) ELSE %Roundcurrency(%DecMult(O.EST_AMT, T.PRORATION_RATE),T.CURRENCY_CD) END CASE, CHG_GRP_CD= O.CHG_GRP_CD)
  FROM %Table(RE_GENTXN_TAO) T, PS_RE_CHG_ITEM R ,PS_RE_LSA_OPEX_CTG O
 WHERE T.BUSINESS_UNIT = R.BUSINESS_UNIT
  AND T.TXN_GRP = R.TXN_GRP
  AND T.TXN_GRP = '4'
  AND R.TXN_ITEM = '09'
  AND T.LS_KEY = O.LS_KEY
  AND T.TERM_ID = O.TERM_ID
  AND T.AMND_NBR = O.AMND_NBR
  AND T.CAPITALIZE_SW = 'N'
  AND T.PROCESS_INSTANCE = %ProcessInstance


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.