Stuck RTI with PROCESSING_STATUS_CODE = 'RUNNING' when use API INV_TXN_MANAGER_PUB.process_transactions (Doc ID 1910804.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Receiving Functions

ACTUAL BEHAVIOR
---------------
Receiving interface transactions (RCV_TRANSACTIONS_INTERFACE) are stuck with PROCESSING_STATUS_CODE = 'RUNNING' after processing intransit shipment transactions via the open interface using the API (INV_TXN_MANAGER_PUB.process_transactions).

EXPECTED BEHAVIOR
-----------------------
Expect interorg transfer shipment completed and no stuck receiving.

STEPS
-----------------------
1. Insert intransit inter-org transactions with transaction mode 2 / Concurrent into the open interface tables (MTL_TRANSACTIONS_INTERFACE, MTL_SERIAL_NUMBERS_INTERFACE)
2. Call the API (INV_TXN_MANAGER_PUB.process_transactions)
3. The shipment is created but a record is stuck in RCV_TRANSACTIONS_INTERFACE with PROCESSING_STATUS_CODE = 'RUNNING'.

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