My Oracle Support Banner

Receiving CT-e Rejected in EDI Validation with Error ORA-01476: Divisor is Equal to Zero (Doc ID 2642321.1)

Last updated on MARCH 25, 2020

Applies to:

Oracle Retail Fiscal Management - Version 14.1.3.2 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Fiscal Management (RFM) version 14.1.3.2

A PO with 2 simple packs, where each simple pack have freight expense at simple pack level. A NF PO was received without freight expenses included. When CT-e expenses was received via IRL, CT-e is being Rejected in EDI Validation: Erro ORA-1476: divisor is equal to zero retornado pela unidade de programa FM_FISCAL_VALIDATION_SQL.CALC_UNIT_ITEM_COST_COMP.

Steps to Recreate:

  1. Create 2 simple pack with (ELC) freight expenses at Simple pack level
  2. Create PO with 2 Simple Pack Item (make sure ORDLOC_EXP is populate with ELC after PO approve)
  3. Receiving NF PO through IRL
  4. PO physical and fiscal receiving finished
  5. Receiving CT-e and link to PO NF
  6. Check IRL monitor with status "REJECTED in EDI Validation"
  7. Check IRL error screen message: "Error ORA-1476: divisor is equal to zero returned by program unit FM_FISCAL_VALIDATION_SQL.CALC_UNIT_ITEM_COST_COMP."

Business Impact: CT-e NF is not able to be received to add item cost.

Cause

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
Symptoms
Cause
Solution
References


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