Error ORA-01476: Divisor Is Equal To Zero When Trying To Cancel A $0 "No Charge" Requisition (Doc ID 2759864.1)

Last updated on MARCH 15, 2022

Applies to:

Symptoms

On : 12.2.7 version, Requisition

When attempting to cancel a $0 requisition (Cost Constraint = $0)
the following error occurs.

ERROR
-----------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
 PRD.REQUISITION_LINE_ID,
 PRD.DISTRIBUTION_ID,
 PRD.DISTRIBUTION_NUM,
 fnd_flex_ext.get_segs('SQLGL','GL#', GSB.CHART_OF_ACCOUNTS_ID, PRD.CODE_COMBINATION_ID) AS CHARGE_ACCOUNT,
DECODE(PRL.MATCHING_BASIS, 'AMOUNT', PRD.REQ_LINE_AMOUNT, PRD.REQ_LINE_QUANTITY*PRL.UNIT_PRICE) AS AMOUNT,
DECODE(PRL.MATCHING_BASIS, 'AMOUNT', PRD.REQ_LINE_AMOUNT/PRL.AMOUNT*100,
PRD.REQ_LINE_QUANTITY/PRL.QUANTITY*100) AS PERCENTAGE,
PRD.REQ_LINE_QUANTITY AS QUANTITY,
decode(prl.matching_basis, 'AMOUNT',PRD.REQ_LINE_CURRENCY_AMOUNT,PRD.REQ_LINE_QUANTITY*PRL.CURRENCY_UNIT_PRICE) AS CURRENCY_AMOUNT,
PRL.CURRENCY_CODE
FROM
 PO_REQ_DISTRIBUTIONS PRD,
 PO_REQUISITION_LINES PRL,
 GL_SETS_OF_BOOKS GSB,
 FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE
PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID AND
FSP.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID) QRSLT WHERE :1 = REQUISITION_LINE_ID
.
.
.
## Detail 0 ##
java.sql.SQLDataException: ORA-01476: divisor is equal to zero


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create  Purchase Requisition with  price $0 (Cost Constraint = “No Charge”)
2. Approve
3. Now try to cancel

Changes

Cause

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