My Oracle Support Banner

Some Intransit Shipments Fail with RVTII-060 Fob (Free On Board) Point Not Defined / Duplicate Shipments Lines (Doc ID 396788.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Oracle Inventory Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
EXECUTABLE:RVCTP - Receiving Transaction Processor
FORM:RCVTXVTX.FMB - View Transactions Status
FORM:RCVRCERC.FMB - Enter Receipts
FORM:RCVTXERT.FMB - Enter Receiving Transactions

Symptoms

The following error occurs when performing Deliver transaction for some Intransit Shipments (Internal Requisitions/Sales Orders or Inter Organization Inter-Org Transfers):

Error
rvtptcontrol failed
RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned error


** The error can be viewed by reviewing:
Transaction Status Summary
-or- PO_INTERFACE_ERRORS table
-or- RVCTP Receiving Transaction Processor Request Log (RCV: Processing Mode=Batch or Immediate)
-or- Enter Receipts or Enter Receiving Transactions forms

Since RVTII-060 error is a generic error message, Inventory debug details are required to determine the source of the problem.

The Inventory Debug Log file shows the following error when the transaction is attempted after setting the debug profiles (see Note 299497.1)

INV_LPN_TRX_PUB: trx_temp_id1673100
INV_LPN_TRX_PUB: no data found mtl_material_transactions
INV_LPN_TRX_PUB: Error from update_fob_point:
INV_LPN_TRX_PUB: ***Error g_exec in c_mmtt loop trxtmpid=1673100,Sqlerrm:User-Defined Exception
INV_LPN_TRX_PUB: failedrowcnt=1 msg=
INV_LPN_TRX_PUB: Done with MMTT cursor insrowcnt=1 failedrowcnt=1
INV_LPN_TRX_PUB: l_process: 0
INV_TXN_MANAGER_PUB: Error from PROCESS_LPN_TRX.. FOB (Free on Board) point is not defined for the organization (nnn)

Note the 'INV_LPN_TRX_PUB: no data found mtl_material_transactions ' message

RVCTP Trace shows last instructions are

********************************************************************************
SELECT FOB_POINT , INTRANSIT_ACCOUNT
FROM
MTL_MATERIAL_TRANSACTIONS WHERE TRANSACTION_ID = :B1

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          2           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          1          3          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.00          1          3          2           0
...
********************************************************************************
ROLLBACK TO GROUP_SAVEPOINT

 

Also when Item is Serial Controlled debug may show
VALIDATE_LOT_SERIAL_INFO: SERIAL NOT ENTERED ON PARENT: WMSINB-23287

In the PO_INTERFACE_ERRORS table:
INV_ALL_SQL_ERROR
(ROUTINE=INV_RCV_INTERFACE_PVT.VALIDATE_LOT_SERIAL_INFO)
(ERR_NUMBER=ORA-01422: exact fetch returns more than requested number of rows)
(SQL_ERR=ORA-01422: exact fetch returns more than requested number of rows)

Another symptom may be that there are Duplicate records to receive (because there are duplicate shipment lines in rcv_shipment_lines table for the same intransit IOT shipment).

Also in the Source organization the material transactions form does not show any issue transaction for the intransit shipment.

In Release 12 the error message may be

RCV_INVALID_SHIPMENT_SOURCE(MMT_TXN_ID=nnnnn1)(RSL_ID=nnnnn2)

 or

rvtptcontrol failed
RVTII-060: Subroutine
INV_TXN_MANAGER_PUB.process_Transactions() returned error

RVTVT-065: Subroutine afdname() returned error
FOB (FREE ON BOARD) POINT IS NOT DEFINED FOR THE
ORGANIZATION (nnn)

or

APP-PO-15576: Shipment source &MMT_TXN_ID for shipment line &RSL_ID is invalid.

Changes

 

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!


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