ORA-14450 After Upgrading Database from 10g to 11g
(Doc ID 1996516.1)
Last updated on FEBRUARY 03, 2019
Applies to:JDBC - Version 18.104.22.168.0 and later
Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.
Application that accesses a temporary table in an Oracle database from a Weblogic 10.3 JVM using JDBC and XA.
This application has only a single branch of the transaction on the database.
The application logic is to insert data into two temporary tables by direct JDBC calls and then to call a stored procedure to update permanent tables with the data in the temporary tables.
The error is occurring on the first statement of the transaction, before the stored procedure is called.
The issue arises as soon as the application starts.
The application has been working without issue on Oracle database 10g.
While currently testing using new infrastructure that involves Oracle database 22.214.171.124, ORA-14450 errors are received frequently.
ORA-14450: attempt to access a transactional temp table already in use
----- Current SQL Statement for this session (sql_id=4w4x8jwyzskhw) -----
insert into ope_enrich_results_tmp (tbe_identifier, trial_balance_id, business_date, adjustment_date, book_global_id, ps_gl_comp_id, src_type_cd, adj_src_sys_feed_id, amount_type, in_posting_key, def_posting_key, ovr_posting_key, read_tms, enrich_start_tms, enrich_end_tms, update_cached_tms, results_written_tms, run_sequence_number, tran_type_id, unadj_src_sys_feed_id, region_cd, structure_id,posting_key_position_1_value) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ,:11 ,:12 , :13 , :14 , :15 , :16 , :17 , :18 ,:19 , :20 , :21 , :22 ,:23 )
Upgrade of Oracle database from 10g to 11g.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|