When Trying To Open The Sales Order Window An Error Message ORA-06508 Is Displayed (Doc ID 1532313.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

***Checked for relevance on 09-June-2015***

Symptoms

This is the scenario:
Order Management > Orders, Returns > Sales Orders : This Error Message appears: "ORA-06508: PL/SQL: could not find program unit being called in Package ONT_HEADER_Def_Hdlr Procedure Default_Record:",
after bouncing the server, the issue would normally be solved but then after a while it would frequently appear again.

DEFGEN module: Defaulting Generator
+---------------------------------------------------------------------------+

Current system time is 02-JUL-2012 09:47:23

+---------------------------------------------------------------------------+

**Starts**02-JUL-2012 09:47:23
ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.OE_DEFAULTING_FWK_PUB", line 1148
ORA-20000: ORA-20000: No package specification found for package bo
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
------------------------------------------------------------------------------
Create defaulting handler package for entity
Call AD_DDL to create BODY of package ONT__Def_Hdlr
Error in creating entity def hdlr ORA-20000: ORA-20000: No package specification found for package body "ONT__DEF_HDLR" create_package(APPLSYS, ONT, ONT__Def_Hdlr, TRUE, 1, 96): create_plsql_object(APPLSYS, ONT, ONT__Def_Hdlr, 1, 96, TRUE): : : substr($statement$,1,255)='': : substr($statement$,1,255)=''
+---------------------------------------------------------------------------+

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