My Oracle Support Banner

EAP - DB2 - PAYMENT POST ABEND AT STEP AP_PSTCOMMON.CF_INH2.STEP02 (Doc ID 2588192.1)

Last updated on JULY 22, 2020

Applies to:

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

Symptoms

DB2 version of SQL APEA_CSD_THD_INSERT_SQL contains incorrect SQL:

AND NOT XISTS(
SELECT 'X'
FROM %Table(VCHR_LN_GST) GST
WHERE GST.BUSINESS_UNIT = A.BUSINESS_UNIT
AND GST.VOUCHER_ID = A.VOUCHER_ID
AND GST.VOUCHER_LINE_NUM = A.VOUCHER_LINE_NUM
AND GST.REV_CHARGE_APPL = 'Y')

When Payment Post is run IN A DB2 environment the following abend occurs:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error
Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An
unexpected token "A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A." was found
following "AMT) SELECT DISTINCT". Expected tokens may include: "<space>".
SQLSTATE=42601
(SQLSTATE 42601) -104
Failed SQL stmt: INSERT INTO PS_PST_APEA2_TMP4 (PROCESS_INSTANCE ,
BUSINESS_UNIT , VOUCHER_ID , VOUCHER_LINE_NUM , DISTRIB_LINE_NUM ,
DST_ACCT_TYPE , BUSINESS_UNIT_GL , RT_TYPE , CURRENCY_CD , ACCOUNT , ALTACCT
, OPERATING_UNIT, DEPTID, PRODUCT, CLASS_FLD, CHARTFIELD2, CHARTFIELD3,
AFFILIATE, AFFILIATE_INTRA2, AFFILIATE_INTRA1, BUDGET_REF, CHARTFIELD1,
FUND_CODE, PROGRAM_CODE, PROJECT_ID , PYMNT_VCHR_PCT , CALC_DSC_TRMS_PCT ,
ENTRY_EVENT , EE_PROC_STATUS , MONETARY_AMOUNT , PAY_AMT) SELECT DISTINCT
A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM ,
A.DISTRIB_LINE_NUM , W.DST_ACCT_TYPE , A.BUSINESS_UNIT_GL , A.CUR_RT_TYPE ,
A.CURRENCY_CD , W.ACCOUNT , W.ALTACCT , A.OPERATING_UNIT, W.DEPTID,
W.PRODUCT, W.CLASS_FLD, W.CHARTFIELD2, W.CHARTFIELD3, W.AFFILIATE,
W.AFFILIATE_INTRA2, W.AFFILIATE_INTRA1, W.BUDGET_REF, W.CHARTFIELD1,
W.FUND_CODE, W.PROGRAM_CODE, W.PROJECT_ID , ROUND(((FLOAT (A.FOREIGN_AMOUNT +
A.DSCNT_AMT + A.MISC_AMT_NP + A.FREIGHT_AMT_NP + A.SALETX_AMT_NP -
A.USETAX_AMT + A.VAT_RCVRY_AMT + A.VAT_NR_AMT_NP - A.VAT_NONINV_AMT +
A.VAT_REBATE_AMT + A.EXD_RCVRY_AMT + A.STX_RCVRY_AMT + A.CSD_RCVRY_AMT )) / (
B.PAY_AMT)) ,15) , ROUND(((FLOAT ((A.DSCNT_AMT + A.DSCNT_AMT_NP) )) / (
B.DSCNT_AMT)) ,15) , A.ENTRY_EVENT , 'N' , A.FOREIGN_AMOUNT + A.DSCNT_AMT +
A.MISC_AMT_NP + A.FREIGHT_AMT_NP + A.SALETX_AMT_NP - A.USETAX_AMT +
A.VAT_RCVRY_AMT + A.VAT_NR_AMT_NP - A.VAT_NONINV_AMT + A.VAT_REBATE_AMT +
A.EXD_RCVRY_AMT + A.STX_RCVRY_AMT + A.CSD_RCVRY_AMT , B.PAY_AMT FROM
PS_DIST_LINE_TMP4 A , PS_PST_PYMT_TAO4 B , PS_SET_CNTRL_REC C ,
PS_SET_CNTRL_REC D , PS_DST_DETL_CNTRL W , PS_BUS_UNIT_TBL_GL X WHERE
A.PROCESS_INSTANCE = 2522326 AND A.BUSINESS_UNIT_GL = C.SETCNTRLVALUE AND
C.RECNAME = 'LED_DEFN_TBL' AND C.SETID = 'SHARE' AND A.PROCESS_INSTANCE =
B.PROCESS_INSTANCE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID =
B.VOUCHER_ID AND B.VOUCHER_STYLE = 'THRD' AND B.DST_CNTRL_ID = W.DST_CNTRL_ID
AND B.BUSINESS_UNIT = D.SETCNTRLVALUE AND 'DST_DETL_CNTRL' = D.RECNAME AND
D.SETID = W.SETID AND W.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_DST_CNTRL_TBL E
WHERE W.SETID = E.SETID AND B.DST_CNTRL_ID = E.DST_CNTRL_ID AND E.EFFDT <=
B.ACCOUNTING_DT AND E.EFF_STATUS = 'A') AND W.DST_ACCT_TYPE IN ('DSL', 'DSE',
'DSLM', 'DSEM') AND A.BUSINESS_UNIT_GL = X.BUSINESS_UNIT AND B.DSCNT_AMT <> 0
AND B.PAY_AMT <> 0 AND A.CSD_RCVRY_AMT <> 0 AND NOT XISTS( SELECT 'X' FROM
PS_VCHR_LN_GST GST WHERE GST.BUSINESS_UNIT = A.BUSINESS_UNIT AND
GST.VOUCHER_ID = A.VOUCHER_ID AND GST.VOUCHER_LINE_NUM = A.VOUCHER_LINE_NUM
AND GST.REV_CHARGE_APPL = 'Y')

Process 2522326 ABENDED at Step AP_PSTCOMMON.CF_INH2.Step02 (SQL) -- RC =
8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s



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.