EAR9.0+: Decimal Division by Zero Error Occurred. (180,109) When Saving Maintenance Worksheet. (Doc ID 1998564.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

On : 9.1 version, Maintenance Worksheet

When attempting to save a Maintenance Worksheet the following error occurs.

ERROR
-----------------------
Decimal division by zero occurred. (180,109) WS_WRK.ITEM_ACTION.SavePostChange PCPC:7072 Statement:57
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
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create and post a foreign currency debit and credit item for the same rate type but different customers and different exchange rate.
  2. Create a maintenance worksheet for a different rate type. Make sure Reference Criteria = Specific value, Restrict to = All Customers, Match Rule = Exact Match and Currency = base currency. Enter Item References for debit and credit item.
  3. Build the Worksheet.
  4. Select debit and credit item and update Item Balance for one of the items to make it balanced.
  5. Save worksheet and error is triggered.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create a Maintenance Worksheet.

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