Error "ORA-01476: DIVISOR IS EQUAL TO ZERO" While Accessing Warehouse Replenishment Plan Detail
(Doc ID 2068634.1)
Last updated on MARCH 06, 2019
Applies to:Oracle Spares Management - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, Planner's Desktop
Upon trying to access the detail page in the warehouse replenishment planning
You have encountered an unexpected error.Please contact the System Administrator for assistance
Click here for exception details
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(cpdv.plan_Detail_type, 1, item_number, plan_detail_type_meaning) Plan_Detail_Type_Meaning,
java.sql.SQLDataException: ORA-01476: divisor is equal to zero
The issue can be reproduced at will with the following steps:
1. Field Service Dispatcher>Spares Logistics>Warehouse Replenishment Planning
2. Enter organization details and click Go
3. Click Detail pencil icon on any of the plan results
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