On Journal Source form (GLXSTSRC ) having error FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04031 (Doc ID 2022464.1)

Last updated on AUGUST 12, 2015

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Journal Source form (GLXSTSRC )

Symptoms

When insert new record on GLXSTSRC Journal Source form, the following error occurs:

Error
------
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04031

Also, on FDFVGN: Flexfield View Generator observed the following errors:

Error
------
Oracle error -4031: ORA-04031: unable to allocate 2360 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","sort segment handle")
has been detected in fnd_global.initialize[fnd_init_sql].

Oracle error -20001: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON, ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.POPULATE_ORGS, N, ERRNO, -4031, N, REASON, ORA-04031: unable to allocate 2360 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","sort segment handle") has been detected in MO_GLOBAL.INIT.

Steps
------
1. Navigation steps: GL: Setup > Journal > Sources.  
2. Insert new record.

Changes

 Upgrade to R12.1.3

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