ECM: PMT_DISP_PRL Process For Payment Dispatch Abends at Step PMT_DISPATCH.FRMT200.Step04 (Do Select) (Doc ID 2816022.1)

Last updated on SEPTEMBER 04, 2024

Applies to:

Symptoms

The PMT_DISP_PRL process intermittently runs to No Success. Process abends at Step PMT_DISPATCH.FRMT200.Step04 with an error when trying to dispatch a Bank Transfer or EFT Request, and the "Dispatch on Load" box is checked on the Financial Gateway > Administration > Source Registration for Source System = CM.

ERROR
------------
Process 1950097 ABENDED at Step PMT_DISPATCH.FRMT200.Step04 (Do Select) -- RC = 936: Missing Expression Failed

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 509 Return: 9 36 - ORA-00936: missing expression Failed SQL stmt: SELECT A.PMT_ID ,A.PMT_FILE_ID ,A.BUSINESS_UNIT ,B.SETID ,D.BRANCH_NAME ,A.BANK_SET ID ,A.BANK_CD ,A.BANK_ACCT_KEY ,A.AMOUNT_CURRENCY_CD ,A.FORMAT_ID ,A.DFI_ID_NUM ,A.IBAN_ID , A.PMT_S OURCE FROM PS_PMT_STL_F_TAO23 A ,PS_SET_CNTRL_REC B ,PS_BANK_ACCT_DEFN D WHERE A.PMT_FILE_ID = :1 AN D B.SETCNTRLVALUE=A.BUSINESS_UNIT AND B.RECNAME='LOCATION_TBL' AND A.PROCESS_INSTANCE = 1950097 AND D.SETID = A.BANK_SETID AND D.BANK_CD = A.BANK_CD AND D.BANK_CD_CPTY = A.BANK_CD AND D.BANK_ACCT_KEY= A.BANK_ACCT_KEY ORDER B

STEPS
----------
1. Financial Gateway Source Registration > System Source = CM > box checked for ‘Dispatch on Load’
2. Process Scheduler Servers > PSUNX > Application Engine Max Concurrent = 3
3. PMT_DISP_PRL Process > Priority = High
4. Treasury Installation Options > Time Out Max Minutes = 1
5. USBNK / CHCK > Payment Method Wire Transfer > Settle By Financial Gateway > Layout = ISO_CT_03
6. TRBNK / CHCK > Payment Method Wire Transfer > Settle By Financial Gateway > Layout = ISO_CT_03
7. Add Bank Account Transfer > BU = US001 > From = USBNK / CHCK > To = TRBNK / CHCK
8. Add second Bank Account Transfer > BU = US001 > From = TRBNK / CHCK > To = USBNK / CHCK
9. Select Settlements > select both payments at the same time
10. Make sure there are jobs currently processing in the Process Monitor before Approve Settlements
11. ARUPDATE and and BNRCNBSP currently Processing
12. Approve Settlements
13. ARUPDATE, BNRCNBSP and PMT_DISPATCH now Processing
14. PMT_DISPATCH is Success
15. First PMT_DISP_PRL goes from Queued to Success
16. Second PMT_DISP_PRL goes from Queued to No Success
17. Message Log: File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1811 Error Position: 507 Return: 9 36 - ORA-00936: missing expression Failed SQL stmt
  Process abends at Step PMT_DISPATCH.FRMT200.Step04 ORA-00936: missing expression Failed SQL stmt

Changes

Cause

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