Requisition Distribution Precision Does not Accommodate High Value Line Amounts
Last updated on JANUARY 08, 2018
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.
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"
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.”
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