Root Cause RVTII-060 Missing Fob Point Error (Profile: INV: Create RCV Shipments in Bulk) [Video]

(Doc ID 1390812.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
RCVTM - Receiving Manager
Profile: INV: Create RCV Shipments in Bulk (INV_RCV_SHIPMENTS_BULK)


When receiving material, the following error appears. The issue could impact Inter-Organization Transfer (IOT) and Internal Requisition / Internal Sales Order (ISO).


RVTII-060 Missing FOB Point error

Users were not able to replicate the issue at will but it would occur periodically. Below are example steps that might occur:

  1. Attempt an inter-org transfer (and it usually works).
  2. Sometimes, but not consistently, transactions time-out and fail. (Possibly caused by some network or system bottleneck.)
  3. After the failed transactions, orphan shipment transactions are seen running SQL from <Note 789732.1>.
  4. If users try to repeat the transaction, it fails with the error.

Steps: Forcing the Issue
Support engineers were able to force the issue to happen by putting a manual lock on the onhand quantity table. The lock on the table simulated a "bottleneck" that users might have during normal transaction processing.

Note: This approach to cause the issue is not suggested or supported but only referenced for information purposes.

Video - Demonstrate Causing Issue With SQL (03:51)

The following is example SQL used to create the temporary lock on the onhand quantity table:

select * from mtl_onhand_quantities_detail
where inventory_item_id = &YourItemID
for update nowait;

Already tried

The issue remains even after patching from <Note 396788.1> including patches like <Patch 9176802> and <Patch 9283709>.

Business Impact

  1. Results in delays and data corruption.  Must run datafixes from <Note 789732.1> to fix data.
  2. Issue does not happen consistently so confusing to users and causes delays in getting shipments to customers.




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