Error "ORA-14450: attempt to access a transactional temp table already in use" Occurs When Sending a Large Number of XCostChg Messages (Doc ID 972412.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.0.3 to 13.0.3.3 [Release 13.0]
Oracle Retail Merchandising System - Version 13.2.6 to 13.2.6 [Release 13.2]
Information in this document applies to any platform.

Symptoms

When many XCostChg messages are sent from external systems to Retail Merchandising System (RMS), these messages fail with the following error in the Retail Integration Bus (RIB) error hospital:

 

Steps to Reproduce:
  1. From an external system, send a large number of cost changes through the XCostChg interface into RMS.

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