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