My Oracle Support Banner

When Calling a Sequence of GME APIs, Get Error, Attempt to access a transactional temp table already in use - ORA 14450 (Doc ID 2209807.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.


We process a batch in the same transaction (no COMMIT in between) by calling a sequence of api s as follows with the required parameters.

1. gme_api_pub.create_batch
2. gme_api_pub.insert_material_line
3. gme_api_pub.update_material_line
4. gme_api_pub.release_batch
5. gme_api_pub.create_material_txn
6. gme_api_pub.complete_batch

This is sometimes resulting in an error during the Release Batch API with the error message "Attempt to access a transactional temp table already in use - ORA 14450.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.