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

Last updated on MARCH 13, 2017

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)

Symptoms

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

Error

RVTII-060 Missing FOB Point error


Steps
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.


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