Unable to Perform Receiptfor Internal Requisition RVCTP Fails Rvtth-115b (Doc ID 469454.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Inventory Management - Version: 11.5.10 and later   [Release: 11.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 21-Mar-2012***

EXECUTABLE:RVCTP - Receiving Transaction Processor

Symptoms

When attempting to perform receiving for internal requisition the following error occurs.

ERROR:

RVCTP module: Receiving Transaction Processor
Purchasing: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
RVCTP module: Receiving Transaction Processor
+---------------------------------------------------------------------------+
RVTTH-115b: Subroutine process_transaction() returned error
Cause:        Subroutine process_transaction() returned an internal error.
Action:        Note this error number and the actions you are trying to perform. Contact your system
Concurrent program RVCTP returned error
Cause:        RVCTP encountered an internal error.  Parameters: RVCTP,IMMEDIATE,635185,
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.
Action:        Note this error number and the actions you are trying to perform. Contact your system administrator
Concurrent Manager encountered an error while attempting to start your immediate concurrent program RVCTP. Routine &ROUTINE received a return code of failure.
Contact your support representative.
+---------------------------------------------------------------------------+

 

STEPS TO REPRODUCE:

  1. Create Internal requisition (between operating unit, including intercompany invoicing)
  2. Go to source organization, create a sales order and ship it
  3. Shipment completes successfully.
  4. Go to destination organization to receive the goods.
  5. Receiving transaction processor completes with error.
MESSAGE_TEXT in fnd_log_messages table after Setting debug profiles per <> shows
v--------Procedure Started-----------v
  Process Pending Rows: p_processing_mode=IMMEDIATE g_group_id=635185 g_request_id=16136165 p_org_id=-1
  Processing single group...
  in explode_lpn
  finished explode_lpn
  v--------Procedure Started-----------v
    Updating RTI INTERFACE_TRANSACTION_ID=990737
...
Start of subprogram.
p_po_header_id = 0
100ORA-01403: no data found;SQLERRM = ORA-01403: no data found
End of subprogram.
100ORA-01403: no data found;SQLERRM = ORA-01403: no data found
End of subprogram.
        v--------Procedure Started-----------v
...
              Inserting RT row (RECEIVE)...
              transaction_id: 1468661 parent_transaction_id: -1 interface_transaction_id: 990737 group_id: 635185 request_id: 16136165
              v--------Procedure Started-----------v
"                RVTLS:010 enter rvtlsmaintain
                v--------Procedure Started-----------v
"                  RVSRV:010 transaction_id 0
                ^--------Implicit Procedure Exit-----^
              ^--------Implicit Procedure Exit-----^
            ^--------Implicit Procedure Exit-----^
          ^--------Implicit Procedure Exit-----^
        ^--------Implicit Procedure Exit-----^
"        RVTPT:040 Error in lot/serial or rvtptdoactions or lpn_validation. Rollback to savepoint
"        RVTPT:054
"        RVTPT:040 In rvtptupdate_status 990737
"        RVTPT:040 Status is Error
"        RVTPT:130 interface_trx_id 990737
"        RVTPT:041 Error in rvtptdoactions


Also after setting profile option 'PO: Enable SQL Trace for Receiving Processor' to 'Yes' per <> the RVCTP trace file shows the last instructions are
=====================
PARSING IN CURSOR...
UPDATE MTL_SERIAL_NUMBERS SET GROUP_MARK_ID = NULL, LINE_MARK_ID = NULL,
LOT_LINE_MARK_ID = NULL WHERE INVENTORY_ITEM_ID = :B1 AND EXISTS (SELECT '1'
FROM MTL_SERIAL_NUMBERS_INTERFACE WHERE PRODUCT_CODE = 'RCV' AND
PRODUCT_TRANSACTION_ID = :B2 AND SERIAL_NUMBER BETWEEN FM_SERIAL_NUMBER AND
TO_SERIAL_NUMBER AND LENGTH(SERIAL_NUMBER) = LENGTH(FM_SERIAL_NUMBER) AND
LENGTH(FM_SERIAL_NUMBER) = LENGTH(NVL(TO_SERIAL_NUMBER, FM_SERIAL_NUMBER)) )
END OF STMT
=====================
..
kkscoacd
Bind#0 value=173
Bind#1
oacdty=01 mxl=32(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=18 fl2=0001 frm=01 csi=871 siz=32 off=0
kxsbbbfp=ffffffff78b9c3d0 bln=32 avl=22 flg=05
value="XXX_MTL_SERIAL_NR_T1"
Bind#2
value=3
=====================
...
value="RVTTH-115b: Subroutine process_transaction() returned error
Cause: Subroutine process_transaction() returned an internal error.
Action: Note this error number and the actions you are trying to perform.
Contact your system"

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