The Feature

Oracle Internet Expenses Has Grown Up

February 25, 2006 on 12:01 pm | by Marian Crkon | In Reviews | |  Print |  Email

I recently had an opportunity to implement the new Internet Expenses application (10.5.10). I must say I liked what I saw! Anyone remembers Oracle Personal Time and Expenses (PT&E)? It’s a good thing if you don’t. The Internet Expense has matured into a nice, robust and stable application. The timing has worked in our favor, as we were able to utilize most of the new improvements.

What It Can Do…

Oracle Internet Expenses (iExpenses) is essentially an extension of Oracle Payables. It privides a way for employees and contingent workers to enter their expense reports. Employees and contingent workers become suppliers, and their expense reports become supplier invoices in Payables.

Integrate with Other Oracle Applications

• Oracle Human Resources - for one database of valid employees and contingent workers
• Oracle Payables – for seamless and streamlined expense report payment
• Oracle Projects - for billing to customers or internal tracking of costs
• Oracle Approvals Management - for flexible approval rules
• Oracle Grants Accounting - to charge expenses to awards for funds tracking
• Oracle Time and Labor - for common user interface
• Oracle Daily Business Intelligence - for expense analysis, Top Spenders report, and drill-down to line details

Expense Report Entry

• Enter expense reports using a browser, a wireless web-enabled mobile device, or an offline spreadsheet
• Enter expense reports on behalf of others
• Enter expense reports for contingent workers
• Pre-populate expense reports with credit card transactions
• Itemize charge card or cash line items and assign multiple expense types; Enable automatic Hotel Folio itemization based on card feed
• Allocate reports to many cost centers
• Copy saved and submitted reports
• Withdraw reports after submission
• Require or enable projects and tasks
• Require or enable category specific additional fields
• Include advances and refunds as negative amounts
• Default data based on user preferences, including from prior reports
• Calculate mileage and per diem during expense entry or import of spreadsheet
• View approval and payment status on the home page or using a Web-enabled mobile device
• Automatically capture and manage expense receipts online
• View notes, responses and actions in Approval Notes
• View card transaction history, mark items disputed with card provider

Company Policy

• Define company policy for online enforcement
• Define exchange rate defaulting and tolerance checking
• Require receipt by expense type and amount
• Require justification by expense types and upon policy violation
• Require receipt itemization and provide set of expense types for itemization
• Configure descriptive flexfields or additional fields for expense types
• Enable special messages or calculations on review, confirmation pages

Workflow Approvals and Notifications

• Approve expense reports and associated receipts, flag policy violations, and enforce reimbursement policy
• Review details of expenses with supporting receipt documentation on approval notifications
• Optionally require manager and accounts payable approval by exception
• Delegate or transfer approval authority, and handle vacations
• Build flexible approval routing rules and conditions, including line-based and cost center-based approvals
• Notify employees of policy violations, rejection or adjustments
• Notify users of reimbursements and payments to card issuers on their behalf

Charge Card Administration

• Define card usage and transaction submission policies for online enforcement
• Identify employees with outstanding credit card transactions by details or aging
• Automatically notify of unsubmitted card transactions, escalate as needed
• Pay charge card issuer directly on behalf of employees
• Use automatic new account registration
• Map card types for expense type defaulting

… What is New n Release 10.5.10

Expenses Home Page. The Expenses Home Page allows users immediate access to a variety of expense reporting information, workflow notifications, and their corporate credit card account information. It is a nice “portal” where employees can see and manage all expense reports. Employees are alerted to changes and transactions that require their attention and these items are highlighted and linked, so that they can be addressed in a timely and efficient manner. When you click on the Internet Expenses responsibility link, you are taken directly to the Expenses Home page. Because you can access all functions from the Expenses Home page, there is no longer the need to show a list of menu items.

Contingent Workers. It was about time! Non-employees, such as contractors and temporary workers, can now enter expense reports into Oracle Internet Expenses. You set up contingent workers in HR, and associate them with their Vendor record. The service providers who employ them are then paid directly through Accounts Payable. Contingent workers can also be set up to approve reports, enter reports for others, and audit reports.

Expense Allocations. You are now able to manualy override accounting information (for non-project expense lines only!).

Future-Dated Expenses.Expenses process owners can use the setup utility to define whether future-dated expenses should be treated as warnings or errors during expenses entry. This ensures that expenses are not entered into inappropriate accounting periods, which causes reimbursements to be delayed and accounting to be incorrect.

