My Oracle Support Banner

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

Last updated on JULY 16, 2018

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.