Oracle

Data Conversion Do’s and Don’ts – Oracle ERP Cloud

Seo In Healthcare

Hi Everyone!  If you have stumbled across this blog, I’m sure it’s because you searched “Data Conversion”.

Like most, you have a boss to whom you answer, and your boss wants answers. So having done this now for 20 years and working in the Cloud for the last four, I’m in a pretty good position to help you out.

Let’s Start with the Obvious

Master Data

Do Convert Suppliers, Customers, Item Master

  • Do clean up and rationalization your data
  • Too much rationalization can create “change management” headaches for employees, customers, and suppliers
  • The project timeline and cost can be impacted by rationalization efforts if “overdone.”
  • Measure the cost/benefit of rationalization carefully before embarking on it

Do Convert OPEN Items – AR and AP Invoices

  • Do convert partially paid invoices.  Take remaining only balances to reduce complexity
  • Do not try to match AP Invoices to Purchase Orders, as this will create more dependencies and complexities
  • Do not convert AP or AR Invoices that are not fully accounted for in your legacy system as this will cause reconciliation issues
  • Do clean your legacy system before converting (write off what does not need to be converted, make sure all required invoices are fully approved and fully accounted)

Do Convert GL Balances (minimum 2 years for year over year reporting)

  • Pick a starting point and convert a year-end balance sheet or a full trial balance (Oracle will roll your retained earnings forward)

Do Convert FA Balances

  • If you are converting Mid Year, my advice here is to convert twice.
  • One balance end conversion for your prior year-end, and another Activity Conversion through the current year.
  • This will allow you to have Additions and Retirements reports for the current year in the Cloud. Otherwise, it will be challenging to get reporting out of your new ERP for the current year.
Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

Do Convert Inventory On Hand Balances

  • Do take one last physical Inventory
  • To ensure your standard costs are correct or you use an acceptable average cost

Do REVERSE ALL JOURNAL ENTRIES RELATED TO YOUR SUB-LEDGER CONVERSIONS!

  • Do not delete your journal entries
  • Do create your journals, post them and fully reverse them
    • This will allow easier reconciliation if there are issues in the conversion
    • Deleting entries will disable your ability to audit the conversion in the event of issues

For the Less Obvious

Do Convert Open Purchase Orders

  • Recommend converting open purchase orders for remaining balances due only
  • Attempting to convert the full purchase order will create further complexities in that you will have to convert receiving transactions to close out the remaining items

Do Convert Closed AP Invoices for 1099 Suppliers

  • If converting mid-year, I recommend converting closed and paid invoices within that year for 1099 suppliers only.
    • This will help create 1099s from a single system at year-end.
    • Converting closed AP Invoices will require a “dummy payment run” or additional web services to apply for payments.

Do Not Convert Closed AR Invoices or Closed AP Invoices

  • This adds a lot of complexity to your conversion.
  • Reconciliation is near impossible.
  • Errors are more easily made.
  • If you are concerned about accidentally paying duplicate invoices, discuss other solutions before you convert them.

Do Convert FA Tax Books

  • If you plan on using Oracle’s tax books, it’s much easier to convert into the Cloud than ever before
  • Make sure your tax books are set up with the same rules as in your legacy system; otherwise, data won’t match
  • Expect some differences if there have been corporate revaluations along the way

Do Convert Bank Statements and Un-reconciled Transactions

There are many decisions when it comes to converting your data. Certainly, there are extenuating circumstances and perhaps legal requirements that turn a “Don’t” into a “Do.”  Be sure to discuss with your “team on the ground” either way, so you have a full point of view as to the ramifications to your system if you attempt to take on the more complicated conversions.  They not only can impact timeline and cost but potentially create confusion.

Perficient is here to help! Contact one of our product specialists today or reach out to us by the contact form below and be sure to visit http://www.perficient.com, follow us on twitter (@perficient) and check us out on LinkedIn!

 

 

About the Author

Matthew is the managing director of Perficient's Oracle ERP practice. He has 19 years of experience in Oracle Financial Applications which include 5 large-scale, global, full cycle implementations across multiple industries and multiple countries across Europe and Latin America, plus upgrades across many release of Oracle EBS.  Matthew has extensive application experience in General Ledger, Accounts Payable, Accounts Receivable, and Fixed Assets.  In addition he has managed implementations ranging from 2-3 people to as many as 100 people.  Matthew is personable, and has both excellent written and verbal communication skills.  Matthew has experience conducting workshops– both formal and informal and is charged with driving design sessions.   Matthew’s application experience extends into supply chain modules including purchasing, order management, and inventory, and with that he is able to guide our clients through month end and financial reporting, seamlessly, end to end.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories