My Oracle Support Banner

R12: OIE: Why Does Auditing Expense Reports With End-dated Expense Types Cause Inconsistent Data? (Doc ID 2380427.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
End Dated
Expense Type


On : 12.1.3 version, Expenses Audit and Receipt Management

Why does Auditing Expense Reports with End-dated Expense Types cause inconsistent data?  The following scenario describes the issue:

1) Create a new Template Name:
End Date Test
Expense types and Categories
HOSPITALITY Miscellaneous
OTHER Miscellaneous

All have Justification Required: Only with Violation
Receipt Required for: Cash Only
Required About: 0.00
Apply Receipt Rules to Negative Expense Lines: Checked

2) Ensure the Grace Period profile is set to 0 days.

3) As XXXX create one line expense report for template End Date Test with expense type Meals (i.e. not the 1st expense type on the template)
for XXXX for today's date (example 8/24/27) and submit:
Expense report number XXX for 10.00 has been submitted to XXXXX for approval.

Expense Report XXX
Cash Expenses

Date Receipt Amount Expense Type Justification Merchant Name Original Receipt Required Receipt Missing Reimbursable Amount (USD) Details
24-Aug-2017 10.00 USD Meals Test for End Date Expense Type Carrabas [Receipt Required] 10.00

4) Log in as XXXX and approve the report.
5) Navigate to Payables Manager: Setup=>Invoices=>Expense Template.
6) Query template End Date Test"
7) End Date expense type "Meals" with 8/24/2017 and Save.
8) Note that Grace Period profile option is set to 0 days.
9) The following day (or in this case, today, 8/25/2017) log into SSWA as XXXX and navigate to Audit Manger.
10) Query expense report XXX
11) Under Verify Expenses line 1 shows as Meals. Select the Details icon.
12) Details form appears, expense type changes automatically to Hospitality.
13) Select Return.
14) Verify Expenses form now incorrectly still shows expense type of Hospitality, not Meals.



To view full details, 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 a vibrant support community of peers and Oracle experts.