Rib Message Are Failing With Error ORA-14450: Attempt To Access A Transactional Temp Table Already In Use Returned
Last updated on JUNE 12, 2018
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.
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