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.

Dig Deeper on Oracle applications implementation and upgrades

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.