User-Interface Enhancements. Several usability enhancements were made, including browser Back button support and bubble text. In addition to the Internet Expenses Back and Next buttons, you can now use the browser Back button to go back and make changes while entering an expense report, unless the report has been submitted or items were deleted. Bubble text was added for buttons and icons.

Other improvements include:

• Enhanced Approval Rules using Oracle Approvals Management
• Enhanced Approver Entry
• Enhanced Adjustment and Short Pay Processe
• Enhanced Expenses Itemization
• Paperless Audit Rules
• Audit List Rules
• Manager Reporting
• Improved Workflow Notification

… And What It Could Do Better

Improve the Offline Expense Report Upload Importing the Offline Spreadsheet is clunky, prone to errors, unintuitive, and most users stay away from it. How about a WebADI like looking upload, which validates against valid projects, tasks and expense types? Clients also ask for ways to customize the offline spreadsheet so that they could input copany logo, expense policy, etc.

Provide Valid Alternative Approvers Only. The list currently shows everybody in the employee-supervisor hierarchy. Employees can chose Override Approvers, who are not defined as approvers in Payables, and hence, expense report submissions fail. This can be avoided by simply limiting the list of employees in the Override Approver field to valid approved in Payables.

Detail vs. Summary Expense Entry - it would be nice to be able to switch the default expense report layout between summary and detail.

Provide a List of Override Cost Center Values. Users can currently enter only cost centers, but they are unable to choose them from the list.

Expense Report Printing Printing an expense report does not fit to a page! There are a couple of Metalink notes outthere, but no solutions. Please fix this!

Provide customizable views to limit the list of projects, tasks and expenditure types (similar to OTL views).

Improve AME Why provide yet another tool to make the applications work? Why not use Workflow instead? While is is a great idea to provide additional options for expense report approvals, the current AME is far from being the “robust tool forline-based and cost center-based approvals “.

Provide a better solution for CEO Expense Report Approval. The default approval workflow uses the supervisor hierarchy to approve expense reports, i.e. everybody needs a supervisor in order to approver expense reports. Assigning a dummy employee to be CEO’s supervisor is not a good solution.

Allow Cross-Charge between multiple business units for project-related expense reports by engaging Account Generator, even if the initial combination of employee’s default company and override cost center is invalid.

Manage Attachements. Provide a better way for iExpenses Administrators to manage (view, save, print) expense report attachements.

Provide a way to change project-related information for submitted expense reports before they get imported to Payables.

Provide Direct Deposit Intergration with 3rd Party Vendors. Not as much iExpenses feature, but a requirement for better integration with Oracle Payroll, or other Payroll providers like ADP and PeopleSoft. Companies need to be able to reimburse expense reports via direct deposit without replicating bank and bank account information in Oracle Payables. Most employees now have their paychecks deposited directly, and expense reports should be paid the same way.

Additional Information

Check following resources for additional information about Oracle Internet Expenses:

• Oracle Internet Expenses Datasheet (a .pdf file) available at Oracle Applications Home page. Below I provide excerpts from the datasheet.
• Oracle Internet Expenses Implementation and Administration Guide

Share your experience with Oracle Internet Expenses. What is your favorite feature?

Find this and similar articles in iExpenses.

35 Comments »

RSS feed for comments on this post. TrackBack URI

1. Hello Marian,

   I would like to know the auditing feature in iExpense. The steps to use it. I know the old method of approving it from core apps. But i am not able to really figure out the proper steps of using the audit manager resp and approve the expense reports. for some reason they always error out.

   If you have some kind of document other then standard oracle guide can u pls. mail it to me.

   thanks,
   chandan

   Comment by Chandan — September 27, 2006 #

2. Hi Chandan,

   Thank you very much for reading The Feature. I am sorry to hear you are having problems with configuring the audit functionality in iExpenses. What are you trying to do - use a paperless audit, or approve expense reports using the Auditor responsibility? What kind of error did you get?

   Generally, I found the iExpenses User Guide quite useful, if not very intuitive.

   Marian

   Comment by Marian Crkon — September 29, 2006 #

3. Trying to find out if a PO can be created and then an expense report matched to that PO after it has been created in iexpense and transferred to AP. Tried it in a test instance and couldn’t get it to transfer to GL. thks.

   Comment by Julie — January 30, 2007 #

