My Oracle Support Banner

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 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

On Purchase Order Summary form, POXPOVPO, when attempting to finally close (or cancel) a specific purchase order the following error occurs.

ERROR:

Shipment #1 Unprocessed receiving transactions exist for this purchase order header.

 Or

Error: Shipment #1 You cannot finally close this document because unprocessed receiving transactions exist.


STEPS TO REPRODUCE:

  1. Navigate to Purchasing Responsibility  => Purchase Order Summary form
  2. Search for the purchase order 
  3. Tools-->Control-->Actions
  4. 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:

SQL> Select distinct rti.*
from rcv_transactions_interface rti
where nvl(rti.document_num , '-99999') = '&Po_Number'
or exists (
select 1
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 ) ;

Cause

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
Symptoms
Cause
Solution
References

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