My Oracle Support Banner

Not Able To Bring Back Approved Transfers To Input Status Via API. (Doc ID 2901274.1)

Last updated on OCTOBER 07, 2022

Applies to:

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


Not able to change the Approved Transfer order to Input status via API and it’s throwing the below error. However, can bring back the approved transfer order to inputs status via UI then it’s reversing the inventory quantity in item loc soh table.


Error details.
avax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_XTSF.CONSUME(?,?,?,?)}: [E] The status of transfer cannot be changed from Approved to Input.
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler.handleMessage(
at com.retek.rib.collab.HospitalController.performHandlerCall(
at com.retek.rib.collab.HospitalController.doMessage(
at com.retek.rib.collab.HospitalController.doMessage(
at com.retek.rib.j2ee.RIBMessageSubscriberEjb.onMessage(
at sun.reflect.GeneratedMethodAccessor977.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(


 NOTE: The fix will include the following

Setting the transfer from 'A' to 'I'nput via the API:

1.Will be available for only MR/IC type transfers
2. Will allow only for Approved transfers to be moved back. Once processing has started on a transfer (Status= In progress), moving back to Input status will not be permitted
3. Need to let them know that moving a transfer to input status manifests as a delete to the distribution systems (SIOCS, WMS) and these systems should support accepting a delete. Once the transfer is deleted, inventory is reserved and these systems can potentially reuse the unreserved inventory.



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

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