4. Hi Julie,

   I am not sure trying to match an employee expense report to a PO makes much sense. POs are typically issued to order goods or services from “standard” suppliers. Is this an expense report for a contingent worker?

   As for transferring the expense report to GL, make sure the invoice is validated and accounted for.

   Marian

   Comment by Marian — January 30, 2007 #

5. iExpenses needs capability for handling disputed credit card transactions. A card transaction will go through invoicing, payment and then bank rec. At any stage it could be disputed and payments may be reimbursed, requiring in a reversal of the expense entry for that transaction. The contra entry to make will depend on the stage the transaction is in.

   I find nothing in the documentation for that. Is the functionality there? And does anyone have experience coming up with technical solutions or business processes for managing disputes?

   Comment by Nick — April 20, 2007 #

6. Nick,
   Thank you for stopping by. I am not aware of how OIE handles disputed credit card transactions. I am hoping that somebody who knows will provide an answer to your questions. Good luck!
   Marian

   Comment by Marian — April 20, 2007 #

7. Hi,

   How can I get a sample file for Credit Card Transaction data to load and check the internet expense.

   cheers,
   Ranen

   Comment by Ranen — May 17, 2007 #

8. Hi ,

   I need to know that how to chnage the AP SHORT PAID Notification Text which goes to Creator of Expense Report when the Expense Report is Short Paid?

   This is very urgent.

   Kindly help me out .

   Thanks in Advance.

   Regards
   Abhishek Mishra

   Comment by Abhishek Mishra — May 31, 2007 #

9. Is anyone approving the expense report notifications via a mobile device? Please share your experiences. What is the notification type being used. What types are devices are you using? Were there any additional setup to do this?

   Comment by Patrick Gresham — June 1, 2007 #

10. We are using both Blackberry and Windows Mobile devices to perform online approvals as well as iExpense notifications. The trick comes with configuring the user accounts to accept certain types of email.

    Within the Preferences of the iExpense (or other web-enabled app of the eBusiness suite), set the Email Style under the Notifications to ‘Plain text mail with HTML attachments.” This is so that the NID (unique identifier) comes through correctly.

    After the user changes their notification mechanism, the devices will now see the request for approval notifications. Once the email arrives within the device, the user will need to be very specific about the response. Oracle will only accept certain textual responses. They are:

    Approval Action: “Approve”
    Approval Action: “Reject”

    Careful with this though - the default response is to Approve. Ensure that your security is tight on the devices (password, locking, etc) so that not just everything gets approved.

    Comment by Chris Smith — June 19, 2007 #

11. Hi Abhishek,
    As far as I know, short paid expense report is an expense report of negative or zero amount. Oracle applications automatically creates a new expense report for short paid expense report. This new expense needs to be processed.

    Hope it helps.

    Thanks and regards,
    Indira Shukla

    Comment by Indira — July 10, 2007 #

12. Hi

    1. We would like to go to Level 3 Itemization i.e., enables automatic Itemization not only hotel but also Car Rental and Airfare etc.,

    2. We got a XML versionfile from our card provider

    3. We are able to create itemization successfully. But when we are creating the expense report, the expense type is not recogized correctly.

    Could you please tell me why the expense type is not recognized??

    Thanks
    Ravi

    Comment by Ravi — July 12, 2007 #

13. We are in the process of upgrading to 11.5.10 [11i.OIE.J(3618125)] and I would like to use the Amex Upload and Auto Card Creation feature available for Amex in a Multi-org environment. Is there any whitepaper that explains what set-up is required for each org to implement? Is there any additional documentation relating to such a config?

    Comment by Bryan English — October 3, 2007 #

14. Bryan,
    There is a white paper called “How to Set Up Amex Credit Cards for iExpenses available on Metalink > Knowledge Base > Internet Expenses > White Papers.
    Marian

    Comment by Marian — October 3, 2007 #

15. Hi Marian,
    Thanks for the feedback. I had already spotted that one but it didn’t cover Data Retrieval and Auto Card Creation in a Multi-org environment. The I-Expenses manual does discuss this but left me unclear, hence my original question.

    Comment by Bryan English — October 5, 2007 #

16. Hi

    We have a Airway Bill Account bill which is the total bill of all air tickets that are booked and billed each month for employee travel. Right now this is done manually, cost center by cost center, for all of the travel, which is sometimes >$350K a month.
    A friend of mine tells me that she has American Express send her an Excel spreadsheet containing specific information, like passenger name, cost center, ticket number, cost, etc. and that by some “magic” their Accounting group uploads the data right into the GL’s (they use Oracle back office).

    Can someone give me a clue as to how we can set this up? We currently load the amex file into oracle which has the employee cr. card txns.

    thanx
    Lakki

    Comment by lakki — October 26, 2007 #

