E-CA: "ORA-00604: error occurred at recursive SQL level 4 ORA-04031: unable to allocate 272 bytes of shared memory..." Error When Running Step "Running the CP Compare reports" in Change Assistant (Doc ID 2143521.1)

Last updated on MAY 27, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version, Change Assistant
 
Using a Change Package created from FSCM PUM Update Image 18 using the Native OS on Windows 2012 R2 Server, when running the step "Running the CP Compare reports", it failed with the following error in the log:

ERROR
-----------------------
Records Application Upgrade Compare started: 2016-05-24-08.18.53
File: E:\pt85422b-retail\peopletools\src\psprj\upgrade.cppSQL error. Stmt #: 8323 Error Position: 0 Return: 604 - ORA-00604: error occurred at recursive SQL level 4 ORA-04031: unable to allocate 272 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","kccdef: qkxrMemAlloc") ORA-06508: PL/SQL: could not find program unit being call

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