Financial Management - PSFT (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center