My Oracle Support Banner

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

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