R12: APXRMTCH - Unable to Match to Receipt if PO Revised after Receipt - Error APP-SQLAP-10771 and APP-SQLAP-10655 (Doc ID 783261.1)

Last updated on MAY 17, 2016

Applies to:

Oracle Payables - Version: 12.0.0 to 12.0.7 - Release: 12.0 to 12.0
Information in this document applies to any platform.
APXRMTCH - Match to Receipt form

Symptoms


Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.

-- Problem Description
Users are unable to match to a receipt whose PO has been revised after the receipt.

Create a PO and receive it. Add a new line, then re-approve it. When
trying to match to this Receipt, once the Find Receipts for Matching window
returns the PO line, and trying to select the line to match to, receive the
following error:

APP-SQLAP-10771: Could not reserve record
Click OK
APP-SQLAP-10655: You cannot match to this document.  You can match only to the document (purchase order or receipt) specified by the Invoice Match option on the purchase order shipment. Either match to the specified document, or update the Invoice Match option for the shipment and complete this match.

-- Steps to Reproduce
Purchasing > Purchase Orders > Purchase Orders
Create PO for Supplier=XYZ, Site=ABC, Qty=1, Price=99
Match Approval Level=3-way
Invoice Match Option=RECEIPT
Save and Approve.

Receiving > Receipts
Organization=MN, Receipt Date=01-DEC-2008
Receive the full quantity and save.

Payables > Invoices > Entry > Invoices
Create Invoice for Supplier=XYZ, Site=ABC, Invoice Amount=99, Match Action=Receipt
Click the Match button.

From the Find Receipts for Matching window
Find the receipt
Enable the Match option and No error

Purchasing > Purchase Orders > Purchase Orders
Query up same PO
Add a new PO line, Qty=1, Price=99,
Match Approval Level=3-way, Invoice Match Option=RECEIPT
Saved it.

Actions button > Submit for Approval
Click OK
Check Purchase Orders > Purchase Orders Summary shows Status=Pre-Approved.

Payables > Invoices > Entry > Invoices
Create Invoice, Supplier=XYZ, Site=ABC, Invoice Amount=99, Match Action=Receipt
Click the Match button.

Click Find Receipt for Matching
Once the line was returned, try to select it and encounter error

-- Business Impact   
Unable to rematch to a modified PO.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms