My Oracle Support Banner

Release Sales Order SRS Fails With Error ORA-01476: Divisor Is Equal to Zero (Doc ID 2726889.1)

Last updated on NOVEMBER 15, 2020

Applies to:

Oracle Shipping Execution - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Pick Release

When attempting to run Release Sales Order SRS program,
the following error occurs.

ERROR
-----------------------
Error occurred in Inv_Pick_Release_Pub.Pick_Release
ORA-01476: divisor is equal to zero in Package INV_Pick_Release_PUB Procedure Pick_Release
Unexpected error from INV_Pick_Release_Pub.Pick_Release. Exiting
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User responsibility
2. Run Release Sales Order SRS program for sales order

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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