Is there a table that stores per diem information on already paid expense reports (Doc ID 2131557.1)

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.

Goal

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

 

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