R12: OIE: Expense Report Per Diem Amount Calculation is Incorrect
(Doc ID 2980917.1)
Last updated on OCTOBER 17, 2023
Applies to:
Oracle Internet Expenses - Version 12.2.1 and laterInformation in this document applies to any platform.
Symptoms
Per Diems not Calculating Breakfast and Lunch for First Period.
Steps to Reproduce
-----------------------
(N) Iexpense > Create Expense Report > Cash and Other Expenses > Per Diem Expenses > Enter Expense Line details > Click Details tab
Enter details Expense Type, Start Date, Start Time, End Date and End Time > Click Generate Per Diem
| Start Date and Time | End Date and Time | Number of Hours | Per Diem Amount | Meals Deduction | Reimbursable Amount |
| 16-10-2023 00:00:00 | 16-10-2023 23:59:59 | 24 | 66.60 | 66.60 | |
| 17-10-2023 00:00:00 | 17-10-2023 23:59:59 | 24 | 148.15 | 148.15 | |
| 18-10-2023 00:00:00 | 18-10-2023 17:00:00 | 17 | 71.55 | 71.55 |
As per Per diem Setup Breakfast : 38.75, Lunch : 42.8 and Dinner : 66.6
| Line | Time Intervals | Rate |
| 1 | Between 0 and 07:01 | 148.15 |
| 2 | Between 07:02 and 13:01 | 109.4 |
| 3 | Between 13:02 and 19:01 | 66.6 |
| 4 | Greater Than 19:01 | 66.6 |
Expected Reimbursement Amount are as below
| Start Date and Time | End Date and Time | Number of Hours | Per Diem Amount | Meals Deduction | Reimbursable Amount |
| 16-10-2023 00:00:00 | 16-10-2023 23:59:59 | 24 | 148.15 | 148.15 | |
| 17-10-2023 00:00:00 | 17-10-2023 23:59:59 | 24 | 148.15 | 148.15 | |
| 18-10-2023 00:00:00 | 18-10-2023 17:00:00 | 17 | 81.55 | 81.55 |
For first period reimbursement for breakfast, lunch and dinner (148.15) must be given as user is starting journey at 00:00 hours of first day.
But with current calculation reimbursement for only dinner (66.6) is calculated.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |