My Oracle Support Banner

How to resolve error: OE_HOLDS_PUB.process_holds Raise Unexpected Error? (Doc ID 2445177.1)

Last updated on APRIL 16, 2019

Applies to:

Oracle Order Management - Version 12.2.6 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.

Goal

Current file version:

/* $Header: OEXPHLDB.pls 120.34.12020000.6 2015/11/19 04:56:30 nvadiyal ship $ */

While trying to use "OE_HOLDS_PUB.process_holds" API, this error is seen:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OE_HOLDS_PUB", line 6095
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.OE_HOLDS_PUB", line 5902
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 14
06510. 00000 - "PL/SQL: unhandled user-defined exception"
*Cause: A user-defined exception was raised by PL/SQL code, but
  not handled.
*Action: Fix the problem causing the exception or write an exception
  handler for this condition. Or you may need to contact your
  application administrator or DBA.

It happens when there are existing holds (at Bill To Level) and users try to APPLY holds again on same Bill To.

In "OE_Holds_PUB" : IF NOT Hold_exists(p_hold_entity_code,p_hold_entity_id,p_hold_id,l_org_id) THEN ...
Analysis : p_hold_entity_code has "S", but holds are created with "B" (OE_HOLD_SOURCES_ALL), as we are applying holds at Bill To.

When "Hold_exists" is called, it's done with "S" (p_hold_entity_code) and not with "B" (l_hold_entity_code). So, existing holds are not find.

Can you help me on this issue please ? 
 

NOTE: Despite its name, OE_HOLDS_PUB is not available for use as a public API.

Solution

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