My Oracle Support Banner

EAP: Payment Post Abends At Step AP_PSTPYMNT.BH100.BH100-13 When Escheated Payment Business Unit Has Ledger Group With Multiple Ledgers (Doc ID 2621282.1)

Last updated on DECEMBER 17, 2019

Applies to:

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

Symptoms

Some old System Checks that were paid a long time ago, but have not been cashed by the Suppliers, have been escheated by the functional team, to later on run Payment Post to generate the needed Escheatment Accounting Entries. It has been this Post Payments process (AP_PSTPYMNT AE Program) that has abended with a unique constrain violation on delivered Record PS_VCHR_TEMP_LN.

The issue is replicable under the below conditions:

    a.- At the Ledgers For A Unit, on the General Ledger Business Unit involved, and default Journal Generator Ledger, the 'Enable Separate Debit/Credit' flag is NOT selected
    b.- The Supplier whose System Check is being escheated is a Single Payment Supplier
    c.- There are no Federal Payments involved in the affected transaction
    d.- There are no Withholding Suppliers involved in the affected transaction
    e.- The Ledger Group being used as default for Journal Generator has multiple Ledgers listed within

The Post Payment process (AP_PSTPYMNT AE Program) has abended, leaving locked, and un-processed, many Voucher Payments that were escheated. Since then, no new Payment Post run has been launched, and this is affecting the processing of transactions.

The Post Payment process (AP_PSTPYMNT AE Program) should be able to handle all possible scenarios, and generate the Escheatment Accounting Entries needed for the Payments involved, and their respective Vouchers.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as a Payables User
    2.- Create a new Voucher for the Single Payment Supplier, and save the changes
    3.- Run Voucher Post for this new Voucher
    4.- Run Pay Cycle to completion, to generate the needed Payment
    5.- Launch Payment Posting for the newly generated Payment
    6.- Create a new Bank Statement to keep track of the payment created
    7.- At the Semi-Manual Bank Reconciliation page, reconcile the Bank Statement against the Payables Payment created
    8.- Launch the Cash Clearing process for the Bank Account used
    9.- Go to the Escheat Payment page, open the Payment transaction in question, select the Escheated Check radio button, and save the changes
    10.- Launch Payment Post for the escheated Payment ID
    11.- Confirm that the AP_PSTPYMNT AE Program has abended in No Success

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

    " -- 18:06:59.494 ..(AP_PSTPYMNT.BH100.BH100-13) (SQL)
      INSERT INTO PS_VCHR_TEMP_LN4 (PROCESS_INSTANCE, BUSINESS_UNIT, VOUCHER_ID, UNPOST_SEQ, APPL_JRNL_ID, POSTING_PROCESS, PYMNT_CNT, VOUCHER_LINE_NUM, DISTRIB_LINE_NUM, DST_ACCT_TYPE, CF_BAL_LINE_NUM, TAX_AUTHORITY_CD, LEDGER, LEDGER_GROUP, PRIMARY_LEDGER, DOC_TYPE, DOC_SEQ_DATE, DOC_SEQ_NBR, DOC_SEQ_STATUS, POST_STATUS_AP, CALC_DT , FOREIGN_AMOUNT, FOREIGN_CURRENCY, MONETARY_AMOUNT, MERCHANDISE_AMT, DSCNT_AMT, USETAX_AMT, SALETX_AMT, FREIGHT_AMT, CSD_NRCVRY_AMT, CSD_RCVRY_AMT, EXD_NRCVRY_AMT, EXD_RCVRY_AMT, MISC_AMT, STX_NRCVRY_AMT, STX_RCVRY_AMT, CURRENCY_CD, MERCH_AMT_BSE, DSCNT_AMT_BSE, USETAX_AMT_BSE, SALETX_AMT_BSE, FREIGHT_AMT_BSE, CSD_NRCVRY_AMT_BSE, CSD_RCVRY_AMT_BSE, EXD_NRCVRY_AMT_BSE, EXD_RCVRY_AMT_BSE, MISC_AMT_BSE, STX_NRCVRY_AMT_BSE, STX_RCVRY_AMT_BSE, FREIGHT_AMT_NP, FREIGHT_AMT_NP_BSE, MISC_AMT_NP, MISC_AMT_NP_BSE, SALETX_AMT_NP, SALETX_AMT_NP_BSE, USETAX_AMT_NP, USETAX_AMT_NP_BSE, RT_TYPE, RATE_MULT, RATE_DIV, BCM_POST_AMOUNT, BCM_POST_AMT_TOT , STATISTICS_CODE, QTY_VCHR, STATISTIC_AMOUNT, DESCR, CHART_EDIT_STATUS, ACCOUNTING_DT, JRNL_LN_REF, OPEN_ITEM_KEY, BUSINESS_UNIT_GL, GL_DISTRIB_STATUS, FINAL_REF_IND, REFERENCE_NUMBER, REF_CLOSED, REF_DIST_LINE, REF_LINE_NUMBER, BUSINESS_UNIT_PO, PO_ID, LINE_NBR, SCHED_NBR, PO_DIST_LINE_NUM, BCM_LINE_STATUS, BUSINESS_UNIT_PC, ACTIVITY_ID, ANALYSIS_TYPE, RESOURCE_TYPE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, PC_DISTRIB_STATUS, ASSET_FLG, BUSINESS_UNIT_AM, ASSET_ID, PROFILE_ID, AM_DISTRIB_STATUS, BUSINESS_UNIT_RECV, RECEIVER_ID, RECV_LN_NBR, RECV_SHIP_SEQ_NBR, RECV_DIST_LINE_NUM, MOVEMENT_FLAG, SHIPTO_ID, SUT_BASE_ID, TAX_CD_SUT, TAX_CD_SUT_PCT, SUT_APPLICABILITY, IST_DISTRIB_STATUS, BUDGET_HDR_STATUS, BUDGET_LINE_STATUS, CLOSE_STATUS, COST_TYPE, BUDGET_DT, IU_ANCHOR_FLG, IU_SYS_TRAN_CD, IU_TRAN_CD, AP_IU_ERROR_FLG, ENTRY_EVENT, EE_PROC_STATUS , VAT_APPLICABILITY , VAT_DISTRIB_STATUS , VAT_TXN_TYPE_CD , VAT_RECOVERY_PCT , VAT_DCLRTN_DT , VAT_REBATE_PCT , VAT_BASIS_AMT , VAT_BASIS_AMT_BSE , VAT_CALC_AMT , VAT_CALC_AMT_BSE , VAT_INV_AMT , VAT_INV_AMT_BSE , VAT_NONINV_AMT , VAT_NONINV_AMT_BSE , VAT_RCVRY_AMT , VAT_RCVRY_AMT_BSE , VAT_DSCNT_ADJ , VAT_DSCNT_ADJ_BSE , VAT_DSCNT_RCVRY , VAT_DSCNT_RCVR_BSE , VAT_REBATE_AMT , VAT_REBATE_AMT_BSE , TAX_CD_VAT , TAX_CD_VAT_PCT , VAT_USE_ID , VAT_ENTITY , VAT_TRANS_AMT , VAT_TRANS_AMT_BSE , VAT_TRANS_AMT_RPTG , VAT_INV_AMT_RPTG , CURRENCY_RPTG , PHYSICAL_NATURE , COUNTRY_VAT_SUPPLY , VAT_SVC_SUPPLY_FLG , VAT_SERVICE_TYPE , COUNTRY_VAT_PERFRM , STATE_VAT_DEFAULT , VAT_TREATMENT , ACCOUNT , ALTACCT , DEPTID , OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3 , PROJECT_ID , MONETARY_AMOUNT_02 , FOREIGN_AMOUNT2 , KK_PROCESS_PRIOR) SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.VOUCHER_ID , 0 , C.APPL_JRNL_ID_VOID , 'CANC' , A.PYMNT_CNT , B.VOUCHER_LINE_NUM , B.DISTRIB_LINE_NUM , 'ESCH' , B.CF_BAL_LINE_NUM , ' ' , G.LEDGER , G.LEDGER_GROUP , G.PRIMARY_LEDGER , ' ' , A.ACCOUNTING_DT , ' ' , ' ' , A.POST_STATUS_AP , A.PYMNT_DT , B.FOREIGN_AMOUNT , B.FOREIGN_CURRENCY , B.MONETARY_AMOUNT , B.MERCHANDISE_AMT , B.DSCNT_AMT , B.USETAX_AMT , B.SALETX_AMT , B.FREIGHT_AMT , B.CSD_NRCVRY_AMT , B.CSD_RCVRY_AMT , B.EXD_NRCVRY_AMT , B.EXD_RCVRY_AMT , B.MISC_AMT , B.STX_NRCVRY_AMT , B.STX_RCVRY_AMT , B.CURRENCY_CD , B.MERCH_AMT_BSE , B.DSCNT_AMT_BSE , B.USETAX_AMT_BSE , B.SALETX_AMT_BSE , B.FREIGHT_AMT_BSE , B.CSD_NRCVRY_AMT_BSE , B.CSD_RCVRY_AMT_BSE , B.EXD_NRCVRY_AMT_BSE , B.EXD_RCVRY_AMT_BSE , B.MISC_AMT_BSE , B.STX_NRCVRY_AMT_BSE , B.STX_RCVRY_AMT_BSE , B.FREIGHT_AMT_NP , B.FREIGHT_AMT_NP_BSE , B.MISC_AMT_NP , B.MISC_AMT_NP_BSE , B.SALETX_AMT_NP , B.SALETX_AMT_NP_BSE , B.USETAX_AMT_NP , B.USETAX_AMT_NP_BSE , B.RT_TYPE , B.RATE_MULT , B.RATE_DIV , B.BCM_POST_AMOUNT , B.BCM_POST_AMT_TOT , B.STATISTICS_CODE , B.QTY_VCHR , B.STATISTIC_AMOUNT , 'Escheatment Liability' , B.CHART_EDIT_STATUS , A.CANCEL_DT , B.JRNL_LN_REF , B.OPEN_ITEM_KEY , A.BUSINESS_UNIT_GL ,'N' , B.FINAL_REF_IND , B.REFERENCE_NUMBER , B.REF_CLOSED , B.REF_DIST_LINE , B.REF_LINE_NUMBER , B.BUSINESS_UNIT_PO , B.PO_ID , B.LINE_NBR , B.SCHED_NBR , B.PO_DIST_LINE_NUM , B.BCM_LINE_STATUS , B.BUSINESS_UNIT_PC , B.ACTIVITY_ID , B.ANALYSIS_TYPE , B.RESOURCE_TYPE , B.RESOURCE_CATEGORY , B.RESOURCE_SUB_CAT , B.PC_DISTRIB_STATUS , B.ASSET_FLG , B.BUSINESS_UNIT_AM , B.ASSET_ID , B.PROFILE_ID , B.AM_DISTRIB_STATUS , B.BUSINESS_UNIT_RECV , B.RECEIVER_ID , B.RECV_LN_NBR , B.RECV_SHIP_SEQ_NBR , B.RECV_DIST_LINE_NUM , 'N' , B.SHIPTO_ID , B.SUT_BASE_ID , B.TAX_CD_SUT , B.TAX_CD_SUT_PCT , B.SUT_APPLICABILITY , B.IST_DISTRIB_STATUS , B.BUDGET_HDR_STATUS , B.BUDGET_LINE_STATUS , B.CLOSE_STATUS , B.COST_TYPE , B.BUDGET_DT , 'Y' , B.IU_SYS_TRAN_CD , B.IU_TRAN_CD , 'N' , B.ENTRY_EVENT , 'N' , B.VAT_APPLICABILITY , B.VAT_DISTRIB_STATUS , B.VAT_TXN_TYPE_CD , B.VAT_RECOVERY_PCT , A.CANCEL_DT , B.VAT_REBATE_PCT , B.VAT_BASIS_AMT , B.VAT_BASIS_AMT_BSE , B.VAT_CALC_AMT , B.VAT_CALC_AMT_BSE , B.VAT_INV_AMT , B.VAT_INV_AMT_BSE , B.VAT_NONINV_AMT , B.VAT_NONINV_AMT_BSE , B.VAT_RCVRY_AMT , B.VAT_RCVRY_AMT_BSE , B.VAT_DSCNT_ADJ , B.VAT_DSCNT_ADJ_BSE , B.VAT_DSCNT_RCVRY , B.VAT_DSCNT_RCVR_BSE , B.VAT_REBATE_AMT , B.VAT_REBATE_AMT_BSE , B.TAX_CD_VAT , B.TAX_CD_VAT_PCT , B.VAT_USE_ID , B.VAT_ENTITY , B.VAT_TRANS_AMT , B.VAT_TRANS_AMT_BSE , B.VAT_TRANS_AMT_RPTG , B.VAT_INV_AMT_RPTG , B.CURRENCY_RPTG , B.PHYSICAL_NATURE , B.COUNTRY_VAT_SUPPLY , B.VAT_SVC_SUPPLY_FLG , B.VAT_SERVICE_TYPE , B.COUNTRY_VAT_PERFRM , B.STATE_VAT_DEFAULT , B.VAT_TREATMENT , X.ACCOUNT , X.ALTACCT , X.DEPTID , X.OPERATING_UNIT, X.PRODUCT, X.FUND_CODE, X.CLASS_FLD, X.PROGRAM_CODE, X.BUDGET_REF, X.AFFILIATE, X.AFFILIATE_INTRA1, X.AFFILIATE_INTRA2, X.CHARTFIELD1, X.CHARTFIELD2, X.CHARTFIELD3 , X.PROJECT_ID , 0 , 0 , B.KK_PROCESS_PRIOR FROM PS_PST_PYMT_TAO4 A , PS_VCHR_ACCTG_LINE B , PS_PST_APES_TMP4 X , PS_BUS_UNIT_INTFC C , PS_BU_LED_GRP_TBL H , PS_BU_LED_AP_VW G WHERE A.PROCESS_INSTANCE = 197729 AND A.CANCEL_POST_STATUS = 'W' AND A.PYMNT_STATUS = 'W' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.PYMNT_CNT = B.PYMNT_CNT AND B.UNPOST_SEQ = 0 AND B.DST_ACCT_TYPE IN ('CAS', 'CAC')  AND B.POSTING_PROCESS IN('PYMN', 'DFTA', 'WTHA')  AND B.POSTING_PROCESS <> 'ACAV' AND X.PROCESS_INSTANCE = 197729 AND X.BUSINESS_UNIT = B.BUSINESS_UNIT AND X.VOUCHER_ID = B.VOUCHER_ID AND X.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM AND X.DISTRIB_LINE_NUM = B.DISTRIB_LINE_NUM AND A.BUSINESS_UNIT_GL = C.BUSINESS_UNIT AND A.BUSINESS_UNIT_GL = G.BUSINESS_UNIT AND A.BUSINESS_UNIT_GL = H.BUSINESS_UNIT AND G.LEDGER_GROUP = H.LEDGER_GROUP AND H.SEPARATE_DRCR = 'N'
      /
      -- Row(s) affected: 0
      -- 18:06:59.634 Process 197729 ABENDED at Step AP_PSTPYMNT.BH100.BH100-13 (Action SQL) -- RC = 805
      ROLLBACK
      /
      -- 18:06:59.649 SQL Error: ORA-00001: unique constraint (EMDBO.PS_VCHR_TEMP_LN4) violated "

 

 

NOTE: In the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.