'"ORA-01476: divisor is equal to zero returned by program unit CE_CHARGES_SQL.CALC_TOTALS"' Error Occurs When Editing a Customs Entry

(Doc ID 2170410.1)

Last updated on MAY 01, 2017

Applies to:

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


In Oracle Retail Merchandising System (RMS), when attempting to edit a customs entry, the following error occurs

Steps to Reproduce:

  1. Create an item
  2. Create an import PO
  3. Ship the PO whole quantity
  4. Create a transportation record
  5. Create a customs entry
  6. Do not receive the PO
  7. Wait to reach the "not after date"
  8. The ORDAUTCL batch will close the PO and set the PO quantity = 0
  9. Enter the customs entry that was previous created in the view mode
  10. The error message will be displayed


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