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 MARCH 08, 2017

Applies to:

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

Symptoms

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.

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