ORA-06508 PL/SQL Could Not Find Program When Open Sales Order Form

Problem

The issue can be reproduced following

1. Login to R12 Application with respective user

2. Responsibility- Order Management Super User

3. Navigate to  Orders->Returns ->Order Organizer

4. Open Sales Order form and see error:

ORA-06508: PL/SQL: could not find program unit being called In Package ONT_HEADER_Def_Hdlr Procedure Default_Record: REQUEST_DATE 1

Solution

Shared pool memory is too low or high causing a resource utilization

Please update following parameter with given minimum value

sqlplus / as sysdba 
sql> alter system set shared_pool_size=600M scope=spfile; 
sql> alter system reset shared_pool_reserved_size scope=spfile; 
sql> alter system set db_cache_size=400M scope=spfile; 
sql> shutdown immediate 
sql> startup

Reference : Open Sales Order Screen Generates Error ORA-06508 PL/SQL Could Not Find Program Unit Being Called (Doc ID 841870.1)