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

Last updated on JANUARY 27, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.2.5 [Release 11.5 to 12.2]
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):

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 per <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

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