EAP: Matching Abends At Step AP_MATCH.HDRSUM.STEP04 (SQL) -- RC = 805 (108,524) (Doc ID 2554933.1)

Last updated on MARCH 20, 2025

Applies to:

Symptoms

Matching process abends after 9.2 PUM 31

ERROR:
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_AP_MTVPORCV_T17) violated
Failed SQL stmt: INSERT INTO PS_AP_MTVPORCV_T17 (PROCESS_INSTANCE, BUSINESS_UNIT, VOUCHER_ID, BUSINESS_UNIT_PO, PO_ID, LINE_NBR, SCHED_NBR, BUSINESS_UNIT_RECV, RECEIVER_ID, RECV_LN_NBR, RECV_SHIP_SEQ_NBR, MERCH_AMT_PO, MERCH_AMT_RECV) SELECT DISTINCT PROCESS_INSTANCE, BUSINESS_UNIT, VOUCHER_ID, BUSINESS_UNIT_PO, PO_ID, LINE_NBR, SCHED_NBR, BUSINESS_UNIT_RECV, RECEIVER_ID, RECV_LN_NBR, RECV_SHIP_SEQ_NBR, MERCH_AMT_PO, MERCH_AMT_RECV FROM PS_AP_VCHRLSUM_T17 WHERE PROCESS_INSTANCE = 1856624
Process 1856624 ABENDED at Step AP_MATCH.HdrSum.Step04 (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS:
1. Add two Line Express PO > Matching and Receiving Required > both PO Lines for the Same Item ID, Quantity, Price
    a. Item LT3007
    b. Qty = 2080 GAL
    c. Price = 21.25/GAL
2. Dispatch PO
3. Add first Receipt from PO Line 2 > change Receipt Qty from 2080 to 11 > Save
4. Add second Receipt for both Lines of PO > Line 1 Qty = 78 > Line 2 Qty = 72
5. Voucher Line 1 > Worksheet Copy from Purchase Order Only
    a. Select to copy in PO line 2
    b. Change Quantity Vouchered from 2080 to 20
    c. Click Copy Selected Lines
    d. Voucher Line 1 added
6. Voucher Line 2 > Worksheet Copy from Purchase Order Only
    a. Select to copy in PO line 2
    b. Change Quantity Vouchered from 2080 to 11
    c. Click Copy Selected Lines
    d. Voucher Line 2 added
    e. Adjust Voucher Total accordingly
    f. Save
7. Delivered Document Association Rules not modified
8. Run Matching > process ends in No Success > Step AP_MATCH.HdrSum.Step04 (SQL) -- RC = 805

Cause

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