PF_ALLOC_ENG SQL Error: ORA-30927: Unable to complete execution due to failure in temporary table transformation (Doc ID 1904128.1)

Last updated on DECEMBER 15, 2015

Applies to:

PeopleSoft Enterprise EPM Performance Management Warehouse - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : PeopleTools 8.51.16; PeopleSoft Enterprise EPM Performance Management Warehouse 9.0; Data Manager/Allocation Manager; AE PF_JOBSTREAM

When attempting to run PF_ALLOC_ENG the following error occurs.

APPLICATION ENGINE ERROR
--------------------------------
-- 15.05.21 .................(PF_TREETBL.COMMON.Node-US) (SQL)
RECSTATS PS_PF_TREE_NOD_T1 LOW
/
-- Row(s) affected: 0
-- 15.05.22 Process 1764248 ABENDED at Step PF_TREETBL.COMMON.Node-US (Action SQL) -- RC = 30927
ROLLBACK
/
-- 15.05.22 SQL Error: ORA-30927: Unable to complete execution due to failure in temporary table transformation ORA-06512: at "SYS.DBMS_STATS", line 23829 ORA-06512: at "SYS.DBMS_STATS", line 23880 ORA-06512: at line 1

ORACLE ENTERPRISE MANAGER (OEM) SQL MONITORING ERROR
-----------------------------------------------------------------------
Its fails the SQL

ORA-30927: Unable to complete execution due to failure in temporary table transformation
ORA-06 512: at "SYS.DBMS_STATS", line 23829
ORA-06512: at "SYS.DBMS_STATS", line 23880
ORA-06512: at line 1
Failed SQL stmt:RECSTATS PS_PF_TREE_NOD_T2 LOW
---
java.sql.SQLException: ORA-30927: Unable to complete execution due to failure in temporary table transformation
ORA-06512: at "SYS.DBMS_SQLTUNE", line 13969
ORA-06512: at "SYS.DBMS_SQLTUNE", line 14265

ENVIRONMENT DETAILS
--------------------------
app server => redhat linux5 64-bit
db => redhat linux5 64-bit
oracle db 11.2.0.3
Oracle DB patch level 11.2.0.3.10

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