Problem solve Get help with specific problems with your technologies, process and projects.

Uploading legacy data to 11i

What are the best methods and tools to upload data from legacy systems to Oracle Apps 11i?

What are the best methods and tools to upload data from legacy systems to Oracle Apps 11i? We need to upload financial data and inventory data such as accounts, account balances, assets, items, item balances, etc. We have a huge number of items and assets that need to be uploaded to Oracle.
You can use a combination of open interfaces, some of which are listed below, or Oracle's Isetup program, or a program called Dataload (which is non-Oracle in origin, but widely used). Other products exist, but these are most often recommended.

For example, the Inventory Open Interface (IOI) was designed to provide the ability to load large numbers or batches...

of inventory items at regular intervals. If you have 2,000 or more items, or regularly add 100 or more items at a time, you may want to consider it.

Similarly, the Applications Desktop Interface (ADI) can be used to load journal entries from Excel or other feeder applications into GL.

For assets, you may wish to use the Mass Additions Interface in Fixed Assets.

In general, the open interfaces allow you to add data to specific tables, usually via Sql*Loader, then run an interface that performs some level of validation of the data, then loads the applications' tables appropriately.

Oracle has a new product/utility called iSetup which is designed to help install Oracle applications. Its "Chart of Accounts Companion" allows users to define segment values (up to 9) in a spreadsheet and import the values through the loader.

DataLoader -- program from Comstar at http://www.dataload.net/. It uses Excel macros and Oracle forms. Use the link to download the dataloader program and commands.

This was last published in December 2003

Dig Deeper on Oracle applications implementation and upgrades



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.