My Oracle Support Banner

R12:OIE: Why Does Trip Distance Round Up Instead Of Maintaining 2 Decimals? (Doc ID 2384624.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Internet Expenses - Version 12.2.4 and later
Information in this document applies to any platform.
Mileage
Policy
decimals
Calculate Amount

Goal

When entering an expense report the Trip distance rounds up instead of maintaining 2 decimals. Why is this occurring? 

For example when entering an expense line for mileage, prior to selecting the Calculate button in the Details form the following information is seen:

 

Cash and Other Expenses:Details for Line 2
Expense Type: Mileage
*Start Date: DD/MM/YYYY
Number of Days: 1
*Trip Distance: 12.78 :Miles
*Vehicle Category: Company
Distance Rate: 0.241402
Reimbursable Amount: 3.14 GBP

NOTE:  12.78 miles x 0.241402 rate per mile = 3.08511756 which rounds to 3.09, not 3.14.   Note that this is prior to selecting Calculate Amount so it is an estimated value only.

Next the user selects the Calculate Amount button and sees the following:

Cash and Other Expenses:Details for Line 2
Expense Type: Mileage
*Start Date: DD/MM/YYYY
Number of Days: 1
*Trip Distance: 12.8 :Miles
*Vehicle Category: Company
Distance Rate: 0.241402
Reimbursable Amount: 3.09 GBP

Now the rate is correct.  The mileage has rounded from two decimals to one.  The form correctly shows 12.8 miles instead of 12.78 as it has rounded to one decimal place.  The rate is therefore correctly calculate as 12.8 x 0.241402 = 3.0899456 (3.09)

 

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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!


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