My Oracle Support Banner

EAP : The FIN2025 Process Failed When Processing a Giro-EFT Payment With PPD Layout. Error:" ORA-00936: missing expression". (Doc ID 2966850.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

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

Symptoms

For an existing bank account, the Giro-EFT payment method is configured with a PPD layout.

When processing the FIN2025 for voucher vouchers with the Giro-EFT payment method( PPD layout) the process failed with the below error.

ERROR
-----------------------
(SQR 5528) ORACLE OCIStmtExecute error 936 in cursor 31:
  ORA-00936: missing expression
SQL: SELECT FILESEQ.SETID, FILESEQ.BNK_ID_NBR, FILESEQ.BANK_ACCOUNT_NUM,
  FILESEQ.DAILY_NUMBER, FILESEQ.CREATION_DT, SETCNTR2.SETID from
  FILESEQ, PS_SET_CNTRL_REC SETCNTR2 where SETCNTR2.SETCNTRLVALUE = :1 and
  SETCNTR2.RECNAME = 'EFT_FILESEQ_TBL' and and FILESEQ.SETID =
  SETCNTR2.SETID and FILESEQ.BNK_ID_NBR = :2 and FILESEQ.BANK_ACCOUNT_NUM
  = :3

Error on line 3685:
  (SQR 3722) Could not set up cursor.

SQR for PeopleSoft: Program Aborting.


Steps to replicate:
1. For an existing bank account configure the Giro-EFT payment method with a PPD layout.
     Banking > Bank Accounts > External.
2. Create a new voucher for the above bank account and with payment method Giro-EFT.
     Accounts Payable > Vouchers > Add/Update > Regular Entry.
3. Run the pay cycle process
4. Run the FIN2025, the above error occurs.

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.