R12:OIE: Why Does Trip Distance Round Up Instead Of Maintaining 2 Decimals?

(Doc ID 2384624.1)

Last updated on APRIL 10, 2018

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: 02/03/2018
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: 02/03/2018
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 as shown in the screenshot)

 


 

Solution

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