EEX9.2: While Adding Per Diem Line In Expense Report, Amount Is Rounded To Nearest Whole Dollar When Using Per Diem Calculation (Doc ID 3045987.1)

Last updated on SEPTEMBER 12, 2024

Applies to:

Symptoms

While using a defined calculation code to calculate 75% of the total per diem amount, when users select the expense type on Expense Report Entry page, the amount that is populated on EX_SHEET_LINE is rounded to the nearest dollar.

For example, per diem amount should be 55.50 but it is returning 56.00. 

Steps:

The issue can be reproduced at will with the following steps:

1. Setup Expense Type

Navigation :Set Up Financials/Supply Chain > Product Related > Expenses > Purchase > Expense Type > Expense Types 1

2. Create Expense Location

Navigation: Travel and Expenses > Travel and Exp Admin Center > Define Expense System > Locations and Rates > Expense Location

3. Setup Location Mapping for the Location created - click on City/County/Postal tab

4. Create Range Category

Navigation: Set Up Financials/Supply Chain > Product RelatedExpenses > Location > Per Diem Range Category

5. Create Per Diem Range

Navigation: Set Up Financials/Supply Chain > Product Related > Expenses > Location > Define Per Diem Ranges

6. Create Per Diem Calculation

Navigation: Set Up Financials/Supply Chain > Product Related > Expenses > Location > Define Per Diem Calculations

7. Complete Per Diem Amount Setup under the new expense type and location and then select “Copy Govt Active Rates”

Navigation: Set Up Financials/Supply Chain > Product Related > Expenses > Location > Define Per Diem Amounts

8. Add the calculation - on Define Per Diem Amounts page select Calculation tab

9. Create Expense Report and add the new Expense Type

Navigation: Travel and Expenses > Travel and Expense Center > Expense Reports > Create/Modify

Amount is 56 instead of 55.5

Changes

Cause

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