Last updated on MARCH 08, 2017
Applies to:Oracle Internet Expenses - Version 12.1.2 and later
Information in this document applies to any platform.
Qn1:While we were updating the per diem rates in a few of our iExpense policies, employees were submitting expense reports with the old rates. In order to issue additional payments to employees who submitted expense reports between the time per diem rates were changing in our system, we need to find the proper per diem reductions taken on each expense type. We are unsuccessful in finding out if any reductions were taken; we have tried searching the ap_expense_report_lines_all table and specifically in these fields: num_pdm_days1, num_pdm_days2, num_pdm_days3, per_diem_rate1, erl.per_diem_rate2, per_diem_rate3, deduction_addition_amt1, deduction_addition_amt2, deduction_addition_amt3, num_free_breakfasts1, num_free_lunches1, num_free_dinners1, num_free_accommodations1, num_free_breakfasts2, num_free_lunches2, num_free_dinners2, num_free_accommodations2, num_free_breakfasts3, num_free_lunches3, num_free_dinners3, num_free_accommodations3.
Is there a table that stores per diem information on already paid expense reports
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms