11i: OIE: How is Cumulative Mileage Stored In Table AP_WEB_EMPLOYEE_INFO_ALL ? (Doc ID 360631.1)

Last updated on MARCH 29, 2021

Applies to:

Goal

An expense report is entered and approved for, say, 100 miles.
When the employee logs on to the Preferences page, the cumulative mileage is shown correctly as
100 miles.
However, the cumulative mileage stored in the table AP_WEB_EMPLOYEE_INFO, is 160.9 rather than 100.



What unit of measure is used in this table ? Is it converted to kilometers ?
Is the preferences form automatically converting it back to miles when it displays it ?

Solution

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