17. Hi,

    1.I want to know hom many companies are using oracle internet expenses. Can somebody let me know some big companies using it.

    2. is there any major advancements in it.

    Comment by tulsi prasad sahu — November 20, 2007 #

18. is there a way to show on what date and specific time an expense report was withdrawn?

    Comment by Brad Ryan — December 24, 2007 #

19. does anyone know if workflow approvals works via company webmail if not on a vpn or in office?

    Comment by Amy — December 31, 2007 #

20. Amy, the workflow is using employee email addresses stored in HR assignments. And yes, it could receive messages from outside the firewall.

    Comment by Marian — December 31, 2007 #

21. Hi Marian

    i like to know about how iExpense automatically assignes the credit card to Employee ..Is there any concurrenct prgram available for that …

    thanks
    balkrishna

    Comment by balkrishna — January 14, 2008 #

22. Balkrishna,
    This is done as part of the credit card setup for employees. The best place to start will be the iExpenses User Guide. Sorry.
    Marian

    Comment by Marian — January 15, 2008 #

23. Can anyone tell me why instead of an employee’s name, the sstem displays something like PER_ROLE XXXX where XXXX is the employee ID? Thanks.

    Comment by Dee — February 13, 2008 #

24. Can Oracle Internet Expenses be utilized as an expense reporting solution without implementing other Oracle apps? If not, what Oracle apps do I need in order to run Internet Expenses.

    Comment by Paul — June 11, 2008 #

25. No, not really. iExpenses is really just an extended functionality of Payables. It also requires some key HR pre-requisites…

    Comment by Marian — June 11, 2008 #

26. Marian:
    We like to use Internet Expense and currently on 10.5.10.2. Has the import/export spreadsheet features improved since your writing? I have been told to avoid implementing spreadsheet.
    Any suggestions on how to pre-approve expenses before the trip?
    Thanks,
    LS

    Comment by LS — January 14, 2009 #

27. Is there any way to record a prepayment or advance payment to an employee in Internet expenses?
    Or any other process in Expenses where in employees can raise a request for advance payment that later on needs to record as Prepayment Invoice in Invoice Workbench.

    Thanks
    Ranjeet

    Comment by Ranjeet — February 17, 2009 #

28. Hi

    Can you please let me know what is mean by common policy .And can we use multiple policies for one org.We have expense type Meals ,We have attahced country specific policy .But most of the employee travels across world and policy is diff .Can we impliment this .

    Comment by balkrishna — March 3, 2009 #

29. How can an expense report be matched to a requisition (funds reserved for that purpose)?

    Comment by Alok Ojha — March 12, 2009 #

30. Hi,

    Can anyone help me out,how and where exactly is the setups for aging the credit card transactions done.

    ex:’number of transactions more than 365 days on your card :45.please include them in your expense report,before submitting a new one’.

    where can these type of setups be done?

    Thankx in advance,
    Swetha.

    Comment by swetha — April 17, 2009 #

31. Hi,
    Im setting up the OIE, everything works good, except for one user, he can´t see the notifications on the OIE Homepage, but he can see them from the System Administrator Responsibility.

    I review everything, and I dont know where the mistake is.

    Can anybody help me….

    Thanks

    Comment by Cynthia — May 14, 2009 #

32. Cynthia,
    Make sure the user is also a correct workflow user, i.e. his user name is attached to an employee record, his name is not attached to multiple users, and that he has a valid email (if email notifications are enabled). Also make sure to run the synchronize workflow role process, which validates these settings.
    Marian

    Comment by Marian — May 14, 2009 #

33. Hi,
    Does anyone have expertise in implementation of the Internet Expenses Module of Oracle E-BS with Peoplesoft?

    Comment by Madhuri — July 22, 2009 #

34. Hi,

    Are you using the Spreadsheet? If so, which version of Office are you running? Any errors? We are having issues with Office 2007.

    Comment by Kelley — January 11, 2010 #

35. Hi,
    Can I have one employee with 2 credit cards in different orgs (multi org environment)? If possible just give me an idea of how to do this.
    Thx

    Comment by Theo — March 4, 2010 #

Leave a comment