ASNOut Failed To Process In RMS After SOStatus Cancellation (status ‘NI’) Had Been Published (Doc ID 3052083.1)

Last updated on OCTOBER 07, 2024

Applies to:

Symptoms

On : 16.0.3 version, Inventory Movement

When attempting to publish ASNOUT, against a EG transfer whose tsf_qty is 0,
the following error occurs.

ERROR
-----------------------
“javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit DISTRIBUTION_SQL.DISTRIBUTE_TRANSFER_OUT”.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. EG type transfer (WH to store) published into RMS from an external system.
2. SOStatus with 'NI' published into RMS with doc type ‘D’ – which updates item_loc.soh tsf_reserved_qty (for WH) as well as the tsf_qty in tsfitem_inv_flow table.
3. ASNOut is published into RMS with doc type ‘D’ – this fails with following error:
“javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-01476: divisor is equal to zero returned by program unit DISTRIBUTION_SQL.DISTRIBUTE_TRANSFER_OUT”

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot consume asnout for a cancelled transfer

Changes

Cause

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