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.
On : 12.2.5 version, Pick Release
When attempting to run Release Sales Order SRS program,
the following error occurs.
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
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
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