My Oracle Support Banner

ORA-14450 Error When Bulk Processing ASN Or Purchase Order Messages From External Sytem (Doc ID 2489996.1)

Last updated on AUGUST 18, 2020

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

ORA-14450 error occurs when processing bulk ASN (Advance Shipment Notice) messages or purchase orders into RMS and the item locations are not ranged.

Error: ORA-14450: attempt to access a transactional temp table already in use returned by program unit RPM_NEW_ITEM_LOC_SQL.ITEMLOC_RANGING_PROCESS.

Steps To Reproduce:
---------------------------

  1. Publish 400-500 ASN or PO messages where most of them do not have item location ranged.
  2. Note the above error occurs.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.