My Oracle Support Banner

Rib Message Are Failing With Error ORA-14450: Attempt To Access A Transactional Temp Table Already In Use Returned (Doc ID 2409069.1)

Last updated on AUGUST 07, 2020

Applies to:

Oracle Retail Merchandising System - Version 14.1.3 and later
Oracle Retail Price Management - Version 14.1.3 and later
Information in this document applies to any platform.


After RMS 14.1.3 Deployment , RIB message failing with below error:
Error ORA-14450: attempt to access a transactional temp table already in use returned by program unit MERCH_RETAIL_API_SQL.GET_PROJECTED_CLEAR_RETAIL

Steps to Reproduce:

1. Process high volume of Xtsf, InvAdj, and ASNOut messages at the same time.
2. All messages are failing, even after retries.




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.