My Oracle Support Banner

ITS Completes In Error > Stops Processing Other Deliveries When one RTV Delivery Fails (Doc ID 2761696.1)

Last updated on MARCH 18, 2021

Applies to:

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

Symptoms

On : 12.2.9 version, Interface Trip Stop

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

ERROR
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

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



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.