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.
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:
- Publish 400-500 ASN or PO messages where most of them do not have item location ranged.
- Note the above error occurs.
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