ROI Add To Receipt Functionality Does Not Work Even After Patch 18418058 PO_PDOI_RECEIPT_NUM_UNIQ
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.
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
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)
RECEIPT_NUM RP_1006 --existing receipt_num for same vendor
c. Run Receiving Transaction Processor.
d. See error
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms