My Oracle Support Banner

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:

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


Matching Process (AP_MATCH) failing with below error:


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


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:
      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.


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

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