My Oracle Support Banner

EAP: AP_APY2015 (Payment Process) Failing With DB2 Error (Doc ID 2698919.1)

Last updated on AUGUST 07, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

AP_APY2015 (Payment Process) Failing with DB2 Error after applying bug fix 30947700 (DB2OS390: AP_APY2015 PROCESS IS ABENDED AT STEP AP_PAYIMAGE.GET_MANY.STEP09 (SQL)

ERROR
-----------------------

File: e:\pt85517b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8669 - [CLI Driver][DB2] SQL0418N The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker, the DEFAULT keyword, or a null value. SQLSTATE=42610

 (SQLSTATE 42610) -418
Failed SQL stmt: INSERT INTO PS_PAY_IMAGE_DTL4 (PAY_CYCLE , PAY_CYCLE_SEQ_NUM , PYMNT_IMAGE_ID , SOURCE_TXN , BUSINESS_UNIT , PAY_DOC_ID , PAY_DOC_SEQ , PYCYCL_KEY_FIELD1 , PYCYCL_KEY_FIELD2 , PYCYCL_KEY_FIELD3 , PAID_AMT_GROSS , PAID_AMT_DSCNT , PAID_AMT , LATE_CHRG_PAID , SBI_FLG , PREPAY_FLAG , MSG_SEQ_FLG , MESSAGE_ISSUED , PROCESS_INSTANCE) SELECT PAY_CYCLE , PAY_CYCLE_SEQ_NUM , :1 , SOURCE_TXN , BUSINESS_UNIT , PAY_DOC_ID , PAY_DOC_SEQ , PYCYCL_KEY_FIELD1 , PYCYCL_KEY_FIELD2 , PYCYCL_KEY_FIELD3 , PAID_AMT_GROSS , PAID_AMT_DSCNT , PAID_AMT , LATE_CHRG_PAID , 'N' , 'N' , 'N' , 'N' , PROCESS_INSTANCE FROM PS_PYCYCL1_TMP4 WHERE PAY_CYCLE='XPC006' AND PAY_CYCLE_SEQ_NUM=2

Process 414991 ABENDED at Step AP_PAYIMAGE.GET_MANY.Step09 (SQL) -- RC = 8669 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
2020-07-09-13.51.56.448430 DoMessageLogError 

Changes

 

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
Changes
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.