My Oracle Support Banner

Interface Trip Stop ITS Completes In Error > Stops Processing Other Deliveries When one RTV Delivery Fails > Error: ORA-01086: savepoint 'SP_RCVTM' never established in this session or is invalid Causing Entire Batch to Fail (Doc ID 2761696.1)

Last updated on OCTOBER 04, 2023

Applies to:

Oracle Shipping Execution - Version 12.2.9 and later
Information in this document applies to any platform.


On : 12.2.9 version, Interface Trip Stop

Scheduled Interface Trip Stop program without any parameters goes in error and the orders are not getting interfaced until running the ITS manually for the delivery or org.

Also happens when using RTV with shipping integration. ITS is scheduled to run every 15 mins
When one of the RTV delivery fails to interface, other deliveries are not processed at all.
This also sometimes leaves few records in MTI with lock_flag = 1 (locked)

Unexpected error has occured. Oracle error message is ORA-01086: savepoint 'SP_RCVTM' never established in this session or is invalid
ORA-06512: at "APPS.RCV_WSH_INTERFACE_PKG", line 1371
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.RCV_WSH_INTERFACE_PKG", line 567
ORA-06510: PL/SQL: unhandled user-defined exception

The issue can be reproduced at will with the following steps:
1. Order Management Responsibility,
2. Shipping > Transactions > Interfaces,
3. Choose Single Request - then select 'Interface Trip Stop - SRS',
4. Enter the delivery or stop and execute the request,
5. Error is found in the log file.


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

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