When Entering Sales Order get ORA-01403: NO DATA FOUND IN PACKAGE OE_HOLDS_PUB PROCEDURE EVALUATE_HOLDS_PUB (Doc ID 1508427.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.

Symptoms

When entering a sales order (OEXOEORD), getting the error message "ORA-01403: no data found in Package OE_Holds_PUB Procedure evaluate_holds_post_write" when saving a sales order line


Changes

 Appeared after installating the <Patch 13987649>:R12.ONT.B - Applying this patch will resolve the issue of Line Level Credit Check Failure Hold not being released from OCM while using Party Level Limits".

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