EAP: Matching Process is Failing With Error "ORA-00001: unique constraint" at Step "AP_MTCH_FUME POLnMtch Step03", When Trying to Adjust Zero Amount Line. (Doc ID 2968202.1)

Last updated on AUGUST 21, 2023

Applies to:

Symptoms

Matching Process (AP_MATCH) failing with below error:

Error:

ORA-00001: unique constraint (SYSADM.PS_PO_LINE_MATCHED) violated Failed SQL
stmt: INSERT INTO PS_PO_LINE_MATCHED
............................
............................
Process xxxxx ABENDED at Step AP_MTCH_FUME.POLnMtch.Step03 (SQL) -- RC = 805
xxxx AP_MTCH_FUME POLnMtch Step03 SQL 805

Steps:

1. Go to Purchasing > Purchase Orders > Add/Update POs , and Create and process PO until Dispatch. (PO should not be amount Only)
2. Go to Purchasing > Receipts > Add/Update Receipts and Associate PO to Receipt and set to Fully Received
3. Go to Accounts Payable > Vouchers > Add/Update > Regular Entry and create a Regular Voucher by copying the PO Receipt using Copy from PO Receipt (copy first line).
4. Add an extra voucher line with 0 amount , save the voucher.
5. On invoice Infromation Page Select the process from the Action dropdown and run them in below order:
      Matching
      Post Voucher
6. Go to Accounts Payable > Vouchers > Add/Update > Regular Entry and create an Adjustment by copying first line of of Regular Voucher (created in Step 5).
7. After copying, Do not reverse the amount, just increase it positively and select Matching from Action Dropdown and run the process. Override Match exceptions (if any).
8. Go back to Invoice Information Tab, copy the second line of Regular Voucher using Copy from Worksheet option.
9. Save the voucher.
9. Adjust the amount positively on second line and run the matching process using FS_STREAMLN (action drop-down).
10. Check Matching process Status in Process monitor (Navigation: PeopleTools > Process Scheduler > Process Monitor)

See Replication Steps document for more details.

Cause

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