ORA-06508 ONT_HEADER_Def_Hdlr

ERROR: 

 Unable To Open The Sales Order Form ORA-06508 ONT_HEADER_Def_Hdlr in R12.1.1 version



Error while opening sales Orer Form



CAUSE :

The issue is caused by the following setup:

Shared pool memory is not big enough . This issue is described in Bug: 4577202



SOLUTION:

To implement the solution, please execute the following steps:



1. Increase the following parameter:

a. shared pool size

b. shared pool reserved size

c. db cache size



Note : You can first increase the shared pool size by

SQL> ALTER SYSTEM SET shared_pool_size ='600M' SCOPE=BOTH;

SQL> alter system flush shared_pool;

Now retest the issue.


REFERENCE:

Open Sales Order Error ORA-06580 ONT_HEADER_Def_Hdlr Default_Record [ID 838592.1]