Requisition Distribution Precision Does not Accommodate High Value Line Amounts

(Doc ID 2254886.1)

Last updated on APRIL 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Requisition distribution precision does not accommodate high dollar value line amounts with small distribution amounts.

Customer has a $120,000,000 Req line (amt based) with 5 distribution lines. One of the distribution lines is $5,000.
Based on the 4 decimal precision used by the system, the $5,000 distrib line divided by the total Requisition Line of $120,000,000 gets rounded to 0.0000.
The system then displays the following error.

"Cannot distribute a line by zero quantity or zero amount (10108,8)"
"You must assign a value to distribution quantity or amount. Cannot enter a distribution line with zero quantity or zero amount"
 

STEPS
The issue can be reproduced at will with the following steps:
1 - Create amount only Requisition 120,000,000.00
2 - Split the accounting distribution into 5 lines:
  4 lines each for 29,998,750.00
  1 line for 5,000
3 - Click OK in the distribution page.
Got the error:
"Cannot distribute a line by zero quantity or zero amount. (10108,8)
You must assign a value to distribution quantity or amount. Cannot enter a distribution line with zero quantity or zero amount.”


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