Unable To Finally Close Purchase Orders, Unprocessed Receiving Transactions Message
(Doc ID 306884.1)
Last updated on JULY 02, 2018
Applies to:Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Oracle Purchasing - Version 184.108.40.206 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
On Purchase Order Summary form, POXPOVPO, when attempting to finally close (or cancel) a specific purchase order the following error occurs.
STEPS TO REPRODUCE:
- Navigate to Purchasing Responsibility => Purchase Order Summary form
- Search for the purchase order
- Try to finally close or cancel the purchase order
Rcv11i output from <Note 402245.1> shows one record is stuck in rcv_transactions_interface table
Also the following script for the specific purchase order number returns a record:
from rcv_transactions_interface rti
where nvl(rti.document_num , '-99999') = '&Po_Number'
or exists (
from po_headers_all ph
where ph.segment1 = '&Po_Number'
and ph.org_id = &org_id and
rti.po_header_id = ph.po_header_id ) ;
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