Peoplesoft Accounts payables Matching batch process-AP_MATCH fails due to unique constraint error
Hi All,
AP_MATCH Process fails due to unique constraint error as below.
Number of voucher lines that have manually associated receipts - 94 (7500,400)
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_AP_MTVLN9_T4) violated
Failed SQL stmt: INSERT INTO PS_AP_MTVLN9_T4 (PROCESS_INSTANCE, BUSINESS_UNIT, VOUCHER_ID, VOUCHER_LINE_NUM, BUSINESS_UNIT_PO, PO_ID, LINE_NBR, SCHED_NBR, BUSINESS_UNIT_RECV, RECEIVER_ID, RECV_LN_NBR, RECV_SHIP_SEQ_NBR, AMT_ONLY_FLG, QTY_VCHR_CNVT, QTY_VCHR_CNVTR, QTY_ENTERED, MERCH_AMT_VCHR, ASSTN_NAME, MERCH_AMT_VCHR_B, MERCH_AMT_VCHRR_B) SELECT A.PROCESS_INSTANCE, A.BUSINESS_UNIT, A.VOUCHER_ID, A.VOUCHER_LINE_NUM, A.BUSINESS_UNIT_PO, A.PO_ID, A.LINE_NBR, A.SCHED_NBR, A.BUSINESS_UNIT_RECV, A.RECEIVER_ID, A.RECV_LN_NBR, A.RECV_SHIP_SEQ_NBR, A.AMT_ONLY_FLG, A.QTY_VCHR_CNVT, A.QTY_VCHR_CNVTR, B.QTY_ENTERED, A.MERCH_AMT_VCHR, A.ASSTN_NAME, A.MERCH_AMT_VCHR_B, A.MERCH_AMT_VCHRR_B FROM PS_AP_MTVLN1_T4 A, PS_AP_MTVPSUM_T4 B WHERE A.PROCESS_INSTANCE = 2633226 AND A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM