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

Last updated on APRIL 11, 2024

Applies to:

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

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