My Oracle Support Banner

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 later
Information 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


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