Application Error ORA-01476: DIVISOR IS EQUAL TO ZERO when Maintaining a Price Change for Non-orderabled Items Or Orderabled with Zero Cost
(Doc ID 2798383.1)
Last updated on MAY 16, 2022
Applies to:Oracle Retail Pricing Cloud Service - Version 19.0 and later
Information in this document applies to any platform.
An application error has occurred when maintaining a price change for Non orderabled items don't have a pricing cost, and even orderabled ones can be set with 0 cost.
sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-01476: divisor is equal to zero@2RPM_OI_SUMMARY_SQL.GET_DETAIL_INFO ORA-01476: divisor is equal to zero
ORA-01476: divisor is equal to zero ORA-06512: at "RMS01.RPM_OI_SUMMARY_SQL", line 790
Steps to reproduce:
1. Create an item with 0 as unit_cost for the primary supplier. Validate that pricing_cost is 0 on RPM_FUTURE_COST.
2. Create a price change for that item.
3. Edit the price change.Notice the error.
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