After RUP Unable To Receive Any Goods / Services Against Purchase Order RVTBM-008 RVTPT:040 Error in lot/serial or rvtptdoactions (Doc ID 2056679.1)

Last updated on JUNE 01, 2016

Applies to:

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

Symptoms

On :  12.1.3 version,  After applying RUP 21198991:R12.PRC_PF.B / Oracle Procurement Rollup patch (March 2015)
When attempting to receive any goods (expense or inventory) the following error occurs.

1) RVCTP module: Receiving Transaction Processor completes with error
Concurrent program RVCTP returned error
Cause:        RVCTP encountered an internal error.  Parameters:
RVCTP,IMMEDIATE,244131,
Action:        Note both this error number and the actions you are trying to
perform. Contact your system ad
RVTBM-008: Subroutine rvtbm_immediate_mngr() returned error
Cause:        Subroutine rvtbm_immediate_mngr() returned an internal error.  
Action:        Note this error number and the actions you are trying to
perform. Contact your syste
RVTBM-120: Subroutine rvtptcontrol() returned error
Cause:        Subroutine rvtptcontrol() returned an internal error.  

2) Inventory debug log file just shows (even for a non lot / serial controlled item / for expense destination )

******** New Session:9286838****07-SEP-15:12.27.10 **********
Session Id:9286838
po.plsql.RCV_NORMALIZE_DATA_PKG.RCV_NORMALIZE_DATA_P.779:     Process Pending
Rows: p_processing_mode=IMMEDIATE g_group_id=244131 g_request_id=3548905
p_org_id=-1
...
[07-SEP-15 12:27:12] po.src.rvtp.rvtpt.RVTPT.C.3763:     RVTPT:039 Call
validate lot/serial inv api
[07-SEP-15 12:27:12] INV_RCV_INTEGRATION_APIS($Revision: 120.12.12010000.10
$): validate_lot_serial_info: private API throws exception

 [07-SEP-15 12:27:12] po.src.rvtp.rvtpt.RVTPT.C.4053:     RVTPT:054
[07-SEP-15 12:27:12] po.src.rvtp.rvtpt.RVTPT.C.5858:     RVTPT:040 In
rvtptupdate_status 5114
[07-SEP-15 12:27:12] po.src.rvtp.rvtpt.RVTPT.C.5864:     RVTPT:040 Status is
Error
[07-SEP-15 12:27:12] po.plsql.anonymous block.ANONYMOUS BLOCK.begin:    
v--------Procedure Started-----------v
[07-SEP-15 12:27:12] po.plsql.anonymous block.ANONYMOUS BLOCK.1:      
x_fail_if_one_line_fails is N
[07-SEP-15 12:27:12] po.plsql.anonymous block.ANONYMOUS BLOCK.1:      
l_count is = 0 l_head_id = -999
[07-SEP-15 12:27:12] inv_receiving_transaction: TXN_COMPLETE - Enter
txn_complete : 10: 2015-09-07 12:07:12
[07-SEP-15 12:27:12] inv_receiving_transaction: TXN_COMPLETE - Parameters
passed : 10.1: p_group_id - 5114
[07-SEP-15 12:27:12] inv_receiving_transaction: TXN_COMPLETE - Parameters
passed : 10.2: p_txn_status - FALSE
[07-SEP-15 12:27:12] inv_receiving_transaction: TXN_COMPLETE - Parameters
passed : 10.3: p_txn_mode - PROCESSOR
[07-SEP-15 12:27:12] inv_receiving_transaction: TXN_COMPLETE - Release Level
is J or Above
[07-SEP-15 12:27:12] inv_receiving_transaction: TXN_COMPLETE - PROCESSING
MODE:

3) Record is stuck with no error in RCV_TRANSACTIONS_INTERFACE table
Output of Receiving Data Collection script shows

RCV_TRANSACTIONS_INTERFACE
Interface_Transaction_Id 5114
Transaction_Type RECEIVE 
Processing_Request_Id 3548905
Transaction_Status_Code ERROR
Quantity 12
Item_Id 14
Auto_Transact_Code DELIVER
To_Organization_Id 192
Source_Document_Code PO
Po_Header_Id 3103
Destination_Type_Code EXPENSE
Use_Mtl_Serial 1
Org_Id 192
 

4) SQL Trace file of RVCTP request  shows last instructions before rollback are

SELECT 'TRACE_USER_DETAILS: TIMESTAMP=07-SEP-15:12:27:11: USER_NAME=EVOFIN:
 CONC_REQUEST_ID=3548905: OLTP_OPT_MODE=CHOOSE: CONC_OPT_MODE=CHOOSE:
 CONC_PROG_EXE=RVCTP: CONC_PROG_NAME=Receiving Transaction Processor:
 RESPONSIBILITY=Inventory: APPL_NAME=INV'
...
***************************************************************************
select nvl(rti.parent_transaction_id,0) ,nvl(rti.parent_interface_txn_id,0)
 into :b0,:b1  
from
rcv_transactions_interface rti where rti.interface_transaction_id=:b2

call     count       cpu    elapsed       disk      query    current   rows
------- ------  -------- ---------- ---------- ---------- ----------  -----
Parse        1      0.00       0.00          0          0          0      0
Execute      1      0.00       0.00          0          0          0      0
Fetch        1      0.00       0.00          0          2          0      1
------- ------  -------- ---------- ---------- ---------- ----------  -----
total        3      0.00       0.00          0          2          0      1
...
**************************************************************************
rollback  to start_trx
...

Steps
-----------
Navigate to Receiving / Receipts  RCVRCERC form
Enter receipt  for any document, Receiving, Expense or Inventory destination.

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