Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Migrating data to legacy system as functional consultant

What are the steps to be followed when migrating data from a legacy system as a functional consultant? What are the important interface tables that should be kept in mind?

What are the steps to be followed when migrating data from a legacy system as a functional consultant? What are the important interface tables that should be kept in mind?
As a functional consultant, leave the interface tables to the technical people. Your conversion concerns should always include (but are not limited to):
  • Data cleanup
    • Clean it up in the legacy system? Clean it up in Oracle? (Just be consistent!!!)
  • Numbering
    • Ex: Invoice numbers must be unique. Do they want Oracle to generate this, do they have their own identifier or do they require a custom solution?
  • Legacy information
    • Ex: The unique identifier from the legacy system may not be needed in Oracle, but it is nice to have when validating a conversion. You can store it and other legacy information in Descriptive Flexfields. If the data does not need to be seen in the application, do not enable the Flexfield so the data will remain hidden.
  • Load validation
    • First, know your standard Oracle reports for the module: what is on them, how they group the data and what the parameters are. Find out if there are reports in the Legacy system you can have run to compare with your Oracle reports. If the numbers on both reports match, then the load is a success.
    • If you cannot use reports, then have the technical people extract the data from Oracle and compare it to the legacy data files.
  • Setup
    • Profile options
    • Any default accounting
    • Multi-Org, currencies, conversion rates
  • Future needs
    • Reporting
    • Growth (number of transactions, purging)
    • Is this a one-time conversion or will it become an ongoing interface?
Hope this helps.
This was last published in July 2006

Dig Deeper on Oracle E-Business Suite

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close