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

Last updated on MAY 15, 2017

Applies to:

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

Symptoms

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.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms