My Oracle Support Banner

Limit Number Of Decimal Digits To 2 For Percentage And Amount Values In IProcurement Requisitions to match with PO and Invoice (Doc ID 2716100.1)

Last updated on OCTOBER 15, 2020

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

Copy an existing requisition or create a new requisition with multiple distributions

In edit/submit go to the distribution level and add percentage, the application changes the quantity and amount automatically.
If allocating by dollar amount then the system does the calculation for the %.

For example the requestor may be entering a requisition for $13,526.95
They may have the following GL allocation split:
$ 3,323.26 to GL account a -> system would calculate percent = 0.24567...%
$10,203.69 to GL account b -> system would calculate percent = 0.75432...%

User wants to limit/round off the number of decimal digits in percentage to two.

This is because the requisitions are used to generate Purchase orders and the purchase orders have to be matched to Invoices.
The purchase order amount is calculated using percentage from requisitions.
The purchase orders having more than 2 decimal digits do not match the invoices which accept 2 decimal digits only.
This cause the distribution to over-match or under-match and it creates a commitment that cannot be removed.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.