EAR9.2: Decimal Division By Zero Occurred and Maintenance Group Out Of Balance When Performing Row Selection. (Doc ID 1990300.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

On : 9.2 version, Maintenance Worksheet

When attempting to perform Row Selection for Write-off A Debit for multiple items the following error occurs and the Maintenance worksheet is going in OOBM error.

ERROR
-----------------------
Decimal division by zero occurred. (180,109) WS_WRK.WS_SELECT_CMD.FieldChange Name:Calc_control_amt_base PCPC:2992 Statement:48
Called from:WS_WRK.WS_SELECT_CMD.FieldChange Name:Update_list_flds Statement:117
Called from:WS_WRK.WS_SELECT_CMD.FieldChange Name:tag_item Statement:188
Called from:WS_WRK.WS_SELECT_CMD.FieldChange Statement:294

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. Navigate to Accounts Receivable > Receivables Maintenance > Maintenance Worksheet > Create Worksheet and create a new Maintenance worksheet for business unit US001.
  2. In the Reference Criteria section, select "Specific Value" for the Reference Criteria field and in the Item Reference section, insert the following values:
    • Qual Code = I, Reference = 0000678566
    • Qual Code = I, Reference = 0000678568
    • Qual Code = I, Reference = 0000678575
  3. Build worksheet.
  4. In the Row Selection section, select the "De-Select All" Choice and then hit Go.
  5. In the Item Action section, select the "Write-off a Debit" Entry Type option and the "SMALL" Reason option.
  6. In the Row Selection section, select the "Select All" Choice, then hit Go and the following error is triggered:
    • Decimal division by zero occurred. (180,109) WS_WRK.WS_SELECT_CMD.FieldChange Name:Calc_control_amt_base PCPC:2992 Statement:48
    • Called from:WS_WRK.WS_SELECT_CMD.FieldChange Name:Update_list_flds Statement:117
    • Called from:WS_WRK.WS_SELECT_CMD.FieldChange Name:tag_item Statement:188
    • Called from:WS_WRK.WS_SELECT_CMD.FieldChange Statement:294
    • 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.
  7. The correct behavior of the application should have been to populate the Type = WO and the Reason = SMALL for all the 3 lines.
  8. Click OK on the error message.
  9. Note that the first line has the box checked out and the information was populated with entry type WO and Reason SMALL, but the WO amount is still 0.00.
  10. Manually select the other 2 items. Note that the total amount from WO is the sum of the last 2 items and not the sum of all 3 items.
  11. Save changes.
  12. Change posting action to Batch Standard.
  13. Run ARUPDATE.
  14. Navigate to Accounts Receivable > Receivable Update > Correct Posting Errors > Worksheet and notice that the worksheet is in error with OOBM code.
    • Maintenance Group Out of Balance
    • Action: Verify that the sum of control base amount equals the control amount and the total count of pending items.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot post 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