My Oracle Support Banner

E1: 09E: How To Run Expense Management Reports (UBE) (Doc ID 2244330.1)

Last updated on OCTOBER 31, 2018

This document covers the UBEs in Expense Management.

The Expense Report Print (R09E116) UBE prints expense reports directly from the Expense Report Review/Entry program (P09E2011).

If the History Log (data dictionary item LOGINFO) field is set to Y or 1 for any routing rules in the Expense Management Routing Rules (P09E119) application, the system creates a record in the Expense Report Routing History Log table (F09E120). The Expense Report History (R09E128) UBE is used to see the routing history of expense reports.

The Expense Reports by Manager (R09E127) UBE is designed to print only those expense reports that have an Employee ID (data dictionary item EMPLOYID) or Manager ID (data dictionary item MGRID) equal to the ID of the user running the report. Thus, managers can review their own reports, as well as those entered by their employees.

If the History Log (data dictionary item LOGINFO) field is set to Y or 1 for any routing rules in the Expense Management Routing Rules (P09E119) application, the system creates a record in the Expense Report Routing History Log table (F09E120). The Expense Report History (R09E128) UBE is used to see the routing history of expense reports.

The Open Expenses (R09E129) UBE compiles a list of unprocessed expense reports that have been submitted for processing.

Companies often have preferred supplier agreements with some vendors such as airlines, car rental agencies or hotel chains. The Expenses by Supplier Report (R09E131) UBE prints the number of expenses, the total expense amount, and the average expense amount for any preferred suppliers on expense reports. This information allows management to quickly determine if preferred suppliers are receiving the majority of a company's business.

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.