Alert Log error: ORA-04030: out of process memory when trying to allocate 8216 bytes (PLS PGA hp,PL/SQL STACK) XNP code from APPS.CSI_ITEM_INSTANCE_P causing an error with the XNP_MESSAGE.MSG_HEADER_REC_TYPE

(Doc ID 2317100.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Installed Base - Version 12.1.3.4 and later
Information in this document applies to any platform.

Symptoms

XNP Code causes Ora-4030 error in Alert Log

ERROR
-----------------------
Trace file from alert log shows:     

XNP code from APPS.CSI_ITEM_INSTANCE_P causing an error with the XNP_MESSAGE.MSG_HEADER_REC_TYPE

XNP_CSISOSHP_U.DEFAULT_PROCESS(
 l_msg_header,
 :l_msg_body,
 :error_code,
 :error_message ) ;

ORA-04030: out of process memory when trying to allocate 8216 bytes (PLS PGA hp,PL/SQL STACK)
----- Current SQL Statement for this session (sql_id=5tfvz9jwzghhh) -----
BEGIN
DECLARE
l_msg_header  XNP_MESSAGE.MSG_HEADER_REC_TYPE ;
BEGIN
l_msg_header.message_id := :message_id ;
l_msg_header.message_code := :message_code ;
l_msg_header.reference_id := :reference_id ;
l_msg_header.opp_reference_id := :opp_ref_id ;
l_msg_header.creation_date := :creation_date;
l_msg_header.sender_name := :sender_name ;
l_msg_header.recipient_name := :recipient_name ;
l_msg_header.version := :version;
l_msg_header.direction_indr := :direction_indr ;
l_msg_header.order_id := :order_id ;
l_msg_header.wi_instance_id := :wi_instance_id ;
l_msg_header.fa_instance_id := :fa_instance_id ;
   XNP_CSISOSHP_U.DEFAULT_PROCESS(
   l_msg_header,
   :l_msg_body,
   :error_code,
   :error_message ) ;
 END ;
END ;

Changes

 

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