Overload Of Oe_holds_pub.Apply_holds Raises ORA-01086 (Doc ID 1300638.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Jan-2015***

Symptoms


API oe_holds_pub.apply_holds returns an incorrect error message that raises the following exceptions when it can't apply the holds due to an expected error instead of returning normally with x_return_status = FND_API.G_EXC_ERROR and placing a meaningful error message on the message stack.

The exceptions are:
ORA-01086: savepoint 'APPLY_HOLDS_PUB' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception

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