My Oracle Support Banner

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.


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



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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.