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.


On : 12.1.3 version, Receiving Functions

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

Expect interorg transfer shipment completed and no stuck receiving.

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


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