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 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.

Symptoms

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.

Changes

 

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