Message Fails in RMS Hospital When SIM Receives DSD On The Fly
(Doc ID 2464356.1)
Last updated on APRIL 11, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and laterInformation 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 |