This chapter covers the following topics:
Internet Expenses Setup provides the administrator with the self-service pages necessary to manage the setup of Internet Expenses. To use Internet Expenses Setup, you must have access to the Internet Expenses Setup and Administration responsibility. See: Assigning Responsibilities to Users for more information.
Internet Expenses Setup is organized into the following areas. Each area is represented by a tabbed region:
Accounting
The Chart of Accounts pages let you set up your charts of accounts for expense allocations. See: Expense Allocations.
Context
Use the page in the Context tabbed region to maintain the list of operating units that require Internet Expenses definitions.
See: Defining Operating Units.
The first time you log in using the Internet Expenses Setup and Administration responsibility, Internet Expenses displays the Context tabbed region. Subsequent logins display the Policy tabbed region, Schedules subtab.
Policy
Use the pages in the Policy tabbed region to set up online policy compliance and per diem and mileage rates. You can perform these setup activities:
Schedules: Create rate and policy schedules for your employees to use when they submit expense reports. See: Setting Up Schedules in Oracle Internet Expenses for more information.
Expense Fields: Set up expense fields to capture additional information on expense reports. See: Setting Up Expense Fields for more information.
Exchange Rates: Set up exchange rate definitions to validate the exchange rates that employees enter on their expense reports for foreign currency receipts. See: Setting Up Exchange Rates Behavior for more information.
Duplicate Detection: Set up duplicate detection rules and help customers by giving a snapshot of the already created rules used to detect duplicate expense claims. See: Setting Up Duplicate Detection Rules for more information.
General
Use the General tab to perform these setup activities:
Locations: Set up the locations that you use for expenses reporting. See: Setting Up Locations for more information.
Future Expenses: Determine how expense reports that contain dates in the future should be handled. See: Defining Future-Date Tolerances for more information.
Approval Notes Languages: Define the language for communications that are attached to the expense report. See Defining Approval Notes Languages for more information.
Contact Us: Determine the behavior of the Contact Us global link. See: Setting Up Contact Us.
Tax
Use the Tax tabbed region to set up additional fields on detailed expense lines to capture merchant information for VAT and other reporting purposes. See: Setting Up Merchant Fields for more information.
Audit
Use the Audit tabbed region to set up Audit Automation and Receipt Management in Internet Expenses. See: Setting Up Audit Automation and Receipt Management for more information.
Credit Cards
Use the pages in the Credit Cards tabbed region for setup related to your corporate credit cards. You can perform these setup activities:
Use Policy: Set up polices to encourage users to use their corporate credit cards and to submit corporate credit card transactions in a timely fashion. See: Setting Up Credit Card Policies for more information.
Card Programs: Perform setup tasks that relate to the use of your Payables card programs with Internet Expenses. See: Setting Up Credit Card Expense Mapping and Setting Up Credit Card Data File Download for more information.
Requests
Use the Requests tab to schedule and view requests.
Upload Rates: Use the Upload Rates page to create or update per diem and policy schedules. See Creating Schedules through the Upload Process.
View Requests: Use View Requests to view the status of all the concurrent programs that you have submitted.
Internet Expenses Administration provides the administrator with the self-service pages necessary to manage the administration of Internet Expenses. To use Internet Expenses Administration, you must have access to the Internet Expenses Setup and Administration responsibility. See: Assigning Responsibilities to Users for more information.
Internet Expenses Administration contains the Credit Card tab.
Use the Credit Card tabbed region to administer your credit card programs. In the Credit Card Transactions page you can view the credit card transactions that were uploaded to the database. See: Credit Card Transaction Administration. In the New Credit Card Accounts page you can view the new accounts that were created during credit card upload. Use this page to activate and assign cards to employees. See: New Credit Card Account Administration.
Note: The values displayed in the page is not restricted by Operating Unit. It will show all the values for the fields.
Internet Expenses also provides enforcement, audit, and reporting functionality for policy violations.
Internet Expenses provides four different options to enforce your policies:
By setting up schedules. See: Setting Up Schedules in Oracle Internet Expenses.
By setting up credit card usage policies. See: Setting Up Credit Card Policies.
By setting up exchange rate behavior. See: Setting Up Exchange Rate Behavior.
By setting up receipt required behavior at operating unit and optionally overriding rules at expense item level or only at expense item level. See: Receipts Rule Sets and Defining Expense Report Templates.
The following table describes the violation types defined for Internet Expenses, including setup navigation, affected expense categories, and whether there is a monetary violation:
Violation | Setup Navigation | Expense Categories Affected | Monetary Violation |
---|---|---|---|
Airfare | Policy: Schedules | Airfare | No |
Credit Card Required | Credit Cards: Card Usage | All cash expenses except Mileage and Per Diem | No |
Daily Limit | Policy: Schedules | Car Rental, Accommodations, Miscellaneous | Yes |
Daily Meals Sum Limit | Policy: Schedules | Meals | Yes |
Exchange Rate Limit | Policy: Exchange Rates | All except Mileage and Per Diem (cash and other expenses only) | Yes |
Individual Occurrence Limit | Policy: Schedules | Meals | Yes |
Number of Days | Policy: Schedules | Miscellaneous | No |
Receipt Missing | Receipt Rule Set or Expense Report Template in Oracle Payables | All except Mileage and Per Diem. (Applicable only when original receipts are missing.) | No |
Note: You can define tolerances for monetary violations. See: Creating Policy Schedules.
Use the Internet Expenses Setup responsibility to set up your policy schedules and rate schedules for expenses reporting. Policy schedules let you enforce the policy guidelines that your company follows whereas rate schedules just calculate the expense amounts.
The schedules that you create provide rules, thresholds, and guidelines for calculating and validating expense reports prepared by your employees. You can set up one or more schedules for each of these expense categories:
Policy Schedules
Accommodations
Airfare
Car Rental
Meals
Miscellaneous
Rate Schedules
Mileage
Per Diem
The basic steps required to create and use schedules are:
Define prerequisites. This step is required only for manually created schedules.
Create schedules manually or through the upload process and activate them.
If required, implement client extensions for per diem and mileage schedules.
Select the appropriate expense category on the expense report template.
Assign the schedule to the expense type.
When a self-service user enters an expense type assigned to one of these expense categories, Internet Expenses uses the active schedule assigned to the expense type to make these calculations:
Policy schedules: Compare the value entered by the user to the existing policy guidelines and thresholds, and either allow the entered value or display an error or warning message to change the entered value.
Rate schedules: Determine the applicable rate to use, and calculate the expense amount using this rate.
For more information on how schedules, expense categories, and expense types are related, see: Defining Expense Report Templates.
There is setup information common to many schedules, such as locations, reimbursement currencies, and employee roles. In addition, schedules require information specific to its expense category, such as vehicle type for mileage schedules and meal allowances for meals schedules.
For detailed information about creating rate and policy schedules, see:
Create policy schedules for your employees to use when they submit expense reports. Policy schedules contain the rules, rates, and allowable tolerances to use for a given expense category and time period. You can define policy schedules that reflect the guidelines of your company, or policy schedules that conform to the statutory requirements of a country where you operate. Because you define policy schedules at the site level, you can create different schedules with the guidelines appropriate to each division or sector of your operations.
As a self service user enters items in an expense report, Internet Expenses compares the values entered to the values and value ranges specified by the active policy schedule. If there is a policy violation, based on the profile option setup, the user may receive a message and must either change the value or enter a justification for the existing value. Internet Expenses provides a series of alerts to the approvers in your company for all expense reports submitted with policy violations.
A policy schedule contains one or more schedule periods. Because policy guidelines and statutory requirements change frequently, you can create different time periods and modify the rates and values of a policy schedule for each period. Internet Expenses uses the policy guidelines associated with the applicable period to validate expense reports. When you create a new schedule, you can:
Enter a start date before the system date, to make the schedule available for expense reporting over all applicable periods. For example, a schedule you create in February 2003 for the year 2003 should have a start date of 01-Jan-2003.
Assign the new start date the day after the end date of the old schedule, when creating a new schedule to replace an old one. Users can then assign the new schedule to an expense report template once the system date is the same as or later than the start date of the new schedule.
When you apply an end date to a policy schedule, Internet Expenses automatically applies the same end date to the open period within the schedule. If the schedule was assigned to expense types, Internet Expenses prompts you to automatically apply the same end date to each expense type. (If any of these expense types are included in an itemization setup, then they are no longer available for itemization.) Once the system date is past the end date plus grace period, an end-dated schedule is no longer available in the Expense Report Templates window. See: Defining Expense Report Templates.
You can create policy schedules for the expense categories Accommodations, Airfare, Car Rental, Meals, and Miscellaneous and assign them to each expense item that requires policy compliance. Expense reporting for mileage and per diem requires the use of rate schedules. See: Rate Schedules.
Note: Meals and accommodations schedules can also be created by uploading per diem rates provided by the U.S. government. See Creating Schedules through the Upload Process.
Business rules determine the information that policy schedules use to validate expense reports. A policy schedule consists of line records based on the combination of values belonging to each rule. For example, if a schedule uses the Locations rule with three locations and the Roles rule with three employee roles, there is a separate line record for each combination of role and location. If an expense report violates any line rule record, Internet Expenses responds according to the setting of the OIE: Enable Policy Validations profile option. See: Specifying Values for Internet Expenses Profile Options.
The business rules for policy schedules are:
Currency
Locations
Roles
Tolerance Limits
Daily Limits
Number of Days (Miscellaneous category only)
The Currency rule is a mandatory rule for all categories except the Airfare category, which does not use this rule. This rule governs the activity of reimbursement currencies on a schedule. The choices are Single Reimbursement Currency, Multiple Reimbursement Currencies, and Location Currency Rates. A company that wants to create one schedule per operating unit may prefer the Single Reimbursement Currency rule. A company that wants to create one schedule only may prefer the Multiple Reimbursement Currencies rule. The Location Currency Rates rule is of particular interest to those customers that want to define their business rules in the currency of the location of the transaction, as opposed to the reimbursable currency. In this context, one schedule can theoretically be used by all employees, regardless of their reimbursement currency preference.
Single Reimbursement Currency: A single currency is used for the entire schedule. If you select this rule, you must choose one of these options on the Business Rules page:
Allow Rate Conversion: If you choose this option, Internet Expenses converts the schedule rates to the reimbursement currency selected by users during expenses entry. This conversion is based on the rates defined in the GL Daily Rates table using the exchange rate type defined in the Payables Options window. See: Establishing Multiple Currencies Setup.
No Rate Conversion: If you choose this option, then the reimbursement currency must be the same as the schedule currency. If not, then policies are not enforced on the expense report and the system cannot calculate per diem and mileage rates.
Multiple Reimbursement Currencies: You can select multiple reimbursement currencies on the Business Rules page for this schedule, and then define schedule rates applicable to each currency. This rule is useful, for example, if you want to create one rate schedule that is shared by many business units in different countries.
When users enter their expense reports, the reimbursement currency must match one of the currencies used on the schedule. If there is no match, then the rate policies defined on a policy schedule are not enforced. For mileage and per diem rate schedules, Internet Expenses cannot determine a reimbursement rate.
Location Currency Rates: You define rates based on the currency of the location to which users travel. If you select this rule, you must select a currency for each schedule record on the Schedule Details page. This rule is useful, for example, if you want to define a single policy or rate amount for each location that is used by your entire global operations. For example, if you define 100 USD as the rate for travel to New York, then this rate applies to all users who travel to New York.
During expenses entry, Internet Expenses converts the policy schedule location amount into the reimbursement currency when the currencies are different. The policy allowable amount is then recorded in the reimbursement currency. If exchange rates do not exist between the policy currency and reimbursement currency, the functional currency is used to "triangulate" the rates.
To illustrate, assume the policy schedule location currency is USD, the reimbursement currency is EUR, and the functional currency is GBP. If no exchange rates exist between USD and EUR, the system will then look for exchange rates between both the schedule currency and functional currency, and reimbursement currency and functional currency. If rates are found for both, then policy violation detection can occur. If rates are not found for both, then there will be no check for policy compliance.
Note: Internet Expenses does not provide validation on the location and currency combinations you define on a schedule.
The Location rule takes into account travel locations to determine valid rates. You can define individual rates for specific locations, and a single rate for all locations not specified in the schedule. Use the Search function to create a list of locations for the schedule.
For per diem rate schedules, a rate is established based on the location selected by users. This location rule is not available for mileage rate schedules. Also see Setting Up Locations.
The Roles rule takes into account the self service user's role in your company to determine valid rates. You can define individual rates for specific employee roles, and a single rate for all roles not specified in the schedule. Use the Search function to create a list of roles for the schedule.
The Roles rule is a mandatory rule for the Airfare category. Also, you cannot define rates for the Airfare category.
Note: Because the Employee Roles rule often uses a business group to identify employee roles, use of this rule can make a schedule business group-specific.
The Tolerance Limits rule allows for a tolerance level above the amount limits that users can enter on expense reports. This rule provides two options:
Individual Lines - Set different tolerance levels for individual lines.
Single Period - Set a tolerance level for the entire schedule period.
If the OIE: Enable Policy profile option is set to Prevent Submission, then the user cannot submit an expense report when the reimbursable amount exceeds the amount limit plus the tolerance. If the profile option is set to Prevent Submission, but tolerances are not defined, policy violations are still detected and recorded. In addition, users are warned of any policy violations prior to submitting expense reports.
If the OIE: Enable Policy profile option is set to either Warn Users or Inform Approvers, then any tolerance limits you defined are not used.
The Tolerance Limit rule is not used with airfare schedules.
The Daily Limits rule is an embedded rule in the Accommodations, Car Rental, Meals, and Miscellaneous categories. You can set up the maximum permitted amount per day using this rule.
For the Meals category, the rule is called Meal Limits and includes special rules for calculating limits. You have the following options for the Meal Limits rule:
Individual Meal: Define policy limits for each individual meal.
Daily Sum: Define policy limits for the total of all meals incurred per day.
Both: Define both individual and daily sum policy limits.
If you do not select the Daily Limits rule, daily limits are still enabled on the Schedule Details page, with a default of Daily Sum. If the expense report contains a value for the number of attendees, then Internet Expenses divides the meal amount by the number of attendees and treats the result as a single value for validation against the policy schedule. The number of attendees is not available for entry when the daily sum option is used. For more information, see: Setting Up Expense Category Fields.
If more than one Meals policy schedule is assigned to the same expense report template, Internet Expenses validates the sum of meal totals against the schedule with the lower value. For example, you assign dinner to Schedule A with a Daily Sum Limit of $100 and lunch to Schedule B with a Daily Sum Limit of $75. Internet Expenses validates the sum of dinner and lunch against Schedule B, for $75.
The Number of Days rule applies to the Miscellaneous category only. This rule prevents users from reporting an expense if the number of days entered on the expense report is less than the schedule number of days.
Set up one or more policy schedules and schedule periods for each expense category that you require for employee expense reporting. The task flow for setting up a policy schedule is similar for all expense categories except Airfare.
See: Navigating the Schedules Setup for information about using the Internet Expenses Setup pages to create policy schedules.
See: Setting Up a New Airfare Policy Schedule for information about creating a policy schedule for the Airfare category.
Prerequisites
Before you can set up policy schedules, you may need to complete one or more of these tasks:
Define business groups, job roles, employee positions, and employee grades in Oracle Human Resources.
Set up Oracle Payables for expense reporting. See: Setup Steps in Oracle Payables.
Set up locations. See: Setting Up Locations.
To set up a new policy schedule:
Log in to Oracle Applications with the user name and password appropriate for the installation.
Select the Internet Expenses Setup responsibility for the applicable site.
Choose the expense category to create the schedule that you want.
Click the Create New Schedule button to navigate to the General Information page.
Enter a Schedule Name and Description, and a Start Date for the schedule.
You may want to use a schedule name that identifies the usage of this particular schedule.
You can enter a Start Date prior to the system date in order to make this schedule available for expense reports over the prior periods that apply to the schedule.
Select the Currency Rule and the Optional Rules to use for this schedule.
Click Next to navigate to the Business Rules page.
Internet Expenses displays the schedule header information and the rules that you selected. See: Business Rules for Policy Schedules for an explanation of each rule.
Select the values that you want for each rule, then click Next to navigate to the Schedule Periods page. See: Search Function.
Internet Expenses displays the schedule header information and a line record for the first schedule period.
Enter a Period Name and Start Date. Internet Expenses defaults the schedule start date as the read-only start date for the first period. You must enter a start date for subsequent periods.
Define periods that relate to the type of schedule you are creating. For example, you can define annual periods for fixed expenses, or create seasonal periods that reflect seasonal price fluctuations, such as for hotels. If you want to duplicate seasonal periods, ensure that you duplicate them in the same order that they were originally defined.
Do not allow gaps or overlaps between periods. To create a set of periods with continuous date sequences, you can create a new period or use the Duplicate icon to copy the periods and enter the updates that you want.
Click the Details icon to navigate to the Period Details page to enter the rate for each line record.
By default, Internet Expenses displays all records. You can use the Search function to display the records that you want.
If this is a Miscellaneous schedule, enter a Minimum Number of Days.
This value specifies the minimum number of days that must be reported on an expense line to qualify for declaring miscellaneous expenses.
Enter the appropriate values for each line record. You can use the Mass Updates button to apply the same percentage to selected records.
Click Return to save your work and return to the Schedule Periods page.
Click Activate to activate the schedule.
Define expenses report templates, and assign expense categories and policy schedules to expense types. See: Defining Expense Report Templates.
Set up airfare policy schedules to determine the class of air ticket that your employees can purchase. The setup for airfare policy schedules uses the Employee Roles rule to assign a specific ticket class to each employee role. Internet Expenses creates an “All Other” record to assign a ticket class to all roles not specified in the schedule.
You assign ticket class assignments at the schedule period level. You can create additional period records and change individual ticket assignments according to your company requirements.
Prerequisites
Before you can set up policy schedules, you may need to complete one or more of these tasks:
Define business groups, job roles, employee positions, and employee grades in Oracle Human Resources.
Set up Oracle Payables for expense reporting. See: Setup Steps in Oracle Payables.
Set up locations. See: Setting Up Locations.
To set up a new airfare policy schedule:
Log in to Oracle Applications with the user name and password appropriate for the installation.
Select the Internet Expenses Setup responsibility for the applicable site.
Navigate to the Airfare expense category.
Click the Create New Schedule button to navigate to the General Information page.
Enter a Schedule Name and Description, and a Start Date for the schedule.
Use the Search Function to create a list of employee roles for this schedule, then click Next to navigate to the Schedule Periods page.
Enter a Period Name and Start Date.
Click the Details icon to navigate to the Period Details page.
Select the Domestic and International Class of Ticket that you want for each employee, and the ticket class assignments to use for All Other employees.
Click Activate to activate the schedule.
Save your work.
Assign the Airfare expense category and policy schedules to expense types. See: Defining Expense Report Templates.
You can modify the business rule assignments to a policy schedule until you activate the schedule. Once you activate a schedule and assign it to an expense item on an expense template, you cannot add or remove the business rules on a schedule.
You can apply end dates to rules records for Multiple Currencies, Locations, and Employee Roles. When the system date passes the end date plus grace period, Internet Expenses sets all schedule records that use end-dated rule values to the status Inactive. You can view the status of individual schedule records by clicking the History icon for a schedule or schedule period.
A rate schedule contains the rules and rates for calculating the reimbursable amounts for mileage and per diem. The Cash and Other Expenses page provides self service users with separate sections for entering and calculating mileage and per diem expenses. Internet Expenses adds these amounts to the user's credit card and receipt-based expenses to provide a total for an expense report.
You can define rate schedules that reflect the guidelines of your company, or rate schedules that conform to the statutory requirements of countries that your employees visit. Because you define rate schedules at the site level, you can create different schedules with the guidelines appropriate to each division or sector of your operations.
Business rules determine the information that rate schedules use to calculate rates for mileage and per diem. A rate schedule consists of line records based on the combination of values belonging to each rule. For example, if a per diem rate schedule uses the Locations rule with three locations and the Time-Based Entry rule with four time intervals, the schedule calculates a different per diem rate depending upon the applicable combination of location and time interval that the user enters on the expense report.
When you create a new rate schedule, it is recommended to enter a start date prior to the system date, in order to make your new schedule available for expense reporting over the prior periods that apply to the schedule. If the schedule was assigned to expense types, Internet Expenses prompts you to automatically apply the same end date to each expense type. Once the system date is past the end date plus grace period, an end-dated schedule is no longer available in the Expense Report Templates window. See: Defining Expense Report Templates for more information.
Create mileage rate schedules for your employees to use when they submit expense reports. A mileage rate schedule can take into account distance traveled, type and category of vehicle, type of fuel, and the number of passengers.
The business rules for mileage rate schedules are:
Currency
Roles
Passengers
Distance Thresholds
Vehicle Categories
Vehicle Types
Fuel Types
Additional Rates
The Per Diem Type controls the availability of Free Meals and Free Accommodations rules.
The Currency rule is the only mandatory rule for rate schedules. This rule determines the way in which Internet Expenses chooses a currency for the calculation of reimbursable amounts. See: Creating Policy Schedules.
The Roles rule takes into account the self service user's role in your company to determine valid rates. You can define individual rates for specific employee roles, and a single rate for all roles not specified in the schedule. Use the Search Function to create a list of roles for the schedule.
The Passengers rule assigns a rate to use for each passenger in the vehicle (other than the driver). The calculated amount becomes part of the reimbursable amount according to this formula:
(mileage rate * distance) + ((rate per passenger * number of passengers) * distance) + (sum (rate for each additional rate type selected * distance)) = reimbursable amount
You can define a single passenger rate for the entire period or a different passenger rate for each line record. The passenger rate can be a fixed amount or a percentage of the mileage rate. The maximum number of passengers available for selection in expense reports is limited to 10.
Note: If you define passenger rate as a single value at the period level, you must choose Single Reimbursement as the Currency rule for the schedule.
The Distance Thresholds rule uses distance traveled to determine the reimbursable rate. This allows you, for example, to apply a different rate to an employee who travels under 100 miles to employees who regularly travel several thousand miles in the same time period.
You can select one of two options to indicate how distance threshold should be used for mileage rate calculation.
Per Period: Threshold is applied to the distance traveled in the entire period.
The schedule periods determine the periods of distance accumulated. Internet Expenses displays the current and two prior periods of distance data on the employee's Expenses Preferences page.
Per Trip: Threshold is applied to the distance traveled in a trip.
Each mileage expense line is considered as a trip. Accumulated mileage does not have any effect on the rate.
You create a set of intervals with designated mileage thresholds, and assign the rate to use for each interval. The value that you enter becomes the threshold for the first interval. This table displays an example:
Thresholds Entered | Intervals Created |
---|---|
3000 | 2 intervals: the first up to and including 3000, and a second interval greater than 3000. |
100, 1000, 5000 | 4 intervals: the first up to and including 100; the second greater than 100 and up to and including 1000; the third greater than 1000 and up to and including 5000; the fourth greater than 5000. |
Note: You can only have one rate schedule in use per operating unit at any given time that makes use of the Distance Thresholds rule. If you want to create and apply a new rate schedule that makes use of Distance Thresholds, you must disable the previous schedule by applying an end date.
Note: Once a Distance Threshold is reached, adjustments to the expense report where the threshold was reached is only done once the report has completed the Audit process in the workflow.
The Vehicle Categories rule determines which vehicles are available for mileage reimbursement and the rate to use for each vehicle. Internet Expenses provides the categories Personal (employee-owned), Business (company-owned), and Rental (rented or leased). You can define additional categories in the Lookups window. See: Defining Payables Lookups for Oracle Internet Expenses. You can also specify for each category if the vehicle type and fuel type are required fields.
The Vehicle Types rule determines which types of vehicle and vehicle engine sizes are available for mileage reimbursement and the rate to use for each type. Internet Expenses includes a number of standard vehicle types, such as cars, vans, and motorcycles. You can define additional vehicle types in the Lookups window. See: Defining Payables Lookups for Oracle Internet Expenses.
The Fuel Types rule determines which fuels used in vehicles are available for mileage reimbursement and the rate to use for each fuel. Internet Expenses includes a number of standard fuel types, such as gasoline, diesel, and electricity. You can define additional fuel types in the Lookups window. See: Defining Payables Lookups for Oracle Internet Expenses.
Note: If you enable vehicle or fuel types rules, you may want to ensure that your use of vehicle attributes is consistent across all schedules for the same operating unit or expense report template. Otherwise the defaults that users define on their Expenses Preferences pages may not work in all cases.
The Additional Rates rule determines which rate types are available for mileage reimbursement, and the rate to use for each type. The calculated amount becomes part of the reimbursable amount according to this formula:
(mileage rate * distance) + ((rate per passenger * number of passengers) * distance) + (sum (rate for each additional rate type selected * distance)) = reimbursable amount
In some countries, additional amounts are paid over the base mileage rate based on certain criteria. For example, if the user carries heavy equipment in the vehicle, the user is reimbursed an additional amount over the base mileage rate. You can define the rates for each combination of additional rate type and other selected rules.
Set up one or more mileage rate schedules and schedule periods that you require for employee expense reporting.
Prerequisites
Before you can set up mileage rate schedules, you may need to complete one or more of these tasks:
Define business groups, job roles, employee positions, and employee grades in Oracle Human Resources.
Set up Oracle Payables for expense reporting. See: Setup Steps in Oracle Payables.
To set up a new mileage rate schedule:
Log in to Oracle Applications with the user name and password appropriate for the installation.
Select the Internet Expenses Setup responsibility for the applicable site.
Navigate to the Mileage expense category.
Click the Create New Schedule button to navigate to the General Information page.
Enter a Schedule Name and Description, and a Start Date for the schedule.
You may want to use a schedule name that identifies the usage of this particular schedule.
You can enter a Start Date prior to the system date in order to make this schedule available for expense reports over the prior periods that apply to the schedule.
Select Miles, Swedish Miles, or Kilometers as the Distance Unit of Measure to use for the schedule.
Select the Currency Rule and the Optional Rules to use for this schedule.
Click Next to navigate to the Business Rules page.
Internet Expenses displays the schedule header information and the rules that you selected. See: Business Rules for Rate Schedules for an explanation of each rule.
Select the values that you want for each rule, then click Next to navigate to the Schedule Periods page. See: Search Function.
Internet Expenses displays the schedule header information and a line record for the first schedule period.
Enter a Period Name and Start Date. Internet Expenses defaults the schedule start date as the read-only start date for the first period. You must enter a start date for subsequent periods.
Do not allow gaps or overlaps between periods. If you want to create a set of periods with continuous date sequences, you can create a new period or use the Duplicate icon to copy the periods and enter the updates that you want.
Click the Details icon to navigate to the Period Details page to enter the rate for each line record.
By default, Internet Expenses displays all records. You can use the Search Function to display the records that you want.
If you selected the Passengers rule, enter the passenger rates.
If you selected additional rates, enter the rate for each rate type combination. Additional rates are shown in a separate table below the mileage rates.
Enter a value for each line record. You can use the Mass Updates button to apply the same percentage to selected records.
Click Return to save your work and return to the Schedule Periods page.
Click Activate to activate the schedule.
Assign the Mileage expense category and rate schedules to expense types. See: Defining Expense Report Templates.
Companies implementing Internet Expenses during a financial or tax year must upload accumulated mileage for their employees from their legacy systems because, in some countries, this mileage can cause a difference in rates and tax consequences. Use the Upload Accumulated Mileage program to upload accumulated mileage into Internet Expenses. The program accepts a semicolon-delimited ASCII text file in the following format:
Description
Employee Number
Accumulated Mileage
The Upload Accumulated Mileage program converts accumulated mileage to kilometers, derives the person ID from Oracle HRMS using the employee number, and creates a row for each person in the input file.
Prerequisite steps for enabling users:
Create a mileage schedule and assign it to a template.
Run the Upload Accumulated Mileage program.
Assign an expense reporting responsibility to users.
Warning: The Upload Accumulated Mileage program is intended only to support mid-year implementations. Do not use this program after the implementation is completed and Internet Expenses is enabled for use. See: Upload Accumulated Mileage program, Oracle Payables User's Guide.
File Name: Enter the filename including the full file path.
The file must reside in a database directory defined for PL/SQL file I/O. See: My Oracle Support Knowledge Document 2525754.1, Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2.
Organization: Enter an organization to limit the program run to this operating unit only. Leave the field blank to run the program for all organizations.
Period Date: Enter all active periods in the mileage schedule with distance threshold rules available to the selected organization through expense templates.
Distance Unit of Measure: Enter the unit of measure for distance. The options are Miles and Kilometers.
Create per diem rate schedules for your employees to use when they submit expense reports. A per diem rate schedule can take into account travel locations, rates per unit of time, and free meals and accommodations. Per diem rate schedules also use the currency and employee role business rules.
You can define two types of per diem schedules based on schedule type.
Per Diem schedules: Per diem schedules let you define the eligibility rules and the applicable per diem rates. If free items are received, Internet Expenses adds or deducts the applicable amounts to the per diem rate to calculate the reimbursable amount.
To create per diem schedules, select Per Diem as the schedule type. The per diem type defines the rate components included in the per diem rate and also controls the free item rules available for use. The per diem type can be Accommodations, Meals, Meals and Accommodations, or Other. Per diem schedules can be created manually or through upload. See: Creating Schedules through the Upload Process.
Allowances schedules: Allowances schedules let you define the eligibility rules and the applicable amount for meals and accommodation allowances. Users claim specific instances of the allowance, and Internet Expenses adds the applicable amounts to calculate the reimbursable amount.
To create allowance schedules, select Allowances as the schedule type. The allowances type determines whether the schedule contains meal allowances, accommodation allowances, or both.
The business rules for per diem rate schedules are:
Currency
Locations
Roles
Time Based Entry
Free Meals
Free Accommodations
The per diem type controls the availability of the Free Meals and Free Accommodations rules.
The Currency rule is the only mandatory rule for per diem rate schedules. This rule determines the way in which Internet Expenses chooses a currency for the calculation of reimbursable amounts. See: Creating Policy Schedules.
The Location rule takes into account travel locations to determine valid rates. You can define individual rates for specific locations, and a single rate for all locations not specified in the schedule. Use the Search function to create a list of locations for the schedule. Also see Setting Up Locations.
The Roles rule takes into account the self service user's role in your company to determine valid rates. You can define individual rates for specific employee roles, and a single rate for all roles not specified in the schedule. Use the Search Function to create a list of roles for the schedule.
The Time-Based Entry rule lets you create different rates based on different time periods.
Time period: Select a time period to define how the trip duration is organized into rate periods for per diem calculation.
Midnight-to-Midnight: Use Midnight-to-Midnight if each rate period represents an actual day or part of a day.
For example, if the trip duration is from 8:00 on 01 March 2006 to 17:00 on 03 March 2006, then the rate periods will be:
First Period - 8:00 on 01 March 2006 to midnight on 01 March 2006
Full Period - 0:00 on 02 March 2006 to midnight on 02 March 2006
Last Period - 0:00 on 03 March 2006 to 17:00 on 03 March 2006
Start Time plus 24 hours: Use Start Time plus 24 hours if the rate period corresponds to each 24 hour period or any partial period starting from the trip start time.
For example, if the trip duration is from 8:00 on 01 March 2006 to 17:00 on 03 March 2006, then the rate periods will be:
Full Period - 8:00 on 01 March 2006 to 7:59 on 02 March 2006
Full Period - 8:00 on 02 March 2006 to 7:59 on 03 March 2006
Last Period - 8:00 on 03 March 2006 to 17:00 on 03 March 2006
Rate Periods: Define the time thresholds and the per diem eligibility criteria to enforce your company's policies. You can define the minimum trip duration for per diem eligibility, thresholds for standard rates, and thresholds for same day rates.
Minimum Trip Duration for Per Diem Eligibility: You can define the minimum number of hours and minutes an employee must travel to be eligible for per diem. You can also enforce the eligibility using Standard Rates if the minimum trip duration for per diem eligibility is less than 24 hours.
Standard Rates: Standard rates let you define the time thresholds used to determine the per diem rates. You must define at least one threshold to enable the time entry rule.
Standard Rates Only: Use the Standard Rates Only option to define the time thresholds when the same thresholds and rates are applicable to all periods.
Standard Rates plus First and Last Period Rates: Use the Standard Rates plus First and Last Period Rates option to define the time thresholds for the first period, last period, and interim periods.
Midnight to Midnight: When this time period is used, the first period and the last period refers to the traveling and returning days of the trip. You must define the time thresholds for the first period and last period. The thresholds for the first period correspond to the actual start time of the trip and the thresholds for the last period correspond to the end time of the trip. The standard threshold for interim days will always be 24 hours.
Start Time plus 24 Hours: When this time period is used, the last period refers to the partial period between the last 24 hour period and the trip end date and time. There is no first period. You must define the standard thresholds for the interim days and the time thresholds for the last period.
Same Day Rates: Use same day rates to define the time thresholds for travel that starts and ends on the same day. You should define same day rates when the thresholds and rates for same day travel differ from standard rates. If you do not reimburse for trips that start and end on the same day, select the Same Day Rates with No Reimbursements option.
Note: If an expense template has many per diem expense types, and only some per diem rate schedules use the Time-Based Entry rule, then the Start and End Times, End Date, and Number of Days columns are hidden on the expenses entry multi-row pages. See: Defining Expense Report Templates.
Note: For schedules that do not use the Time-Based Entry rule, you can define First and Last Day Rate percentages in the Schedule Details page.
You can define the rules to calculate the location rate per period that must be used when the employee travels to multiple destinations. Multiple locations rules are applicable only when an employee travels to multiple destinations within the same rate period. The multiple locations rules will be available only if the location rule is selected as an optional rule.
The rules to determine the per diem rate are:
None: Use this option to prevent users from entering multiple locations for a single trip.
Use the last location: Use this option to apply the rate for the last location stayed in a rate period.
Use the location with the highest rate: Use this option to apply the highest location rate in a rate period. Internet Expenses compares the rates for the locations in the rate period and uses the highest rate.
Use the location with the longest stay: Use this option to apply the rate for the location of longest stay in a rate period.
You can also enter the start and end times to determine the location of longest stay. For example, if the start and end times are entered as 06:00 and 23:59, then for each rate period, Internet Expenses will determine the time spent at each location between 06:00 and 23:59. The location of longest stay will be used to determine the applicable rate. Start and end times are available only when the time period is Midnight to Midnight.
If equal time is spent at more than one location, you can specify whether the highest or lowest rate should be used.
Note: Start and end times defined to determine the location of longest stay do not affect the way rate periods are calculated.
For non-time based entry, you can enable entry of multiple locations as part of the Locations rule setup.
Multiple Locations in Expense Entry: If a multiple locations rule is enabled for the per diem expense type in expenses entry, users can enter the locations visited and the time spent at each location. Internet Expenses will apply the multiple locations rule associated with the expense type to derive the applicable per diem rate.
If the time-based rules are enabled for the per diem expense type in entry, then the user must enter a start date and time, and an end date and time. Internet Expenses calculates the rate periods based on the start and end times and applies the rules defined in the rate schedule associated with the per diem expense type.
To determine the per diem rate per period, Internet Expenses applies the eligibility rules and thresholds in the following order:
If the schedule has a minimum trip duration for per diem eligibility specified, then Internet Expenses checks the trip duration entered by the user against the duration in the schedule. If the trip duration entered by the user is less than the minimum eligibility duration, then the user is not eligible for per diem.
If the user is eligible for per diem and if the schedule contains same day rates, then Internet Expenses applies the same day rates if the trip is a same day trip.
Otherwise, Internet Expenses applies the standard rates, first period rates, and last period rates as applicable.
The Free Meals rule assigns deduction values for free meals during the expense reporting period. You can define a single deduction value, deduction values for each meal type, or deduction values by number of meals. After the user enters the free meals, Internet Expenses uses the deduction assignments on the schedule to calculate the total deduction for free meals. This deduction amount for each rate period is then subtracted from the per diem rate for the rate period. The free meals optional rule will only be available for the Meals and Meals and Accommodations per diem type.
Maximum deductions per meal type: You can define the maximum deductions to be applied per meal type in the Schedule Details page. It is available only when deductions by meal type is selected as the free meals optional rule and the currency selected is single currency.
Minimum Reimbursement: You can define the minimum reimbursement amount per rate period in the Schedule Details page. The user is eligible for the minimum reimbursement amount when the reimbursement is calculated as zero or less. Minimum reimbursement is available for definition only when the schedule contains free items deductions, and users are eligible for per diem.
Note: Enter the minimum amount as zero to avoid a negative value for the reimbursement amount.
The Free Accommodations rule assigns either deduction or reimbursement amounts for free accommodation during the expense reporting period. After the user enters the number of free accommodation days, Internet Expenses uses either the deduction or reimbursement assignment on the schedule to calculate the total deduction or reimbursement for free accommodation. This amount is then subtracted from or added to the per diem rate for the rate period. The Free Accommodations optional rule will only be available for the Meals, Accommodations, and Meals and Accommodations per diem types.
Use Night Rate Eligibility Rules to define your company's policies for reimbursing amounts for free accommodations. This region is available only if Add amounts to reimbursable amount is selected as the Free Accommodations optional rule. You can define the minimum hours of night stay required during a specified time frame to qualify for the night rate. The user is eligible for free accommodations or night rate allowances only if there is no hotel expense claim for the rate period.
Note: Nightly rates are not applicable to same day rates.
Use Night Rate Eligibility Rules to define your company's policies for reimbursing amounts for free accommodations. This region is available only if Add amounts to reimbursable amount is selected as the Free Accommodations optional rule. You can define the minimum hours of night stay required during a specified time frame to qualify for the night rate. The user is eligible for free accommodations or night rate allowances only if there is no hotel expense claim for the rate period.
You can select one of the two options to define the night rates used:
Single Rates: Use this option if there is only one rate per location.
Multiple Rates: Use this option if rates vary by type of stay for each location. To use this option, you must define the night rate types using the OIE_NIGHT_RATES lookup. See: Defining Payables Lookups for Oracle Internet Expenses.
The business rules for allowances schedules are:
Currency
Locations
Roles
There are no specific rules for allowances. The allowances type determines the allowance rules and amounts that you can define.
The Currency rule is a mandatory rule for rate schedules. This rule determines the way in which Internet Expenses chooses a currency for the calculation of reimbursable amounts. See: Creating Policy Schedules.
The Location rule takes into account travel locations to determine valid rates. You can define individual rates for specific locations, and a single rate for all locations not specified in the schedule. Use the Search function to create a list of locations for the schedule. See: Setting Up Locations.
The Roles rule takes into account the self-service user's role in your company to determine valid rates. You can define individual rates for specific employee roles, and a single rate for all roles not specified in the schedule. Use the Search Function to create a list of roles for the schedule.
Based on the allowances type, you can define meal allowances, accommodation allowances, or both. The allowances type can be Meals, Accommodations, or Meals and Accommodations.
You can define the allowance method and a time period used for meal allowance calculations.
Allowance Method:
Define Meal Allowances by Meal Type: Use this option to define allowance amounts for breakfast, lunch, and dinner.
Define Meal Allowances by Number of Meals: Use this option to define allowance amounts for one meal, two meals, and three meals.
Time Period:
By Day: Use this option to limit the allowance amount by day.
By Daily Start and End Time: Use this option to define the start and end time requirements for each meal type. If this option is selected, users will be required to enter the start and end times for the trip. Internet Expenses will validate whether the start and end times fall within the time duration specified by the user. This option is applicable only for the Define Meal Allowances by Meal Type allowance method.
By Daily Time Thresholds: Use this option to define the allowances amounts by time thresholds. If this option is selected, users will be required to enter the start and end times for the trip. Internet Expenses will derive the duration traveled by the user and will retrieve the allowance amount defined for the threshold.
Accommodation allowances are enabled if the allowances type is Accommodations or Both. No additional setup is required.
Set up one or more per diem rate schedules and schedule periods that you require for employee expense reporting.
Prerequisites
Before you can set up per diem rate schedules, you might need to complete one or more of these tasks:
Define business groups, job roles, employee positions, and employee grades in Oracle Human Resources.
Set up Oracle Payables for expense reporting. See: Setup Steps in Oracle Payables.
To set up a new per diem rate schedule:
Log in to Oracle Applications with the user name and password appropriate for the installation.
Select the Internet Expenses Setup responsibility for the applicable site.
Navigate to the Per Diem expense category.
Click Create New Schedule to navigate to the General Information page.
Enter a Schedule Name and Description, and a Start Date for the schedule.
You may want to use a schedule name that identifies the usage of this particular schedule.
Select the schedule type as Per Diem.
Select the per diem type to indicate the type of per diem defined in the schedule. Select:
Meals, if the per diem rate contains only meal rates
Accommodations, if the per diem rate contains only accommodation rates
Meals and Accommodations, if the per diem rate contains both meal and accommodation rates
Others, for all other types of per diem
Select the Currency Rule and the Optional Rules to use for this schedule.
Click Next to navigate to the Business Rules page. See: Business Rules for Rate Schedules for an explanation of each rule.
Internet Expenses displays the schedule header information and the rules that you selected.
Select the values that you want for each rule, then click Next to navigate to the Schedule Periods page. See: Search Function.
Internet Expenses displays the schedule header information and a line record for the first schedule period.
Enter a Period Name and Start Date. Internet Expenses defaults the schedule start date as the read-only start date for the first period. You must enter a start date for subsequent periods.
Do not allow gaps or overlaps between periods. If you want to create a set of periods with continuous date sequences, you can create a new period or use Duplicate to copy the periods and enter the updates that you want.
Click Details to navigate to the Period Details page to enter the rate for each line record.
By default, Internet Expenses displays all records. You can use the Search Function to display the records that you want.
Enter a value for each line record. You can use Mass Updates to apply the same percentage to selected records.
If you selected the Free Meals or Free Accommodations rule, choose whether to enter percentage values or specific amounts in the Free Items Calculation Method column.
Click Return to save your work and return to the Schedule Periods page.
Click Activate to activate the schedule.
Assign the Per Diem expense category and rate schedules to expense types. See: Defining Expense Report Templates.
You can also create per diem schedules through the upload process. See Creating Schedules through Upload.
Set up one or more allowances rate schedules and schedule periods that you require for employee expense reporting.
Prerequisites
Before you can set up allowances rate schedules, you may need to complete one or more of these tasks:
Define business groups, job roles, employee positions, and employee grades in Oracle Human Resources.
Set up Oracle Payables for expense reporting. See: Setup Steps in Oracle Payables.
To set up a new allowances rate schedule:
Log in to Oracle Applications with the user name and password appropriate for the installation.
Select the Internet Expenses Setup responsibility for the applicable site.
Navigate to the Per Diem expense category.
Click Create New Schedule to navigate to the General Information page.
Enter a Schedule Name and Description, and a Start Date for the schedule.
You may want to use a schedule name that identifies the usage of this particular schedule.
Select the schedule type as Allowances.
Select the allowances type to indicate the type of allowance defined in the schedule. Select:
Meals, to define meal allowances
Accommodations, to define accommodation allowances
Meals and Accommodations, to define meal allowances and accommodation allowances
Select the Currency Rule and the Optional Rules to use for this schedule.
Click Next to navigate to the Business Rules page. See: Business Rules for Rate Schedules for an explanation of each rule.
Internet Expenses displays the schedule header information and the rules that you selected.
Select the values that you want for each rule, then click Next to navigate to the Schedule Periods page. See: Search Function.
Internet Expenses displays the schedule header information and a line record for the first schedule period.
Enter a Period Name and Start Date. Internet Expenses defaults the schedule start date as the read-only start date for the first period. You must enter a start date for subsequent periods.
Do not allow gaps or overlaps between periods. If you want to create a set of periods with continuous date sequences, you can create a new period or use Duplicate to copy the periods and enter the updates that you want.
Click Details to navigate to the Period Details page to enter the rate for each line record.
By default, Internet Expenses displays all records. You can use the Search Function to display the records that you want.
Enter a value for each line record. You can use the Mass Updates button to apply the same percentage to selected records.
If you selected the Free Meals or Free Accommodations rule, choose whether to enter percentage values or specific amounts in the Free Items Calculation Method column.
Click Return to save your work and return to the Schedule Periods page.
Click Activate to activate the schedule.
Assign the Per Diem expense category and rate schedules to expense types. See: Defining Expense Report Templates.
Internet Expenses lets you set up per diem, meals, and accommodations schedules by uploading rates provided by U.S. government agencies. Using the upload process, you can create a schedule or update an existing schedule. You can access the Upload Rates process from the Requests tab using the Internet Expenses Setup responsibility.
Note: The Upload program cannot be invoked from the concurrent program window in Oracle Applications.
Internet Expenses currently supports the CONUS (CONtinental United States) and the OCONUS (Outside CONtinental United States) rates for upload. The files must be in semicolon-delimited ASCII file format. These files can be downloaded from the Per Diem, Travel, and Transportation Allowances Committee web site.
CONUS and OCONUS files contain per diem rates for meals and accommodations for each location. When the accommodation rate for a location varies by season, the file will contain multiple rates for the location with seasonal start and end dates. In addition, each location rate has an effective start date. The files also provide the rates for all locations not listed specifically. The following two tables describe the CONUS and OCONUS file structures.
Description | Type |
---|---|
State | Char (32) |
Locality/City | Char (32) |
County | Char (32) |
Season Begin | Char (5) |
Season End | Char (5) |
Max Lodging | 999 |
No Government Meals | 999 |
Proportional Meals | 999 |
Max Per Diem Rate | 999 |
Effective Date | Char (10) |
Note: Max Per Diem Rate = Maximum Lodging + Local Meals Rate + Local Incidentals Rate
Description | Type |
---|---|
State | Char (42) |
Locality/City | Char (32) |
Season Begin | Char (5) |
Season End | Char (5) |
Max Lodging | 999 |
No Government Meals | 999 |
Proportional Meals | 999 |
Max Per Diem Rate | 999 |
Effective Date | Char (10) |
Off Base Inc. | 999 |
Footnote | 999 |
Footnote Rate | 999 |
Max Per Diem Rate | 999 |
Effective Date | Char (10) |
Note: Max Per Diem Rate = Maximum Lodging + Local Meals Rate + Local Incidentals Rate
Complete the following steps to create or update schedules using the Upload process:
You must save the data file to upload in a directory path defined as a database directory for PL/SQL file I/O. See: Defining Database Directories for PL/SQL File I/O.
Run the Upload program with your desired parameters.
Review the output and correct invalid locations. Invalid locations appear in the Define Locations page with status of Invalid.
Note: This step is required only when uploading OCONUS rates.
Optionally rerun the program to upload resolved records.
Alternatively, you can manually update the schedule. You can enable additional rules, add/remove additional locations, or enter/modify free items deductions/additions using the schedules setup pages.
Optionally activate the schedule.
Internet Expenses uses the parameters selected for the upload process to determine which optional rules to enable for the schedule.
For meals and accommodations schedules, the only optional rule enabled is Daily Limits. Internet Expenses stores the rates as the Daily Sum Limit in the schedule.
For per diem schedules, Internet Expenses determines the daily rate and per diem type using the rate components selected in the Rate Calculation region.
Internet Expenses enables the Free Meals rule if the meals deduction method is selected, and enables the Free Accommodations rule if the Use Free Accommodations check box is selected. Internet Expenses determines whether to use accommodations additions or deductions based on the rate components selected.
The following table lists the per diem type applicable for schedules created through upload:
Per Diem Type | Local Meals Rate | Proportional Meals Rate | Incidental Rate | Accommodations |
---|---|---|---|---|
Local Meals Rate | X | |||
Local Meals Rate and Incidentals | X | X | ||
Proportional Meals Rate | X | |||
Proportional Meals Rate and Incidentals | X | X | ||
Accommodations | X | |||
Local Meals Rate and Accommodations | X | X | ||
Proportional Meals Rate and Accommodations | X | X | ||
Local Meals Rate, Incidentals, and Accommodations | X | X | X | |
Proportional Meals Rate, Incidentals, and Accommodations | X | X | X |
Note: For schedules created through upload, the per diem type cannot be changed.
During upload, the upload process validates whether the location already exists in Internet Expenses by comparing the city/location, county, state/province, and country fields:
If the location exists, then the upload process creates the rates for the location in the schedule.
If the location is new, then the upload process validates the country against the country/territory names in the FND_TERRITORIES table:
If the country is valid, then the upload process creates the location and rates.
Locations with incorrect country names are marked as Invalid.
To upload the rates for invalid locations, first correct the country names, then rerun the upload process.
Schedules created through upload will remain in 'Saved' status until they are manually activated.
To create a schedule through the upload process:
Log in to Oracle Applications with the user name and password appropriate for the installation.
Go to the Requests tab.
Select the rate type:
CONUS - For CONtinental United States rates
OCONUS - For Outside-CONtinental United States rates
Select Create Schedule.
Enter the full path of the data file.
Select an expense category.
Enter a unique name for the schedule.
Enter a start date for the schedule and a name for the period.
For expense category - Meals
Select whether the rate calculation is Local Meals Rate or Proportional Meals Rate.
For expense category - Per Diem
Select the Meals check box if the rate calculation includes meals. Select whether the rate calculation uses the local meals rate or proportional meals rate.
Select the Incidental Rate check box if the rate calculation includes incidental expenses.
Select the Accommodations check box if the rate calculation includes accommodations.
Select the free meals deduction as Single Deduction to enter a single meal deduction value for a day. Select Deduction by Meal Type to specify the free meal deduction value based on the type of meal.
Select the calculation amount for free meal deductions as amount or percent.
Note: If Deduction by Meal Type is selected, then the only available option is Percent.
Enter the deduction value for the free meals deduction.
Select the Use Free Accommodations check box to enable the Free Accommodations rule. Internet Expenses uses Free Accommodations Deductions if the rate calculation includes an accommodations rate, and Free Accommodations Additions if the rate calculation does not include an accommodations rate.
For expense category - Accommodations
No further selection is required.
Click Upload.
To validate locations in the file that do not already exist in Internet Expenses, the upload process compares the country of the location against the country names in the FND_TERRITORIES table:
If there is a match, then the upload process creates the location in Internet Expenses and populates the city/locality, county, state/province, and country fields.
If the country of location does not match any country names in the table, then the upload process validates the location against the short name. If there is still no match, then the upload process validates the country against the description.
When the upload process cannot validate a country, the upload process creates a new location with an Invalid status. To correct invalid locations, administrators should assign valid countries to the invalid locations through the Define Locations page, and activate them.
For the location All Other Places Not Listed in the CONUS file, the upload process creates a location called All Other United States.
You can use the Upload process to update schedules that were originally created using the upload process. Internet Expenses enforces the existing rules for the schedule for updates.
During upload, the upload process validates whether the location already exists in the schedule by comparing the city/location, county, state/province, and country fields:
If the location exists, then the upload process matches the rates and effective start date from the file to the rates and effective start date in the schedule, to determine whether the rates need modification. If the rates need modification, then the upload process end dates the old rates and creates the new rates.
If the location is new, then the upload process validates the country against the country/territory names in the FND_TERRITORIES table. If the country is valid, then the upload process creates the location and the rates. If prior periods exist in the schedule, then the upload process creates a record for the location with the rates specified for the unspecified locations.
Locations with incorrect country names are marked as Invalid. To upload the rates for invalid locations, first correct the country names, then rerun the upload process.
To update a schedule through upload:
Log in to Oracle Applications with the user name and password appropriate for the installation.
Go to the Requests tab.
Select the rate type:
CONUS - For CONtinental United States rates
OCONUS - For Outside CONtinental United States rates
Select Update Schedule.
Enter the full path of the data file.
Select the expense category and name of the schedule to modify.
Select the period type:
New - Create a new period.
Existing - Modify an existing period. Internet Expenses uses the period start date to determine the period to be updated.
If you selected New as the period type, enter the period start date and period name.
For the Per Diem expense category:
Select the calculation amount for free meal deductions as amount or percent.
Enter the deduction value for free meals deduction.
Click Upload.
Use the schedules setup pages to enable additional rules, add/remove additional locations, or enter/modify free items deductions/additions for schedules created through the upload process. You cannot enter seasonal rates or end date a rate record, however, using the schedule setup pages. You can update schedules until a schedule is assigned to an expense type.
Use the pages in Internet Expenses Setup to create and maintain your rate and policy schedules. The pages common to each expense category for setting up schedules are:
Summary page
General Information page
Business Rules page
Schedule Periods page
Period Details page
The schedule setup pages guide you through the process of creating a schedule or modifying an existing schedule. The steps to creating a schedule are:
Enter schedule header information and select the rules to use for the schedule.
Enter definitions for each of the selected rules.
Create periods for the schedule.
Define rates and related information for individual periods.
The Summary page is the first page displayed when you choose an expense category. The page shows you the list of schedules for the category and related information.
You can initiate these operations from the Summary page:
Update general information. Click the Update General icon to navigate to the General Information page.
Update period information. Click the Update Details icon to navigate to the Schedule Periods page.
Copy a schedule. Click the Duplicate icon to copy an existing schedule. You can use the setup pages to modify information in the copied schedule.
Create a new schedule. Click the Create New Schedule button to create a new schedule.
View the change history on a schedule. Click the History icon to view the change history.
Internet Expenses displays the General Information page when you click the Create New Schedule button or the Update General icon in the Summary page. Filling out the General Information page is the first step in creating a schedule.
Use this page to:
Enter header information: schedule name, description, start and end dates.
Choose the rules to use for a schedule. Some rules are available for all categories, while other rules are specific to one expense category.
Internet Expenses displays the Business Rules page when you click the Next button on the General Information page or the Back button on the Schedule Periods page. Filling out the Business Rules page is the second step in creating a schedule.
Use this page to enter specific definitions for each rule that you selected in the General Information page. By default, Internet Expenses applies the definitions that you enter to all periods of the schedule. You update rule definitions in the Business Rules page; these changes apply to the current and all future schedule periods. You will enter individual rule values for each schedule period using the Period Details page.
Internet Expenses displays the Schedule Periods page when you click the Next button on the Business Rules page or the Update Details icon on the Summary page. Defining periods and entering period details information is the third step in creating a schedule.
The Schedule Periods page displays the periods belonging to the schedule. A schedule period designates the mileage and per diem rates or the policy rates to use on employee expense reports for a given time period. By default, Internet Expenses creates the first period when you define the schedule business rules and navigate to the Schedule Periods page. You can create additional periods and modify the values in each period to suit your business needs.
You must enter the start and end dates of schedule periods in chronological order. The start date of the next period must be the day following the end date of the previous period. The start and end dates cannot overlap, and you cannot have gaps between periods.
You can initiate these operations from the Schedule Periods page:
Enter a period name and start and end dates for each period.
Update a period. Click the Update Details icon to navigate to the Period Details page.
Copy a period. Click the Duplicate icon to copy an existing period. You can use the Period Details page to modify information in the copied period.
Create a new period. Click the Create New Period button to create a new period.
Remove a future period. Click the Remove icon to remove a future period. You cannot remove the current period or previous periods.
View the change history for a period. Click the History icon to view the change history.
Internet Expenses displays the Period Details page when you click the Details icon for a given period. Use the Period Details page to update information for a period. You can use the Search Function to display the period records that you want.
Internet Expenses generates period records based on the rules that you selected for the schedule. Internet Expenses automatically generates a separate read-only period record for each combination of rule definitions belonging to the schedule. You enter values for each record individually, or update existing values individually or using Mass Updates. You can also click the History icon to view the change history for a specific line record.
Buttons
The buttons on the Internet Expenses Setup pages provide the functionality described below:
Go - Clicking the Go button displays the records or page view specified by the entered value. This button is part of the Search Function in Internet Expenses Setup.
Save - The Save button saves your work on the current page without exiting the page. Use this button to enter and save new work in the current page.
Apply - The Apply button applies updates to the current page and returns you to the previous page.
Next - The Next button displays the next page in sequence for new entry. If you have unsaved data, Internet Expenses only saves data when you click Next to move from the Business Rules page to the Schedule Periods page. For all other pages, you must save data before exiting Internet Expenses Setup. If there is an error on the current page, Internet Expenses remains on the current page, displays an error message, and does not save your work. You must correct the error before you can save and continue.
Back - The Back button returns you to a previous page in a sequence. Clicking the Back button either redisplays the preceding page, if setup was performed on this page, or returns you to the first page in the sequence, if no setup was performed.
Cancel - The Cancel button cancels activity on the current page and returns you either to the first page of the flow or to the last page that was displayed. If you have unsaved work, Internet Expenses displays a warning message to save or lose this work.
Activate - The first time you click the Activate button after creating a schedule, Internet Expenses performs the necessary validations, then saves your work on the current page and makes the schedule available for assignment to expense types. If there are no errors, Internet Expenses sets all new or updated records to the status Active and returns to the accompanying summary page. If there are errors, Internet Expenses displays a message to correct the errors. Once a schedule is activated, you can assign it to expense types.
Each time you make changes to an existing schedule, you must click Activate again to apply these changes.
Note: You should only use these buttons to navigate Internet Expenses Setup. If you attempt to navigate from a page that contains unsaved data by clicking menu tabs or page links, Internet Expenses does not save the data and does not warn you that the data will be lost.
Use these features in Internet Expenses Setup to help you display and update information for schedule setup:
Update as a Group/Mass Updates
Search Function
The buttons Update as a Group and Mass Updates display a Mass Update page. Use the Mass Update page to apply the same set of updates to many records at once.
To enter mass updates:
Select the records that you want to update from the current page.
Click the Update as a Group or Mass Updates button.
Internet Expenses displays the records that you selected from the previous page in a read-only table, with the updatable fields in a separate region.
Enter the values that you want in each field.
Click the Apply button to apply these values to each record in the table. Internet Expenses returns to the previous page.
Use the Search function in Internet Expenses Setup to perform these operations:
Display a table of records for viewing, creation, or update.
Create a list of records to use for defining schedules.
Use the Search function in the Define Locations page, Define Exchange Rate Behavior page, and schedule details pages to display selected records for creation and update. By default, Internet Expenses displays all updatable records.
To select the records that you want:
Choose a column name from the Search choice list.
The choice list contains the searchable column names belonging to the table of the current page.
Enter a column value in the available field. You can enter a partial value with the percentage (%) wildcard character.
Click the Go button to display the results of your search.
If you have unsaved data when you click Go, Internet Expenses gives you the option to save before continuing with the search. If you continue the search without saving, any unsaved data is lost.
Use the Search function to create a list of operating units, or to create lists of business rule values for locations, multiple reimbursement currencies, and employee roles to use for your schedule definitions. The operating unit list appears on all pages that require setup at the operating-unit level. The schedule rules lists appear on the Business Rules pages.
You first create an Available list using search criteria. You then create the correct list by drawing from the records in the Available list. You can add and remove records in the Available and current lists at any time.
To create a list of active records:
If you are creating an Available Employee Roles list, select a business group and role type to use to create your Available list. If the role type is Job, then you must also select a business group, because a role type may be unique across business groups.
In the Available list, check the Select box of the records that you want, then click the Add to Schedule button to create an active list.
Update records in the active list:
Enter an End Date. If you do not enter an end date, the record remains active.
Add new records from the Available list.
Click the Remove icon to remove a record. Once a schedule is active and assigned to one or more expense types, you cannot remove rule values. If you add new rule values to a schedule that is already active, you can remove these new values until the schedule is re-activated.
You can click on the History icon to view the change history of a schedule, period, or line record. The History page lists the date and type of change, and which user made the change.
Rate and policy schedule records can have these statuses:
Null - Default status for new schedules.
Saved - Status when schedules are created by auto-generation, when the user duplicates a period or schedule, or when the user modifies an existing active schedule and saves the work.
Note: Saved records are not referenced during expenses entry, only active records are referenced.
Active - Status when the user activates a schedule by clicking the Activate button on the Schedule Periods page.
Duplicated - Status when a user duplicates a period or an entire schedule, without saving or activating the schedule.
Inactive - Status when the details record is inactive and the user cannot reference the record during expenses entry.
Note: A record will have a status of Inactive only when its schedule rule values have been end-dated and the system date is past the end date plus the grace period.
Archived - Status of old records is changed to Archived when the user modifies an active record. Archived records are not displayed on the schedule details page. You can only view them on the Schedule History page.
Note: The Archived status ensures that you can return to previous records.
You can modify the business rule assignments to a rate schedule until you activate the schedule. Once you activate a schedule and assign it to an expense template, you cannot add or remove the business rules on the schedule. You can add or end date locations and roles in a schedule even after it is activated.
You can apply end dates to these rules - Multiple Currencies, Locations, and Roles.
If your company uses multiple operating units, set up and maintain the list of operating units that require Internet Expenses definitions. The operating units that you select appear in the definition tables on all applicable setup pages. The features in Internet Expenses that require setup at the operating-unit level are:
Exchange rates
Merchant VAT
Accommodations, airfare, car rental, mileage options, and meals expense lines
Audit Automation
The first time that you access the Internet Expenses Setup responsibility, the system defaults to your own operating unit and displays the Context tabbed region for you to set up a list of operating units. You can use the Context tab at any time to update the list of operating units.
You can perform setup tasks that are operating unit-specific for every operating unit that you define, or for your single operating unit if you have not defined operating units.
Note: If you have function security enabled with access only to the operating unit you are assigned, or if you do not use Multi-Org functionality, then you do not have access to this setup page.
Defining operating units. Define a list of active operating units in the Context tabbed region. The operating units in this list appear in the definition tables on all pages that require setup at the operating-unit level. If you do not define a list of operating units, you can only perform setup on the one operating unit that the Internet Expenses Setup responsibility is assigned to.
You can remove operating units from the current list at any time. If you have already assigned definitions to an operating unit that you want to remove, the definitions remain active.
Set up Internet Expenses to allow end users to update and validate accounting flexfield segments for individual expense lines. Internet Expenses also lets users update multiple expense lines at the same time. This is useful, for example, for users who consistently charge expenses to accounts that are not part of their usual accounting.
Internet Expenses can provide automatic validation of the account code combinations that users enter. Managers can review the account code combinations on expense reports.
You can also set up Internet Expenses to let users split expense lines into multiple distributions.
This is useful, for example, when a consultant travels to a city to work on two assignments for two different cost centers. In this case, the consultant might need to allocate a single expense such as airfare to two different cost centers.
Non-Project Enabled Expense Lines. When enabled, users can split expense lines and update accounting flexfield segments on the resulting distributions.
Project Enabled Expense Lines. Users can split one or more expense lines for the following items:
Projects
Tasks
Awards
Project Expenditure Organizations
Internet Expenses also lets users split expenses based on the receipt amount.
Users can use one of the following criteria:
Equal Split. Splits the expense line equally among the selected accounts or projects. If rounding is required, the rounded amount will be added to the last selected line. Equal split is available both for single and multiple selection of lines.
Percentage Split. Splits the expense line based on the percentage that the user specifies. Percentages can only be entered in whole numbers. Percentage split is available both for single and multiple selection of lines.
Amount Split. Use this option to split the selected expense line into absolute amounts. The Amount Split option is available only when a single expense line is selected.
Mass Allocation. Use this option to split selected expense lines using the same criteria. The Mass Allocation option is available only when multiple expense lines are selected.
Note: For added efficiency, you can optionally create an allocation set for later reuse against other, selected expense lines. See: Allocation Sets.
If Oracle Approvals Management (AME) is installed, then approval requests for expense allocations can be routed, directly and in parallel, to the appropriate approvers. See: Integrating with Oracle Approvals Management.
Manager Approvals. When expense lines are split into multiple distributions, the distributions might require different approval chains. For example, the approval chains could be different for two different cost center owners or project managers. In such cases, the expense report can be routed in parallel to different approvers.
Note: If an expense report is rejected by one approver, then the entire expense report will be rejected.
Approvers can see the total expense report amount as well as the total amount that requires their approval, and can drill down to the expense allocations. Users can see the list of approvers and their approval status.
Auditor Approvals. After manager approvals are complete, the auditor performs a review of the expenses and approves or rejects the expense lines accordingly. Auditors can also view and update the accounting on split expense lines. When auditors update the accounting, the same validation rules that were applicable during expenses entry are used. See: Expense Allocations Update and Validation.
When both manager and auditor approvals are complete, the expense report transactions are exported into the Payables Open Interface tables. The Payables Open Interface tables Import APIs will then be used to indirectly import expense report transactions from the Open Interface tables to the Payables Invoice tables. For information about auditing expense reports and managing expense report auditors, see: Oracle Audit Management.
Users can update both project and account allocation information depending on the setup. Based on the setup, the following different situations can occur for project expense allocations:
When expense lines are project-enabled and marked as 'Required' for project entry, users can update only project allocation information.
When expense lines are project-enabled but not marked as 'Yes with account allocations', users can update accounting information, provided that project information is not also entered on the expense line.
Users can update both accounting information in addition to project information on the same line.
See: Setting Up Expense Allocations.
Tip: Projects users should define their projects and tasks as Required for project entry to make the entry process simple and consistent.
Note: If you set up expense allocations to allow Oracle Projects users to update both project information and accounting information, splitting expense lines is not allowed.
Note: Use the Project Expense Report Account Generator to default accounting, or use an accounting client extension. See: Project Expense Report Account Generator.
Users can create allocation sets for allocation updates that they frequently perform. Reusable allocation sets, or aliases, significantly expedite expense allocations entry. Users can create allocation sets either using the Expenses Preferences pages or while creating an expense report.
Using the Expenses Preferences pages, users can split expense lines using these allocation methods:
Equal Split. Splits the expense line equally among the selected accounts or projects.
Percentage Split. Splits the expense line based on the percentage that the user specifies. Percentages can only be entered in whole numbers.
Note: If rounding is required, the rounded amount will be added to the last selected line.
Complete the following tasks to set up expense allocations:
Using the Internet Expenses Setup responsibility, set up the accounting flexfield behavior for your company charts of accounts. For each chart of accounts, define which segments of the accounting flexfield are visible on expense lines, and which of the displayed segments are updatable by the user.
Note: You can set up exceptions to the accounting flexfield behavior at the set of books level. See: Defining Accounting Flexfield Segment Behavior.
Set the OIE: Enable Expense Allocations profile option to enable expense allocations according to your requirements. See: Controlling Expense Allocations Functionality.
You can set the display of accounting flexfield segments and online validation as user-definable or automatic. See: Specifying Values for Internet Expenses Profile Options.
Optionally enable projects entry, according to your requirements, using the OIE: Enable Project Allocations profile option.
Optionally enable projects entry using the PA: Allow Project-Related Entry in Oracle Internet Expenses profile option.
Note: To enable projects entry, both the OIE: Enable Project Allocations and PA: Allow Project-Related Entry in Oracle Internet Expenses profile options must be set to Yes or Required.
Optionally enable the splitting of expense allocations, according to your requirements, using the OIE: Enable Expense Allocation Splitting profile option.
Optionally enable the project expenditure organization for end users, according to your requirements, using the OIE: Enable Project Expenditure Organization profile option.
You can choose to customize the building and validating of code combinations. See: Accounting Client Extensions.
When enabled, automatically or by the user, an additional page called Expense Allocations appears on the expenses entry pages just before the Review page. On this page, the user can update accounting flexfield segments or project-related information according to the setup. In addition, users can create aliases in their Expenses Preferences to expedite expenses entry. See: Allocation Sets.
You can control expense allocations functionality using the following profile options:
OIE: Enable Expense Allocations
PA: Enable Time and Expense
OIE: Enable Project Allocations
OIE: Enable Expense Allocation Splitting
This table illustrates how various combinations of profile option settings control expense allocations functionality.
Num | Expense Allocations Functionality | OIE: Enable Expense Allocations | PA: Enable Time and Expense | OIE: Enable Project Allocations | OIE: Enable Expense Allocation Splitting |
---|---|---|---|---|---|
1 |
|
Any value | Yes or Required | Yes with account allocations or Required, with account allocations | Any Value |
2 |
|
Any value other than No | Yes or Required | Yes or Required | Yes or Required with reason |
3 |
|
Any value other than No | No | No | Yes or Required with reason |
4 |
|
Any value other than No | No | No | No |
5 |
|
No | Yes or Required | Yes or Required | Yes |
6 |
|
No | Yes or Required | Yes or Required | No |
7 |
|
No | No | No | Any value |
Note: The PA: Enable Time and Expense profile option Yes value is effective only if the OIE: Enable Project Allocations profile option is set to Yes.
Use the Chart of Accounts pages to designate the display of accounting flexfield segments on expense reports. The default for each chart of accounts is that accounting flexfield segments are not displayed.
You can also set up exceptions to the accounting flexfield behavior at a more granular, set of books level. This lets you set divergent rules for different sets of books. For example, within a chart of accounts, countries that use their own set of books may have different accounting flexfield segment behavior requirements.
The options for defining the behavior of set of books exceptions are the same as that of the chart of accounts setup. The behavior of each set of books is identical to the chart of accounts except where defined differently in the Set of Books region in the Chart of Accounts page.
Before you can define accounting flexfield behavior, you must:
Define your charts of accounts.
Define a set of books.
For each chart of accounts or set of books, you have these options to define the behavior of each accounting flexfield segment:
Disabled - The segment does not appear on expense lines.
Read-only - The segment appears on expense lines, but users cannot update the default value displayed.
Enabled - Users can update the default segment value.
Tip: To prevent end users from charging to incorrect accounts, do not enable the natural account segment. Instead, use the expense report template to default this segment.
Note: The lists of values on the Expenses Entry: Expense Allocations page do not exclude segment parent values. If you do not want the parent values to appear, you must either set up your chart of accounts to not allow posting (through segment value qualifiers) or use security rules.
You can define security rules to restrict user access to certain account segment values. See: Defining Security Rules, Oracle Applications Flexfields Guide.
You can use the following value set validation types with Oracle Internet Expenses:
None
Independent
Dependent
Table
When a user enters an expense report, Internet Expenses defaults the user's cost center and account for the expense report, based on the human resources setup of the accounting flexfield. If enabled, users can change the cost center at the header level for the expense report. For line-level expense allocations, users can make changes to account segments according to the expense allocations setup, including expense lines where the expense type is assigned a particular account on the expense report template.
The hierarchy of changes to the default expense account take precedence in this order:
Expense Allocations. If expense allocations is enabled, the updates to expense allocations for individual expense lines.
Expense Report Cost Center. Update of the default cost center for the expense report by the user or by the Default Cost Center Procedure of the Validations and Defaults client extension.
Expense Report Template. If defined, the expense account assigned to an expense type in the GL Account field of the Expense Report Templates window. Updates apply to all expense lines that use this expense type.
Human Resources Setup. Changes to the human resources setup of the accounting flexfield.
If the expense report is project-related and the user enters projects for expenses, then the accounts created by the Project Expense Report Account Generator take precedence over any of these changes. See: Project Expense Report Account Generator.
Note: You cannot update expense allocations on expense lines that are charged to an Oracle Projects project and task, unless the OIE: Enable Project Allocations profile option is set to Yes, with account allocations or Required, with account allocations.
This example illustrates the update hierarchy described above.
Assume this setup for expense reports:
Accounting flexfield: Company.CostCenter.NaturalAccount.Product
Default expense account: 01.100.6100.0000. This is the HR setup for the user.
GL account assigned to item type Telephone: 01.100.6100.7000
GL account assigned to item type Meals: 01.520.6100.0000
The following updates are applied to the expense account and expense lines:
Update: Human resources setup changes the expense account Natural Account segment to 6000.
Result: The default expense account becomes 01.100.6000.0000.
Update: User changes the default cost center for the expense report to 110.
Result: The expense account for this expense report becomes 01.110.6000.0000.
Update: User enters the expense type Telephone on an expense line.
Result: The expense account for the telephone expense line becomes 01.110.6000.7000.
Update: User updates the Product segment expense allocation for the telephone expense to 1000.
Result: The expense account for the telephone expense line becomes 01.110.6000.1000. The rest of the expense report remains allocated to the expense account 01.110.6000.0000.
Update: User enters the expense type Meals on an expense line for an expense that was incurred while working on an assignment for two different cost centers.
Result: The default expense account becomes 01.520.6100.0000.
Update: User splits the meal expense of $50 USD equally between cost centers 520 and 678.
Result: Two distribution lines are created:
Distribution 1: 01.520.6100.0000 for $25 USD
Distribution 2: 01.678.6100.0000 for $25 USD
During expenses entry, the system validates changes to account code combinations on expense lines only. If you enable online validation with the OIE: Enable Expense Allocations profile option, then the validations occur prior to submitting the expense report. If you do not enable online validation, or if the expense report is project-related, then validation occurs during the workflow process.
These updates to the expense account are validated at the expense report header level:
Updates to the HR setup for the expense account.
Updates to the default cost center for the expense report.
These updates to the expense account are validated at the expense report line level:
Updates to an expense line using an item type that has a GL account assignment on the expense template.
If expense allocations is enabled, updates to individual expense lines.
Note: Internet Expenses allows the use of dynamic insertion, if permitted by your validation rules.
If the expense report fails in workflow due to validation errors, the Notification page sent to your designated personnel provides a drill-down to review and update the applicable expense lines.
After expense report submission, Internet Expenses provides approvers with the details of all accounting flexfield segment updates on the expense report.
Internet Expenses also lets you customize the creation and validation of account code combinations. See: Overview of Implementing Client Extensions.
Set up and maintain a list of locations that your company uses for expenses reporting. Internet Expenses uses location information for:
Merchant fields. Certain countries require the reporting of VAT on expense receipts. You can set up fields to capture merchant information to reclaim VAT for each applicable location. See: Setting Up Merchant Fields.
Per diem calculations. The per diem rate schedules you define can use location information to determine an employee's per diem rate. See: Creating Per Diem Rate Schedules.
Policy compliance. The policy schedules you define can contain expense reporting rules based on location. See: Creating Policy Schedules.
You maintain a list of locations that are available for expenses reporting. These locations appear as valid choices in the merchant fields, per diem and policy compliance schedule setup pages, and in self-service users' expense reports. You can add locations or apply end dates to locations as often as you need.
If you have more than one language installed in your system, you can translate location information from the base language into each installed language. The translation of location information is a manual process that is not validated by Internet Expenses.
There are three tasks related to the setup of location information:
Define and maintain a list of locations.
Translate locations into all installed languages.
Apply end dates to locations.
Prerequisite
Before you can set up locations in Internet Expenses, you must set up countries and territories.
Enter and maintain the list of locations that your employees need for expenses reporting. You can update location information and add new locations to your list at any time. You cannot delete locations, but you can deactivate a location by using the End Date field.
Use the Define Locations page to enter locations. You can set up locations as City or Country locations. If you have existing location records, you can use the Search Function to display the records that you want.
You define Country locations to define policies at the country level. For example, a company with operations in the United States can define a policy schedule with the location as United States. If users select any location within the United States as their expense location, and if there are no rates defined for that location, then Internet Expenses will use the rate defined for the United States.
The important fields for defining locations are:
Location This field identifies the specific location, a city, town, or province if it is a city location and a country if it is a country location. This field is user-definable for city locations. For country locations, the user can select from a valid list of countries. The location values that you define here appear on all related setup pages and on expense reports.
Description This is a user-defined field that explains the scope of this particular location.
Country/Territory Choose the country or territory for the value that you entered in the Location field from the list of values.
End Date Use this field to enter a final active date for this location. See: Applying End Dates to Locations.
Status This is a display only field that displays the status of the location. Status can be Saved, Active or Invalid. Only Active locations are available for use in the schedules.
Undefined Locations and Description You must create an All Other Locations record for Internet Expenses to use for all locations that you do not specifically define.
Additional fields that apply to city locations are:
City/Locality This is a display-only field that is populated only for locations that are uploaded from the CONUS file. The field stores the actual city/locality name as displayed in the file.
County This is a display-only field that is populated only for locations that are uploaded from the CONUS file. The field stores the actual county name as displayed in the file.
State/Province This is a display-only field that is populated only for locations that are uploaded from the CONUS and the OCONUS file. The field stores the actual state name as displayed in the file.
Country This is a display-only field that is populated only for locations that are uploaded from the CONUS and the OCONUS file. The field stores the actual country name as displayed in the file.
The combination of values for Location, Description, and Country/Territory identifies a single location record. Each location record must be unique. You can define several locations in one country or territory, and use the Description field to specify the use of each record.
This table provides an example of location records:
Location | Description | Country/Territory |
---|---|---|
San Francisco | San Francisco metropolitan area | United States |
New York, NY | New York City | United States |
United States | All other US locations | United States |
London | Greater London area | United Kingdom |
Note: If your company has a credit card program, define your locations so that they match the locations on your credit card transactions. This helps ensure that Internet Expenses defaults location information correctly on expense reports.
The Expenses Locations page displays a table of the languages installed in your system. The table indicates the status of the translation of locations into each language [Fully Translated - Yes/No]. To translate location information, click the Translate icon of the language that you want in order to display its Translate Locations page.
Use the Translate Locations page to translate location records into an installed language. You can use the Search Function to display the records that you want. The search results table displays location records with updatable fields for:
Undefined Locations and matching Description.
Location and matching Description for each location record.
Internet Expenses displays the base language values for you to use as a reference for your translations. Internet Expenses does not validate the accuracy of your translations.
When you have finished translating records and click Done, Internet Expenses returns to the Expenses Locations page and marks Yes in the Fully Translated column of the applicable language.
Once Internet Expenses marks a language as Fully Translated, this validation is not reversed. It is up to the responsible administrator to ensure the translation of current location records and all new location records into each installed language.
Apply end dates to location records to remove them from the list of locations. If you set a value other than null in the OIE: Grace Period profile option, then the location remains active until the system date is past the end date plus grace period days. See: Specifying Values for Internet Expenses Profile Options.
Internet Expenses applies these rules to the use of end-dated locations on schedules and expense reports:
If you want to use a location that has a future end date on a schedule, then you must apply an end date to the schedule on or before the location end date.
If you apply a future end date to a location that is in use by one or more schedules, the location remains active on all rate and policy schedules until the system date passes the end date plus grace period. Once the system reaches this date, the location is no longer available for selection in schedules.
You cannot apply an end date to a location that is in use by an active rate or policy schedule. If you want to apply an end date to the location, you must either apply an end date to the location record in all schedules that use the location or apply an end date to all the schedules.
You cannot use a location on an expense report where the receipt date is later than the location end date.
Your location setup determines the display and behavior of location information on expenses entry pages.
Multi-row pages
These pages display location fields only if all expense types use location-based schedules, unless you have merchant fields enabled. If you have merchant fields enabled, then Internet Expenses always displays location fields with a list of values.
The list of values contains:
For receipt-based expenses, all active locations used on all location-based schedules and on enabled merchant fields per operating unit. For enabled merchant fields, this includes all countries defined for all operating units.
For per diem expenses, only those locations used on the schedule, even if you have merchant fields enabled.
Details pages
If there is no schedule assigned, or if the assigned schedule is not location-based, then these pages display location fields for text entry only. If the assigned schedule is location-based, or if you have merchant fields enabled, then Internet Expenses displays location fields with a list of values.
Expenses Preferences page
The list of values in the location field contains the sum of all active locations used on all location-based schedules and on enabled merchant fields. For enabled merchant fields, this includes all countries defined for all operating units.
Policy Validation
If the expense report uses both location-based schedules and merchant fields, Internet Expenses applies policy validation in this way:
For receipt-based expenses, if the end user enters a location that is not defined on the schedule but is defined for merchant fields, then policy validation is against the schedule record that uses the All Other value for Locations. If the end user enters a location that is not defined for merchant fields but is defined on the schedule, then policy validation is against the schedule record that uses that location and the merchant field's All Other value.
For per diem expenses, Internet Expenses only uses those locations used on the schedule. In this case, the user must enter the All Other value if no location on the schedule applies.
For locations defaulted from credit card transactions, the defaulted value is validated against the schedule and merchant field's lists of values.
Note: There is no location validation against text-entry location fields.
Defaulting Locations for Credit Card Expenses
For expense reports with location-based schedules, Internet Expenses attempts to default a value in the Expense Location field. Internet Expenses attempts to default a location by finding a match between the location information in the credit card transaction and your location setup. It attempts to find a match in this order:
Look for a match for <city>, <state/province>;
Look for a match for <city> only;
Look for a match for <state/province> only;
Look for a match between the credit card merchant country, if there is one, and country-only location setup.
Internet Expenses only defaults a location if there is one exact match. Internet Expenses does not default a location if there are multiple matches.
You can define a language to use in each available operating unit in your company for approval communications that are sent to users concerning the auditing of expense reports.
The language you define applies to the seeded messages in the Audit Expense Reports page that are used by these functions:
Return Reason (used for Request More Information and Reject)
Standard Instructions (used for Request More Information and Reject)
Audit Issue
Audit Issue Instructions
If you do not define an approval communication language for an operating unit, then Internet Expenses uses the operating unit base language.
Note: Text entered by auditors and users always displays in the language it was entered in.
You can define a future-date tolerance for each available operating unit in your company. A future-date tolerance determines how Internet Expenses manages the submission of future-dated expense reports. Employees can submit future-dated expense reports according to the values that you specify.
Note: Future-dated expense reports are allowed only in a multiple organization environment.
You can define a warning tolerance and an error tolerance for each operating unit. A warning tolerance sends the user a warning message after the specified number of days. An error tolerance prevents submitting future-dated expense reports after the specified number of days.
You enter tolerance values in days. Internet Expenses adds the number of days you enter to the system date to determine the tolerance level. If you enter a tolerance value of 0, then users receive a warning or cannot enter an expense date greater than the system date.
Note: To prevent problems with time zones, Internet Expenses adds one day to the future-date tolerances that you define.
Oracle Internet Expenses has a Contact Us global link at the top of each page. By clicking this link, users can communicate with the designated contact in your organization. To determine what the link opens, you configure Contact Us with the contact types described in this table.
Contact Type | What Contact Us Opens |
---|---|
Create Service Request | Oracle iSupport service request create flow |
Create Service Request (Remote Instance) | Oracle iSupport service request create flow |
Disabled | Not applicable; the Contact Us global link is not rendered |
E-mail Composer | E-mail composer window, addressing the help desk by default |
Formatted Page with E-mail Routing | Formatted Web page where users can enter questions or problems to send to the help desk through e-mail |
URL | Help desk Web page |
By defining rules, you determine the Contact Us behavior based on specified criteria. For example, your organization's help desk is organized by region. You can define a rule for users in the Americas region to access an e-mail composer window, and another rule for Asia Pacific users to create a service request.
Determine the contact types to use. Consider whether your organization implements Oracle iSupport (either on the same or a different instance as Internet Expenses), relies on e-mail to communicate with the help desk, or has a Web page for contacting the help desk.
Tip: To determine whether Oracle iSupport is on a remote instance, contact your system administrator. In general, iSupport is on the same instance as Internet Expenses if the server name in the URL for the Internet Expenses home page and the iSupport Create Service Request page are the same. If not, then Oracle iSupport is remote.
Configure Oracle iSupport and Oracle TeleService if you are using the Create Service Request or Create Service Request (Remote Instance) contact type. See: Integrating with Oracle iSupport and Oracle TeleService.
Define rules if you are using multiple contact types. See: Defining Contact Us Rules.
Test your rules. See: Testing Contact Us Rules.
If you are using the Formatted Page with E-mail Routing contact type, optionally personalize the submit and confirmation pages.
Enable personalization, and click Contact Us to open the formatted page and personalize it as needed, for example by modifying prompts or hiding fields. See: Oracle Application Framework Personalization Guide.
Contact Us rules, including the default rule, let you determine what users get when they click the Contact Us global link. Set a default contact type to enable the Contact Us link, or select the Disabled contact type to disable the link.
If you enable the link, you can also define any number of additional rules to apply specific contact types, including Disabled, based on responsibility, organization, user, language, or any combination thereof. In each rule, you specify criteria that must be true for a specific contact type to be used.
When users click Contact Us, the rules engine evaluates the rules based on your defined sequence, until the first rule with valid criteria is found. The contact type defined in that rule is used to determine what the Contact Us link opens. If no rule criteria are true, or no rules are defined other than the default, then the default contact type is applied.
You must enter attributes for any contact type you select, as described in this table.
Contact Types | Attributes You Enter |
---|---|
Create Service Request |
|
Create Service Request (Remote Instance) | The ID of the default service request type and product, as well as information about the remote instance that Oracle iSupport is on. Contact your system administrator for the remote server protocol, name, and port. For the IDs, see: Finding IDs for Remote Instance Attributes. |
Disabled | None. |
E-mail Composer | The e-mail address of your help desk. |
Formatted Page with E-mail Routing | The e-mail address of your help desk. |
URL | The URL of your help desk Web page. |
Log in to the remote instance and use a Service responsibility.
Query the service request type you want to use. See: Setting Up Service Request Types, Oracle TeleService Implementation and User Guide.
From the Help menu, select Diagnostics > Examine.
In the Examine Field and Variable Values window, enter:
Block: TYPES
Field: INCIDENT_TYPE_ID
The number that appears in the Value field is the service request type ID.
Log in to the remote instance and use an Inventory responsibility.
Search for the item that you want to use. See: Searching for Items, Oracle Inventory User's Guide.
From the Help menu, select Diagnostics > Examine.
In the Examine Field and Variable Values window, enter:
Block: MATCHING_ITEMS
Field: INVENTORY_ITEM_ID
The number that appears in the Value field is the product ID.
After Contact Us rules are initially defined or subsequently updated, create test cases to test the rules. Based on parameters you enter for the test, you can find out which contact type would be used given the defined rules. For example, you specify Spanish as the session language in the test case, and a Contact Us rule was defined with Spanish as a criterion. The test results would provide the contact type and corresponding attributes that were defined in this rule.
You can also test the rules against an expected or desired result. For example, you want the Contact Us link to open the help desk Web page if the session language is Spanish. The test would inform you if the actual behavior is different, so that you can correct the rules to get the desired result.
Contact Us rules must be defined. See: Defining Contact Us Rules.
Familiarize yourself with the rules so that you can create test cases with relevant parameters and expected results.
Specify one or more parameters for the test case.
Click Get Results to run the test.
The test evaluates your parameter values against the Contact Us rules, to determine the rule with matching criteria and the corresponding contact type that would be used. The result fields are automatically populated with the test results.
If the results are not valid, check your rule definitions.
Note: Internet Expenses lets you enter your own results if you decide to create test cases before defining the Contact Us rules. You would not click Get Results, but proceed to the next steps and run the tests from the main test case page, after the rules are defined.
Optionally enter a unique test name and save the test.
From the main test case page, you can update or rerun saved test cases, and even run all the saved tests at one time.
If the expected results from one or more test cases do not match the actual results, Internet Expenses lists those tests and lets you either investigate the discrepancy or accept the actual results as the expected results. Accepting actual results automatically updates the result fields in the relevant test cases.
Define exchange rate behavior for each operating unit in your company. Internet Expenses uses the definitions that you enter to validate the exchange rates that users enter for foreign currency receipts. Exchange rate behavior applies only to cash and other expenses, and not to credit card expenses.
If a user enters an exchange rate value, or overrides a defaulted value, the value entered is validated against the current exchange rate definitions. If the exchange rate value violates these definitions, Internet Expenses responds according to the setting of the OIE: Enable Policy Validations profile option. See: Specifying Values for Internet Expenses Profile Options.
Note: The exchange rate that defaults into a self-service user's expense report is not necessarily the exchange rate from the GL Daily Rates table, but the policy exchange rate, which is the GL Daily Rates table exchange rate plus any allowance that you set in the Define Exchange Rate Behavior page.
A common situation that necessitates validating exchange rates is when users enter the inverse rate of what they should enter. For example, if the currencies involved in an expense report are British pounds sterling (GBP) and US dollars (USD), the conversion rates approximate to 1 GBP for every 1.5 USD, or 1 USD for every .67 GBP. Users traveling from the United States to the United Kingdom should use a receipt exchange rate of .67 but may instead enter 1.5. Internet Expenses then treats this as a policy violation out of tolerance.
You set exchange rate behavior definitions for each operating unit in the Define Exchange Rate Behavior page. The definitions for exchange rate behavior include the defaulting behavior of an exchange rate into an expense report, exchange rate types, exchange rate percentage allowances, and exchange rate tolerances for individual currencies.
Important: You must define exchange rates for the currencies that you intend to use on expense reports before you set up policy schedules. If an exchange rate is not defined for a reimbursement currency, then Internet Expenses cannot record any policy violations that may occur on the applicable expense lines.
Prerequisites
Check the Use Multiple Currencies box.
Check the Require Exchange Rate Entry box.
To set up exchange rates
Navigate to the Exchange Rates page.
The Exchange Rates page displays the active operating units and their current exchange rate definitions.
Click Define Defaults to navigate to the Define Exchange Rate Behavior page.
If necessary, use the Search Function to display the operating unit records that you want.
Navigate to the first operating unit record.
Select the Enabled check box.
Set exchange rate behavior
Set the basic exchange rate behavior and allowances for each operating unit.
In the Default Exchange Rates field, select:
Yes to default the exchange rate without allowance.
Yes, with Allowance to default the exchange rate with allowance.
No to enter an exchange rate manually.
User Definable to let the user decide whether to default exchange rates.
Selecting User Definable activates the Default Exchange Rates check box in the Expenses Preferences page. Users can check this box to default exchange rates into their expense reports, or leave the box unchecked to enter exchange rates manually.
Enter an Exchange Rate Type.
Enter a value in the Exchange Rate Allowance % field. The Exchange Rate Allowance field is used for the following purposes:
To define any policy violation limits.
Internet Expenses will detect a policy violation only if you enter a value in this field. If this field has no value, then Internet Expenses will not detect any policy violations, regardless of whether or not defaulting is enabled.
To default an exchange rate with a percentage allowance. This field is only used for defaulting purposes if the Default Exchange Rate Fields is set to Yes.
When the field is used for defaulting purposes, the value you enter increases the exchange rates in the GL Daily Rates table by the percentages you enter. For example, you can add a percentage allowance to allow for less favorable rates for travel abroad.
In the Default Tolerance % field, you can enter an exchange rate fluctuation tolerance to use for all currencies in this operating unit. The fluctuation tolerance is applied to the base exchange rate plus the exchange rate allowance percentage that you previously defined, if there is one. The base exchange rate is the exchange rate derived from the GL daily rates table for the applicable currency on the applicable expense date.
The defined exchange rate is the base exchange rate plus any allowance that you defined.
The fluctuation tolerance lets users enter a value for the exchange rate above the defined exchange rate without generating a policy violation.
Note: Tolerances are enforced only when the OIE: Enable Policy profile option is set to Prevent Submission and the value in the Default Tolerance % field is not null. See: Specifying Values for Internet Expenses Profile Options.
Define tolerance levels for individual currencies
Use the Define Tolerances page to define an exchange rate fluctuation tolerance for individual currencies. This is useful, for example, for countries that experience significant fluctuations in their short-term exchange rates.
Click the Tolerance Details icon to display the Define Tolerances page.
Use the Search Function to display the currencies that you want.
In the Tolerance % fields, enter the fluctuation tolerance for each currency.
In the Default Tolerance % field, enter the fluctuation tolerance to use for all other currencies in this operating unit. If you define tolerances for individual currencies, then you must enter in this field the fluctuation tolerance to use for all currencies not specifically defined.
Save your work.
Once you define tolerances for individual currencies, the Individual Currencies Tolerance % column in the Exchange Rates page is set to Yes.
Repeat steps 5 to 13 for each operating unit.
Related Topics
Conversion Rates, Oracle General Ledger User's Guide
Duplicate detection rules detect duplicate business expense claims which can be applied globally, across multiple operating units or only to a single operating unit. Internet Expenses uses the rules that you enter to define attributes that will be utilized to process and mark expenses claims as duplicates.
You can define expense category specific or generic duplicate detection rules.
Navigate to the Duplicate Detection subtab using the Policy tab.
On the Duplicate Detection Rules page, you can create new rules, update existing rules and delete rules.
Note: Duplicate detection rules can be deleted only when it has not been assigned to any entity that is to an operating unit or global rule assignment.
Navigate to the Duplicate Detection Rules page.
Click Create Duplicate Detection Rule.
Enter the name of the rule.
Enter the rule description.
Select the type of rule.
Note: Selecting the "Generic" type, will set the rule for all expense categories. Generic rule type is available at the time of creation of rule set and also for assigning at Operating unit.
Only the seeded expense categories appears in the rule type field for selection.
Select the expense report attributes for the detection rule.
The required attributes are as follows:
Employee
Receipt Date
Expense Category
The optional attributes are as follows:
Expense Type
Receipt Amount
You can also select expense category specific attributes for each expense category. These allow you to further narrow down your duplicate detection.
These attributes help you to set up the duplicate detection processing. For example, if a rule is created with the required attributes and the expense type is "Mileage", then if an employee is creating two expense claims for the same date and category for the expense type "Mileage", the employee would not be allowed to create such an expense claim (if rule is set to "Prevent Submission", see rule action details in the following section.)
Select the checkbox if you want to consider all expenses with employee listed as an attendee.
When this check box is selected, Internet Expenses checks the availability of the employee (expense report owner) as an attendee or recipient in all the submitted reports for other employees' along with the other applicable duplicate detection attributes or rules enabled in this rule.
Note: Internet Expenses considers contingent workers, such as temporary employees, consultants, and contractors, as non-employees. Contingent workers are not considered for this rule.
Enter the number of times a duplicate expense allowed for the rule. By default, it will be zero. If you set it to 1, then the expense can be made twice.
The following are examples where companies may have duplicate detection policies to allow on a single day for the same type of expense and for the same employee:
You submit expenses for multiple parking on the same day.
You submit expenses for multiple meals on the same day.
You submit multiple bridge tolls on the same day.
You submit expenses for multiple cab rides.
You are claiming Per Diem (including – Free Meals) but during the trip you had invited others (prospects / customers) for lunch and as a business policy such expenses are allowed by the company to be claimed.
Select the action to be taken if a duplicate expense is detected. The following actions can be set for the rule:
Prevent Submission: Employee is not allowed to create expense item stating it is an duplicate expense item.
Warn Users: It would warn the employee of the duplicate expense upon submission but allow the employee to submit the expense item.
Inform Approvers: There is no warning issued but the approvers for the expense item would be informed for the possible duplicate expense.
When duplicate detection is set to "Prevent Submission", to prevent wrongful submission of expense items, the processing is done at multi-row page. So if the employee corrects the error(s) in the details page, the violation would be still visible. To check if the violation is resolved, the employee has to proceed to the multi-row page and click Next to view the updated information.
Click Save, if you want to save the information provided for further use.
Click Apply to create the rule. For the rule to get applied, it needs to be assigned to an OU or Global or to a rule set that in turn needs to be assigned at OU or Global. Only then the rule gets applied for the respective expense category.
Note: Duplicate detection rules can run for a duplicate expense item in the same expense report.
Note: Saved, withdrawn, and rejected expense reports are not considered for duplicate detection.
Note: Un-itemized line can be a duplicate of itemized line.
Note: Only business expenses is considered for duplicate detection and not personal expenses.
A duplicate detection rule set contains a collection of assignments of rules to expense category. Duplicate Detection Rule Sets enables you to assign duplicate detection rules to the seeded expense categories as per their business requirement. You can use these rule sets by assigning them to operating units or have a global assignment that will be used to process duplicate expense claims.
Navigate to the Duplicate Detection subtab using the Policy tab.
You can create, maintain duplicate detection rule sets and help customers by giving a snapshot of the already created rule sets used to detect duplicate expense claims.
Note: If you want to use the same detection rule for all expense categories for an operating unit, you do not need to setup a rule set for that operating unit. By creating a generic rule and assigning that rule to the operating unit, you can achieve the objective of applying the same duplicate detection rule for all the expense categories within an operating unit.
Note: Duplicate detection rules can be deleted only when it has not been assigned to any entity that is to an operating unit or global rule assignment.
Navigate to the Duplicate Detection Rules page.
Click Create Duplicate Detection Rule Set.
Enter the name of the rule set.
Enter the rule set description.
Select the expense categories and the corresponding duplicate detection rule for which duplicate detection rules are to be applied. The rules created for specific expense category are displayed against the respective expense category column in the rule set. For example, if a duplicate detection rule is created for rule type “Accommodation” then this rule is displayed in Duplicate Detection Rule LOV against the expense category “Accommodation”.
Note: The "Generic" rule is given for all expense categories. For "All" expense category, only rule type with "Generic" rule appears.
Note: By not selecting any duplicate detection rule for an expense category, the "All" rule for that expense category will be set. This is applicable only if any rule is present in the “ALL” field. Also no rule is set in the expense category field but when an expense report is entered for a particular category then for that expense, the rule set for "All' gets applied.
Click Save, if you want to save the information provided for further use.
Click Apply to implement the rule set. Only the rule set gets created on clicking apply. For the rule to get applied, it needs to be assigned to an OU or Global. Only then the rule gets applied for the respective expense category.
You can assign duplicate detection rule or rules sets to operating units and also do a global rule assignment. Global rule assignment will come into effect for any duplicate detection processing when no rule or rule sets assigned or found applicable for the relevant operating unit.
Navigate to the Duplicate Detection subtab using the Policy tab.
You can assign and update global rule assignments and having a snapshot of the duplicate detection rule assignments to operating units.
Note: By default, the Duplicate Detection Rules Assignment page displays all the operating units that are selected requiring Internet Expenses definitions.
Navigate to the Duplicate Detection Rules Assignments page.
Click Update for a particular operation unit or for the global rule.
Select the name of the rule or rule set.
Select the Effective Start Date.
Select the Effective End Date.
Click Add Another Row to add a different rule or rule set to the operating unit.
Optionally, click delete to remove a rule assignment. It is allowed only when the Effective Start Date is not entered.
Click Save, if you want to save the information provided for further use.
Click Apply to implement the assignment.
When an expense report is being submitted or is audited, duplicate detection is performed for the expense report line. The following checks are performed:
At first, check if a duplicate detection rule assignment is available at operating unit. If a Generic rule is available, then it is considered for duplicate detection.
If an assignment is not found for the applicable operating unit, the global rule assignment is checked. The order for checking the global rule assignment is the same as for operating unit, that is if a Generic rule is assigned in the rule column, then that rule is considered for duplicate detection.
If the applicable rule is found, then based on the attributes assigned to the rule, the duplicate detection processing is performed.
The same conditions as specified in Step #1 and Step #2 above is also applicable for duplicate detection rule sets also. However in order to determine the applicable rule, the application checks for the rule assigned at the relevant expense category, for example, Meals or Air Travel.
If a rule is not found in the rule set, then the application checks if a rule is assigned to All category in the applicable rule set.
If the applicable rule is found, then based on the attributes assigned to the rule, the duplicate detection processing is performed. While detecting duplicate expense claims, the attribute value setup for Number of Duplicates Allowed defined in the Expense Report template and the applicable duplicate detection rule is also considered. The application first looks at Expense Report template to check for the value defined for the expense item in question. If a value is found then the application marks the expense report line as a duplicate only when the expense line entered and all the earlier submitted expense lines are more than the number entered in the number of duplicates field. If no value is found, then the application goes up the hierarchy and checks for the value defined in the applicable duplicate detection rule.
If no rules are applicable, then it means that duplicate detection is not setup for this expense report line or the deploying organization does not need any duplicate detection.
You can also disable the duplicate detection using the following steps:
In the Operating Unit rule assignment or Global rule assignment page, select the Disable Duplicate Detection rule and assign it. This will stop the detection of duplicate expenses at OU or Global level accordingly.
You can similarly select the Disable Duplicate Detection rule in the Rule Set page and assign it to particular expense categories.
Advances are created in Oracle Payables as prepayment invoice types. Once an advance is paid to an employee, the advance becomes available in Oracle Internet Expenses for application.
You can control the usage of advances in Internet Expenses. You can set up Internet Expenses to let either end users or Payables personnel apply advances. Or, if required, you can let both end users and Payables personnel apply advances.
You control who can apply advances, and update advance details, by setting the OIE: Enable Advances profile option:
No. Neither the end user nor Payables personnel can select an advance on an expense report.
End User. The end user can select an advance, but Payables personnel can only view advances information.
Payables. Only Payables personnel, and not the end user, can select an advance and update advance details.
Both. The end user can select an advance. Payables personnel can both select an advance as well as adjust advance details.
See: Optional Profile Options in Oracle Internet Expenses.
Internet Expenses lets end users or Payables personnel, depending on your setup, apply one advance per expense report.
Note: For this manual application of a single advance in Internet Expenses, the Oracle Payables Apply Advances option must not be selected.
Alternatively, you can let Oracle Payables automatically apply multiple advances to an expense report, if multiple advances are required to cover expenses.
To enable the application of multiple advances in Oracle Payables:
Select the Apply Advances Payables option.
Set the OIE: Enable Advances profile option to No.
Available advances are automatically applied when the expense report is imported to Oracle Payables.
Note: When an expense report is exported into Payables, Payables will automatically apply the oldest available advance to the expense report, if the following conditions are met:
An available advance is not applied to an expense report.
The Payables option Apply Advances is selected.
See: Applying Advances Against Expense Reports, Oracle Payables User's Guide.
For more information on using the Apply Advances option in Oracle Payables, see: Expense Report Payables Options, Oracle Payables Implementation Guide.
Note: Advances that have been selected for application to an employee's expense report are still candidates for application to an invoice in the Invoice workbench.
You determine how remaining advance amounts are handled by setting the OIE: Carry Advances Forward profile option:
Carry Advance Forward. To allow the application of any remaining advance amounts to subsequent expense reports, set the OIE: Carry Advances Forward profile option to Yes.
Do Not Carry Advance Forward. To restrict the application of an advance to only one expense report, set the OIE: Carry Advances Forward profile option to No. Any remaining advance amount must be paid back to the employer.
Note: Countries that rely on document sequencing to assign unique voucher numbers to documents should set the OIE: Carry Advances Forward profile option to Yes. Otherwise, the repayment of remaining advance amounts to the employer could result in internal invoices with document sequencing issues.
See: Optional Profile Options in Oracle Internet Expenses.
This example illustrates one way to manage advance repayments in Oracle Payables.
Example
An employee received an advance of $1,000 USD. $600 USD was applied to an expense report and exported into Oracle Payables. The remaining amount of $400 USD must be paid back to the employer.
Create a debit memo invoice in Payables for the amount the employee must pay back to the employer ($400).
When the refund for $400 is received, create a refund payment in Payables and select the debit memo created in step 1.
Retire the advance:
Create an internal standard invoice for $400.
Apply the advance to the internal invoice.
Note: To ensure that the advance status reflects its true state, Step 3 must occur after the employee has paid back the advance balance.
Set up additional fields for your rate and policy schedules to capture detail information on expense lines. Additional fields can capture expense category information for statutory or company requirements, such as monitoring transaction activity with merchants that have special arrangements with your company, or capture information for individual expense types, such as special company expenses like entertaining customers or employee incentives.
You can set up additional fields that apply either to an expense category or to individual expense types. When a user chooses an expense type that is assigned an additional field rule, or is assigned to an expense category with additional field definitions, the defined fields appear in the Additional Information section of the Expense Line Details page. If you have defined descriptive flexfields for an expense type, these flexfields also appear in the Additional Information section. See: Setting Up Descriptive Flexfields.
When you define additional fields, you set the field behavior of each additional field that you want to use. The available behaviors for each additional field are:
Disabled. The field does not appear (this option is not available for the Merchant fields).
Enabled. The field appears, but entry is optional.
Required. The field appears, and entry is mandatory.
Note: For the Merchant Name settings, the value Required takes precedence over the value Enabled.
Define additional expense fields for an expense category using the Expense Category pages. You set the definitions for an expense category at the operating unit level. The fields you define appear on all expense reports for the given operating unit.
Before you can set up additional fields for an expense category, you must define a list of active operating units. See: Defining Operating Units.
This table describes the additional fields available for each expense category.
Expense Category | Field/Option Name | Purpose |
---|---|---|
Accommodations | End Date | Provide an end date to confirm the validity of this accommodation line. |
Accommodations | Merchant | The name of the accommodation service. |
Airfare | Merchant | The airline name. |
Airfare | Class of Ticket | First Class, Business, Coach. |
Airfare | Ticket Number | The ticket number. |
Airfare | Location From | The originating location. |
Airfare | Location To | The destination location. |
Car Rental | Merchant | The name of the car rental service. |
Meals | Number of Attendees | The number of attendees. |
Meals | Attendees | The names of the attendees. |
Mileage | Distance Unit of Measure | Use Miles or Kilometers as the default unit of measure. |
Mileage | Daily or Trip Distance | Enter either the daily distance traveled or the total trip distance. |
Mileage | Location Fields | Designate the locations traveled To and From. |
Mileage | Vehicle License Plate Number | Enter the license plate number of the vehicle used for travel. |
These exceptions apply to expense category field settings:
Expense type field settings override expense category field settings. For example, if an expense type rule is enabled, the Number of Attendees field and Attendees field for the Meals category are not displayed on Expenses entry pages, even if you set these fields as Enabled or Required in the expense category setup.
If an Airfare policy schedule is used on an expense report, then Class of Ticket is always a required field. This field is not affected by the settings you apply in the expense category setup.
If a Meals policy schedule uses the Daily Sum option of the Daily Limits rule, then the Meals Number of Attendees field and Attendees field are not displayed.
Define additional expense fields for an expense type using the Expense Type Data Rule pages. Use these pages to create rules for capturing additional data for an expense type. The rules you define indicate the behavior for collecting information about employees and/or non-employees for expenses that relate to attendees or recipients.
You first determine whether this rule pertains to employees, non-employees, or both. You then indicate whether to require the inclusion of the employee entering the expense report as an attendee or recipient.
Note: Internet Expenses considers contingent workers, such as temporary employees, consultants, and contractors, as non-employees. Contingent workers do not appear in lists of values that pertain to employees only.
For non-employees, first select the types of attendees and recipients to include in this rule. You can choose as many types as apply. You can also add to the list of attendees and recipient types by adding new lookup codes for the lookup type OIE_ATTENDEE_TYPE. See: Defining Payables Lookups for Oracle Internet Expenses for more information.
Note: If the rule includes non-employee information, you must select at least one attendee or recipient type.
After you select attendee and recipient types, indicate the field behavior to use for each of the additional fields.
The fields you define for a particular rule appear on all expense reports for the given expense types assigned this rule. You assign expense type data rules to expense types in the Expense Report Templates window. See: Defining Expense Report Templates for more information.
Required Attendees and Recipients Validation
If a rule pertains to both employees and non-employees, then the expense report owner (in other words, individual seeking reimbursement) must enter at least one individual other than themselves in either the employee or non-employee table.
Note: If a rule requires the inclusion of the expense report owner as an attendee or recipient, their name will default in the list of employees.
Set up additional fields on detailed expense lines to capture merchant information for expenses incurred in other countries. You can use this information for VAT reporting and for statistical purposes, such as using line-level merchant information when you reclaim VAT paid to domestic and foreign tax authorities for employee expenses, or capturing merchant information required by tax authorities for statutory reporting.
Use the Define Merchant Fields page to define a set of merchant field records. A single merchant field record consists of a particular location and the settings for each merchant field to use with this location. This table shows the merchant fields and their corresponding purpose.
Field Name | Purpose |
---|---|
Merchant Name | The name of the supplier. |
Merchant Receipt Number | The receipt number for this expense line. |
Merchant Tax Registration Number | The supplier tax registration number. |
Merchant Taxpayer ID | The supplier taxpayer ID number. |
Merchant Reference | Additional supplier reference, such as contact name, address, or purchase order number. |
The available behaviors for each field are:
Disabled. The field does not appear (this option is not available for the Merchant Name field).
Enabled. The field appears, but entry is optional.
Required. The field appears, and entry is mandatory.
For each applicable operating unit, create a set of records for every location that your company uses for expenses reporting. You should create records for every country or territory that you report on and claim VAT. You can also create a setting for all locations not specifically defined in the operating unit.
Check the Enabled box to activate merchant usage for each location that you define. You can, for example, define locations and leave the Enabled boxes unchecked to activate usage at a later time. If all Enabled boxes remain unchecked, then Internet Expenses does not use the merchant field functionality for this operating unit.
Note: The Merchant Name field setting in the Merchant Fields page takes precedence over the Merchant field settings in the Expense Fields pages.
After users submit merchant information on an expense report, this information is transferred to the invoice created in Oracle Payables. You can report on merchant information contained in these invoices using the Financial Tax Register. In the Financial Tax Register, set the Third Party Reporting Level parameter to Merchant. See: Financial Tax Register, Oracle E-Business Tax Reporting Guide for more information.
Before you can set up additional merchant fields, you must:
Set up countries and territories.
Define locations for Internet Expenses. See: Setting Up Locations.
Define a list of active operating units. See: Defining Operating Units.
Set profile options for tax calculation. See: Integrating with Oracle System Administration.
Set up Oracle Payables for tax calculation and reporting. See: Setup Steps in Oracle Payables.
To set up merchant fields:
Navigate to the Merchant Fields page.
The Merchant Fields page displays a table with the available operating units and their update history.
Click the Define icon for the first operating unit that you want.
Internet Expenses displays the Define Merchant Fields page for the selected operating unit.
Enter a location in the first Country/Territory field.
You can only enter countries and territories that you use in location records.
Set the behavior of each of the merchant fields.
Check the Enable box to activate this record.
Note: If you have set up tax calculation, then activated records are immediately available for expenses entry.
Repeat steps 3 to 5 for each location that you want to define.
In the header region, set the behavior of each of the merchant fields for all locations not defined in the table.
The header region becomes activated once you check at least one Enabled box.
Save your work.
Repeat steps 2 to 8 for each operating unit.
In the Use Policy subtab, you can define the policies for credit card usage and enforcement of transaction submission.
Defining credit card policies
Use the Define Credit Card Usage page to set your usage policies. Usage policies encourage employees to use their corporate credit cards for certain expenses. You can limit the amount of cash expenses an employee can report for certain expense categories. Employees who exceed the predefined limit receive a message reminding them to use their corporate credit card for this kind of expense. The auditor and manager are also notified of the policy violation.
On submission, you will be shown a Final Review and Confirmation page which will warn you of the final submitted expense amount.
Important: If OIE: Enable Policy profile is set to 'Prevent Submission' and the cash receipt exceeds the amount defined on 'Define Credit Card Usage', the application will only provide a warning that the amount has exceeded the defined amount but would NOT prevent you from submitting the expense.
Defining credit card transaction submission policies
Use the Enforce Credit Card Transaction Submission page to encourage employees to submit their credit card expenses promptly. You can enforce submission by setting an age limit for the transactions. Internet Expenses compares the system date to the posted date of the transactions to determine if a transaction is older than the limit. If an employee has unsubmitted transactions older than the age limit, the employee is prevented from submitting cash only expense reports until they submit at least one outstanding credit card transaction.
You can use credit card expense mapping to default expense types when users select and add transactions to expense reports. Use card expense mapping rules in Internet Expenses to associate your credit card provider's transaction codes with card expense types. Transaction codes, such as MIC (Major Industry Codes) or SIC (Sub Industry Codes), are assigned to transactions by the credit card provider and are used to indicate the type of goods or service that the transaction was for.
Once you have associated these transaction codes with card expense types, map the expense types in Oracle Payables to expense items. Internet Expenses uses these expense items as the default expense types for transactions during credit card expense entry.
Create a new lookup in the Oracle Payables Lookups window using your credit card provider transaction codes. Enter the credit card provider transaction codes as values for the new lookup. See: Defining Payables Lookups for Oracle Internet Expenses for more information.
If you need additional card expense types, extend the Card Expense Type lookup (CARD_EXPENSE_TYPE) in the Oracle Payables Lookups window.
Define a mapping rule using the new lookup you defined in step 1 as the source. The mapping rule associates the transaction codes with the card expense types. See: Defining Mapping Rules for more information.
In the Card Programs window, select the column that stores the card provider transaction codes during transaction loading. Make sure you select the column that corresponds to the transaction codes that you used in step 1. See: Defining Credit Card Programs for more information.
In the Card Programs window, select the mapping rule you defined in step 3. During validation, the system uses the mapping rule to store the appropriate card expense type value in the FOLIO_TYPE column. See: Defining Credit Card Programs for more information.
In the Expense Report Templates windows, assign the card expense types to expense template items. See: Defining Expense Report Templates for more information.
Note: If you are using the combined load and validate concurrent programs, and you don’t define mapping rules, the FOLIO_TYPE column will either not have a value, or default to one of the following values: Air, ATM, Car Rental, Hotel, or Restaurant.
Process Flow
The system references the Source Column specified for the credit card program to determine which column in the AP_CREDIT_CARD_TRXNS_ALL table to obtain the transaction codes from. For each transaction, the system attempts to match the source column transaction code to the value used in the mapping rule. If a match is found, the system stores the associated card expense type value in the FOLIO_TYPE column. If no match is found, the system uses the mapping rule’s default card expense type value. If no default is provided, the FOLIO_TYPE will be null.
For example:
The default card expense type is set to Miscellaneous
Family Restaurant SIC code is mapped to the Meals card expense type
Fast Food Outlets SIC code is not mapped to a card expense type
The template expense item has the same name as the card expense type
When the validation program is run, Meals is stored in the FOLIO_TYPE column for credit card transactions that have the Family Restaurant SIC code. During expenses entry, the Meals expense type defaults for these transaction. For credit card transactions that have the Fast Food Outlets SIC code, Miscellaneous is stored in the FOLIO_TYPE column. During expenses entry, the Miscellaneous expense type defaults for these transactions.
To define mapping rules:
Create a mapping rule for your provider’s credit card transaction codes.
Log in to Oracle Applications with the user name and password appropriate for the installation.
Select the Internet Expenses Setup and Administration responsibility for the applicable site.
Navigate to the Card Expense Mapping page.
Click the Create Mapping Rules button.
Create a mapping rule for each lookup type that you need by completing the required fields. For the Lookup Type, select the lookup that you created in step 1 of the overview.
Click the Continue button to proceed to create the mappings for the mapping rule.
Create the mappings for the mapping rule.
Choose the default card expense type for the mapping rule. Any lookup codes that you do not define or do not assign to an expense type will be mapped to this card expense type.
Define the mappings for this mapping rule by choosing which source lookup code to associated with which card expense type.
Click the Finish button to complete the mapping.
Repeat steps 1-2 for each set of credit card provider transaction code you need.
Set up your system to download credit card transaction data files from your credit card providers. The credit card data file download works in conjunction with the corresponding credit card loader and validation program to download the data files from the credit card provider.
This process is only available for American Express data files and the American Express Transaction Loader and Validation Program.
Obtain your account details and digital certificate from American Express. Inform American Express that you intend to use the Oracle integration for data file download.
Note: American Express should set up your profile so that you receive an uncompressed file.
You will need the following information:
American Express customer account information, including the user name and password. The Oracle integration uses the same user name and password for the data file download.
American Express digital certificate in PKCS#12 format, .pfx file, along with a password for the digital certificate.
Note: American Express currently provides proprietary software for downloading and uploading files from and to American Express servers. The Oracle integration with American Express does not provide upload services. If you have requirements to upload files to American Express, you must use this proprietary software.
Set up Oracle Wallet. Convert the American Express digital certificate to an Oracle Wallet, and export the Wallet into a BASE64 encoded format.
Note: Because American Express assigns one digital certificate per customer, you only need to set up one Oracle Wallet for all of your American Express card programs.
Create an Oracle Wallet directory and copy the American Express digital certificate into the directory using the name ewallet.p12.
Follow the examples below (for UNIX or Windows), where:
Mykeys.pfx is the digital certificate
/some/dir/wallet is the Oracle Wallet directory
UNIX:
% mkdir /some/dir/wallet% cp Mykeys.pfx /some/dir/wallet/ewallet.p12
Windows:
C:\> mkdir C:\some\dir\walletC:\> copy Mykeys.pfx C:\some\dir\wallet\ewallet.p12
Important: Because the digital certificate is used by the American Express Transaction Loader and Validation concurrent program, you must use a directory residing on a host on the concurrent processing tier. In addition, the directory should have restricted access, with Read access for the concurrent program.
Launch the Oracle Wallet Manager according to the examples below (for UNIX and Windows).
UNIX:
% $ORACLE_HOME/bin/owm
Windows:
C:\> cd %ORACLE_HOME%\binC:\> launch.exe %ORACLE_HOME%\bin owm.cl
Open the Oracle Wallet by entering the directory where you created the Oracle Wallet. In our examples, the UNIX directory name is /some/dir/wallet and the Windows directory name is C:\some\dir\wallet.
Oracle Wallet prompts you for a password. Enter the password that American Express provided for the digital certificate.
If necessary, update the password using the Oracle Wallet Change Password command.
Export the Oracle Wallet using the Oracle Wallet Export Wallet command. Oracle Wallet prompts you for a file name.
Use any naming standard in keeping with your business requirements, and provide read access to the file for the concurrent program.
Create a download directory for the American Express data files.
The directory requires Read-Write access for concurrent programs, and should have limited access for all other users.
If the file downloads occur through a proxy server, set the WEB_PROXY_HOST profile option with the proxy server name and the WEB_PROXY_PORT profile option with the proxy server port.
Define the data file transfer parameters for each American Express card program that you intend to use. See: Defining Data File Transfer Parameters for more information.
After you complete the tasks for credit card data download, you can use the American Express Transaction Loader and Validation Program to download credit card transaction data files from American Express. The concurrent program downloads the file into the secure directory that you created and names the file <concurrent program request id>.amx. The program does not delete any files from the directory. See: American Express Transaction Loader and Validation Program, Oracle Payables Implementation Guide.
Use the Data File Transfers pages to set up the data file transfer parameters for each applicable card program. This table describes the values to enter for each parameter.
Parameter Name | Description |
---|---|
Wallet Path | The full path to the exported Oracle Wallet. |
Wallet Password | The Oracle Wallet password. |
Username | The user name provided by American Express that identifies your customer account. |
Password | The password for the American Express customer account. |
Remote Filename | If American Express provided you with a filename for the download from their server that is different from the standard filename based on your user ID, enter the filename. Otherwise, leave this field blank. |
Secure Directory | The full path to the directory where the downloaded data files are stored. |
Server | The name of the American Express server to connect to for the data file download.
Note: The server name is normally mgw06.americanexpress.com. American Express also provides the server mgw02.americanexpress.com for data file transfer testing. |
If the data file download is unsuccessful, the system displays one or more error messages to help you isolate the source of the problem. An unsuccessful data file download is normally due to a problem with one or more of these areas:
Setup of the Oracle Wallet or the card program data file transfer parameters
American Express server
Loader and validation concurrent program
Network environment
You should check all of your setup values and settings for all of the programs involved in the download. If you are using a proxy server, ensure that the proxy server and port are set properly.
For American Express server and concurrent program problems, you can install and use the American Express proprietary software to download the data files from the American Express server. If the data file download using the American Express software is unsuccessful, then the server is the likely cause of the problem. If the download is successful, then the concurrent program is the likely cause.
The concurrent program log files lists the downloaded filename and any error messages, if errors occurred during the download.
If you need to use the American Express software to download the data files, you can still upload the files to the AP_CREDIT_CARD_TRXNS_ALL table using the concurrent program. Run the program using the American Express filename as the value for the Data File parameter.
Use the Credit Card Transactions Page to view the credit card transactions that were uploaded to the database. Internet Expenses can only validate transactions from accounts that are activated. See: Credit Cards Process Activities and Process Invalid Credit Card Transactions Process for more information.
Note: You can only view credit card transactions for organizations that you have access for. Access is granted through the MO: Security Profile profile option. See: Specifying Values for Internet Expenses Profile Options for more information.
New credit card accounts that are detected during upload are displayed on the New Credit Card Accounts page. Internet Expenses attempts to automatically match credit card accounts to the names of individuals in your organization. If an account is not automatically assigned, you must assign the accounts before the accounts can be used by the account owners. See: Process Unassigned Credit Cards Process for more information.
Assigning Accounts
To assign an account:
Navigate to the New Credit Card Accounts page.
Search for the records you wish to assign.
Click the Assign icon for the account you wish to assign.
Choose the name of the individual you want.
Click Apply. Accounts are automatically activated when they are assigned.
Activating Accounts
To activate an account:
Navigate to the New Credit Card Accounts page.
Click the Activate icon for the account that you wish to activate.