My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

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***


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


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.