My Oracle Support Banner

Error While Performing Receiver Cost Adjustment- ORA-01476: Divisor Is Equal to Zero (Doc ID 2264444.1)

Last updated on MARCH 15, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.0.7 and later
Information in this document applies to any platform.


When attempting to do a receiver cost adjustment (recctadj) in RMS for an item that was received with zero cost,the following error occurs.

Steps to reproduce:

  1. Create an item with zero cost.
  2. Create a simple pack item with zero cost containing one unit of the above item.
  3. Create and approve a purchase order for the above pack item to a single store.
  4. Ship and Receive the order.
  5. Create a receiver cost adjustment.
  6. Navigate to Finance -> receiver cost adjustment screen, set the new cost to some value (Ex 1.75) and click on Apply.
  7. Notice the error ORA-01476 is displayed.


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.