Overload Of Oe_holds_pub.Apply_holds Raises ORA-01086
(Doc ID 1300638.1)
Last updated on MARCH 12, 2018
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!