XCOSTCHG Throws ORA-14450:"attempt to access a transactional temp table already in use" Error
Last updated on OCTOBER 23, 2017
Applies to:Oracle Retail Merchandising System - Version 13.2.8 and later
Information in this document applies to any platform.
RMSSUB_XCOSTCHG throws approximately 100 XCostChgDesc messages (below). Upon waiting 5 minutes and resubmitting a message through the Retail Integration Error Hospital administration (RIHA), the next one fails. Thus over 100 xCostChg messages remain waiting to be processed.
Steps to Reproduce:
1. Publish cost change messages (more than a hundred).
2, Observe locking issue.
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