Inventory Adjustments Failing In The Hospital
(Doc ID 2981660.1)
Last updated on OCTOBER 20, 2023
Applies to:
Oracle Retail Integration Cloud Service - Version NA and laterInformation in this document applies to any platform.
Goal
The user has a high number of MessageFamily=>InvAdjust, MessageType=>InvAdjustCre that failed in RMS RIB Hospital.
Exception while processing request: Error from {call RMSSUB_INVADJUST.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit DISTRIBUTION_SQL.DISTRIBUTE_ORDRCV_ADJ.
Example Payload:
<dc_dest_id>1900
<item_id>104055146
<from_disposition>PP
<to_disposition>ATS
<unit_qty>50
<user_id>LogfireUser
<create_date>2023-10-10T12:05:22
<po_nbr>1872921
<doc_type>P
<aux_reason_code>25
This is coming from Oracle WMS Cloud into MFCS via RICS.
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 |