My Oracle Support Banner

Message Fails in RMS Hospital When SIM Receives DSD On The Fly (Doc ID 2464356.1)

Last updated on OCTOBER 25, 2018

Applies to:

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

Goal

When SIM Receives Direst Store Delivery (DSD) on the fly, DSDReceipt message fails in RMS RIB Hospital table with following error:

Error:
javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_DSD.CONSUME(?,?,?,?,?)}: [E] Order has not been approved.
javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_DSD.CONSUME(?,?,?,?,?)}: [E] Error ORA-14450: attempt to access a transactional temp table already in use returned by program unit ELC_CALC_SQL.INSERT_OE_TEMP.

Steps to Recreate:
1. In SIM, receive a DSD on the fly.
  a. Navigate to Shipping/Receiving, DSD Receiving, then Create Receipt.
  b. Enter the supplier ID.
  c. Create a container, add an item, confirm container.
  d. Receive/confirm delivery.
2. Note that SIM on hands update, but RMS on hands do not.
3. Notice that message is failed in the RMS RIB Hospital.

Solution

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