My Oracle Support Banner

iSupplier Advance Shipment Notices (ASNs) Stuck With Processing Status Code RUNNING in Receiving Interface When Receiving Transaction Processor Intermittently Errors With RVTPT-054 (ORA 0054) (Doc ID 3010005.1)

Last updated on MARCH 14, 2024

Applies to:

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

Symptoms

i-Supplier ASNs are sometimes getting stuck in processing status code RUNNING mode in Receiving interface.
This does not happen to all the ASNs being processed. The Receiving Transaction Processor errors with the following error message.

ERROR 
RVTPT-054: ORA-01086: savepoint 'START_TRX' never established in this session or
 
STEPS  
1. i-Supplier portal > Create ASN > Submit  (Multiple)
2. Run Receiving transaction processor programmatically for each group_id in rcv_transactions_interface
3. Some ASNs get stuck in Receiving interface in processing status code = RUNNING 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.