EAP: Payment Posting abended at Step AP_PSTPYMNT.B0000.B000049 (PeopleCode) after applying FMS FINANCIALS 9.1 BUNDLE #25

(Doc ID 1559886.1)

Last updated on MARCH 18, 2016

Applies to:

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

Symptoms

After applying FMS FINANCIALS 9.1 BUNDLE #25, Payment Posting is abending at Step AP_PSTPYMNT.B0000.B000049 with an error.

ERROR
SQL error. Function:  SQLExec
  Error Position:  781
  Return:  907 - ORA-00907: missing right parenthesis

  Statement:  delete from ps_pst_bal1_tmp7 where ps_pst_bal1_tmp7.process_instance = :1 and ps_pst_bal1_tmp7.business_unit = :2 and ps_pst_bal1_tmp7.ledger_group = :3 and exists (select count(*) from ps_pst_bal_tmp7 a  where a.process_instance = ps_pst_bal1_tmp7.process_instance and a.business_unit = ps_pst_bal1_tmp7.business_unit and a.voucher_id = ps_pst_bal1_tmp7.voucher_id and a.posting_process = ps_pst_bal1_tmp7.posting_process and a.appl_jrnl_id = ps_pst_bal1_tmp7.appl_jrnl_id and a.voucher_line_num = ps_pst_bal1_tmp7.voucher_line_num and a.distrib_line_num = ps_pst_bal1_tmp7.distrib_line_num and a.ledger_group = ps_pst_bal1_tmp7.ledger_group and a.ledger = ps_pst_bal1_tmp7.ledger and a.pymnt_cnt = ps_pst_bal1_tmp7.pymnt_cnt and a.primary_ledger = ps_pst_bal1_tmp7.primary_ledger  WHERE A.PROCESS_INSTANCE = PS_PST_BAL1_TMP7.PROCESS_INSTANCE AND A.BUSINESS_UNIT = PS_PST_BAL1_TMP7.BUSINESS_UNIT AND A.VOUCHER_ID = PS_PST_BAL1_TMP7.VOUCHER_ID AND A.POSTING_PROCESS = PS_PST_BAL1_TMP7.POSTING_PROCESS AND A.APPL_JRNL_ID = PS_PST_BAL1_TMP7.APPL_JRNL_ID AND A.VOUCHER_LINE_NUM = PS_PST_BAL1_TMP7.VOUCHER_LINE_NUM AND A.DISTRIB_LINE_NUM = PS_PST_BAL1_TMP7.DISTRIB_LINE_NUM AND A.LEDGER_GROUP = PS_PST_BAL1_TMP7.LEDGER_GROUP AND A.LEDGER = PS_PST_BAL1_TMP7.LEDGER AND A.PYMNT_CNT = PS_PST_BAL1_TMP7.PYMNT_CNT AND A.PRIMARY_LEDGER = PS_PST_BAL1_TMP7.PRIMARY_LEDGER  AND A.DEPTID = PS_PST_BAL1_TMP7.DEPTID GROUP BY A.PROCESS_INSTANCE, A.BUSINESS_UNIT, A.VOUCHER_ID, A.POSTING_PROCESS, A.APPL_JRNL_ID, A.VOUCHER_LINE_NUM, A.DISTRIB_LINE_NUM, A.LEDGER_GROUP, A.LEDGER, A.PYMNT_CNT, A.PRIMARY_LEDGER , A.FUND_CODE, A.DEPTID HAVING COUNT(*) > 1)
  Original Statement:  DELETE FROM %Table(PST_BAL1_TMP) WHERE %Table(PST_BAL1_TMP).PROCESS_INSTANCE = :1 AND %Table(PST_BAL1_TMP).BUSINESS_UNIT = :2 AND %Table(PST_BAL1_TMP).LEDGER_GROUP = :3 AND EXISTS (SELECT COUNT(*) FROM %Table(PST_BAL_TM
108,524

AP_PSTPYMNT ABENDED at Step AP_PSTPYMNT.B0000.B000049 (PeopleCode)

OR

Process 1043086 ABENDED at Step AP_PSTPYMNT.B0000.B000049 (Action PeopleCode) -- RC = 24
ROLLBACK

Error: Function: SQLExec Error Position: 0 Return: 0 - [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "WHERE" was found followin g "_TMP4.PRIMARY_LEDGER".
ErrorReturn-> 277 - SQL Error in Compile. (2,277) AEREQUEST_WRK.CF_BAL_LINE_NUM.FieldFormula  Name:populate_Pstbaltmp_Det_BeforeIU  PCPC:34543  Statement:313
Called from:AP_PSTPYMNT.B0000.GBL.default.1900-01-01.B000049.OnExecute  Statement:3

STEPS FOR 1ST ERROR
1.  Installation Options setup -- Posing Method = Detailed Offset Method
2.  Ledger Group setup -- Add Dept as a Balancing segment
3.  Create a Voucher for AP BU = US003 paid by a Bank Account with GL BU = US001
4.  Create a Voucher for AP BU = US001 pad by the same Bank Account in Step 3
5.  Pay both Voucher using Pay Cycle Manager
6.  Run Payment Posting -- specifying multiple Business Units or Payments for Vouchers belonging to different BU's
7.  Payment Posting will abend with the above error

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms