EAP: AP_MTCH_EXCPTN Table Has Over 500 Lines That Have Voucher That Have Already Been Paid. (Doc ID 2963668.1)

Last updated on JULY 25, 2023

Applies to:

Symptoms

ISSUE:

AP_MTCH_EXCPTN table has over 500 lines that have vouchers that have already been paid.

If system is allowing to create and pay vouchers that are unmatched and copied from a closed PO then why is the AP_MTCH_EXCPTN table still has these vouchers.

As the table AP_MTCH_EXCPTN has data for these vouchers it shows on the Match Exception Collaboration page.


SETUP:


1. Set Up Financials/Supply Chain > Common Definitions > User Preferences > Define User Preferences - Search for the user and then click on the the Procurement link, then click on Payables Online Vouchering link and then in the Operator Voucher Authorities grid - Pay Unmatched Vouchers is checked with the amount specified.

2. Copy Matched and Closed PO is checked.

STEPS:

1. Set Up Financials/Supply Chain > Common Definitions > User Preferences > Define User Preferences - Search for the user and then click on the the Procurement link, then click on Payables Online Vouchering link and then in the Operator Voucher Authorities grid - Pay Unmatched Vouchers is checked with the amount specified.

2. Copy Closed PO is checked. (Copy Matched and Closed PO) 

Set Up Financials/Supply Chain > Common Definitions > User Preferences > Define User Preferences 

3. Create a PO for qty 1 amount 100 and dispatch it

Purchasing > Purchase Order > Add/Update Purchase Order

4. Create a receipt - copy the PO

Purchasing > Receipts > Add/Update Receipts

5. Close the PO via Purchasing Purchase Orders Buyer's Workbench (qualify and close the PO)

Purchasing > Purchase Orders > Buyer's Workbench

6. Create a voucher - make sure the PO BU and PO no on the add voucher page. DO NOT CHANGE ANYTHING ON THE VOUCHER

Accounts Payable >  Vouchers  > Add/Update  > Regular Entry

7. Save the voucher - ON SAVING THE VOUCHER RECEIVED THE BELOW MESSAGE

The PO distribution line referenced by this distribution line has been closed or cancelled. (7030,2000)

The Purchase Order distribution line referenced by this distribution line has been closed or canceled. Delete this Voucher line to proceed.

CUSTOMER IS NOT RECEIVING THE ABOVE ERRORS.

Bug 33922004 - AP: COPY VOUCHER PROCESS CREATES NEW VOUCHER WITH A CLOSED PO DISTRIBUTION LINE
Bug 34070879 - AP: ERROR MESSAGE FROM BUG 33922004 PROVIDES INVALID STEP TO CORRECT ERROR

Both the above bugs were fixed in image 44.

8. Run Matching

Accounts Payable > Batch Processes > Matching

9. Voucher will be in exception - rule S210

10.Then on the voucher attribute tab the use checks the checkbox for Pay UnMatched

Accounts Payable >  Vouchers  > Add/Update  > Regular Entry

11. Save the voucher

12. Run the paycycle and this voucher is picked for payment and it is paid

Accounts Payable > Payments > Paycycle Processing > Pay Selection Criteria

13. Open the voucher again and the match status of the voucher shows as exception.

Accounts Payable >  Vouchers  > Add/Update  > Regular Entry

14. Data is in AP_MTCH_EXCPTN for this voucher

Changes

Cause

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