GLOOAP: Open Period Program Fails with ORA-14451 : Unsupported Feature with Temporary Table (Doc ID 2099601.1)

Last updated on JANUARY 28, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
GLOOAP
ORA-14451

Symptoms

On : 12.2.4 version, Setup forms and programs, user tries to open period and Open Period Programs ends in error:

SHRD0043: ERROR ORA-14451: unsupported feature with temporary table.

Log file shows the following:

<x glsamn() 22-DEC-2015 10:09:06
SHRD0015: glooap failed:
*****************************************************
sqlcaid:   sqlabc: 0  sqlcode: -14451  sqlerrml: 70
sqlerrmc:
ORA-14451: unsupported feature with temporary table
ORA-06512: at "APP
sqlerrp:   sqlerrd: 0 0 0 7 0 538976288
sqlwarn:           sqltext:  
*****************************************************

oracaid:   oracabc: 0
oracchf: 0   oradbgf: 0   orahchf: 0  orastxtf: 0   orastxtl: 0
orastxtc:

orasfnmc:   oraslnr: 0  orasfnml: 0
orahoc: 0  ormoc:  0  oracoc: 0  
oranor: 0  oranpr: 0  oranex:  0

SHRD0015: glsamn failed:
SHRD0033: Error Status:   3
SHRD0103: Function warning number: -1
*****************************************************
SHRD0044: Process logging off database and exiting ...


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