ROI Add To Receipt Functionality Does Not Work Even After Patch 18418058 PO_PDOI_RECEIPT_NUM_UNIQ (Doc ID 1929842.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Add to Receipt functionality does not work even after application of Patch 18418058:R12.PO.B per <Note 1190576.1> How to Add New Receipt Lines To Existing Receipt Using ROI, Error with PO_PDOI_RECEIPT_NUM_UNIQUE  

Receiving Transactions Processor RVCTP log file shows:

[23-SEP-14 10:29:31] po.plsql.RCV_ROI_HEADER_COMMON.RCV_ROI_HEADER_COMMO.909:         shipment x_new_receipt Y
[23-SEP-14 10:29:31] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin:         v--------Procedure Started-----------v
[23-SEP-14 10:29:31] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.214:           set error message token = PO_PDOI_RECEIPT_NUM_UNIQUE
[23-SEP-14 10:29:31] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.215:           error stack from call to set_error_message
[23-SEP-14 10:29:31] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1:           Current Calling Stack = ?                   RVTBM.C             RCV_ROI_PREPROCESSORRCV_ROI_HEADER      RCV_ROI_HEADER_COMMORCV_ERROR_PKG      
...
[23-SEP-14 10:29:31] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.71:           logging error Receipt number must be unique.RP_1006 already exists. on column RECEIPT_NUM
[23-SEP-14 10:29:31] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.36:           error stack from call to po_interface_call
[23-SEP-14 10:29:31] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1:           Current Calling Stack = ?                   RVTBM.C             RCV_ROI_PREPROCESSORRCV_ROI_HEADER    

Output of Receiving Data Collection script shows in PO_INTERFACE_ERRORS table


Steps
The issue can be reproduced at will with the following steps:
a. Apply <Patch 18418058> R12.PO.B which contains the fix from <Bug 17962808> and will upgrade your file version to: RCVDFLTB.pls 120.38.12010000.25.

b. Populate ROI interface tables rcv_header_interface (RHI), rcv_transactions_interface (RTI)  
In Rcv_headers_interface
HEADER_INTERFACE_ID 3074800
RECEIPT_NUM RP_1006 --existing receipt_num for same vendor
VENDOR_ID 28427
VENDOR_SITE_ID 1366934

c. Run Receiving Transaction Processor.

d. See error

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