When Attempting to Save a Req with "Zero price Indicator" Flag Checked ,It Throws "Decimal division by zero occurred. (180,109) " Error

(Doc ID 2409980.1)

Last updated on JUNE 12, 2018

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:-
When attempting to save a req with "Zero price Indicator" flag checked the following error occurs.

Error:-
Decimal division by zero occurred. (180,109) FUNCLIB_PM.CHANGE_REQ_LINE.FieldFormula Name:fix_dist_value_2 PCPC:72616 Statement:1449
Called from:REQ_LINE_SHIP.DISTRIB_MTHD_FLG.FieldChange Name:do_distrib_dsply_2 Statement:212
Called from:REQ_LINE_SHIP.DISTRIB_MTHD_FLG.FieldChange Statement:402

A division by zero occurred. Review the PeopleCode being executed to determine why the error occurred. Make sure that zero values are checked for and that appropriate error handling exists.


Steps To Reproduce the Issue:-
1. Navigate to Add/Update Requisitions. go to the Attributes Tab and check the Amount Only flag
2. Enter the Description, UOM and category
3. Go again to Attributes tab and deselect the amount only flag and select the "Zero Price Indicator" flag
4. Go to Distribution and change the Distribute By from Amount to Quantity and receive the error


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