Oracle EBS Data import method Comparison (中文版) ____oracle

2007.1.23 12:31 Author: showxz | Rating: 0 | Reading: 465

Dataload is isn't an Oracle tool. So, that's sells, which means if you can come up with a better tool, your may sell it and the would be waiting; d

Oracle provides some tools to help data migration.

Api
1. Rocjing mentioned API, and said it is the fastest. This is true. API is isn't a tool, but a term, i.e. a abbreviation for application Procedure. An API was really a (hook) function/procedure provided in Oracle code to create data in Oracle. For example, if you want to create a ' user ' in Oracle, you'll call Fnd_user_pvt.create_user (...) (a lot of parameters). This is procedure API. The Using API is really for a SQL script, and call the API ' s in your script. In another word, which is coding and programming.

INTERFACE
2. Another popular is through interface tables. Almost all Oracle products provide interface tables for high volumn transaction data. For example, AP has Ap_invoice_interface, GL has gl_journal_interface, etc. (Invoices are the basic transactions in AP, Jo Urnals are the basic transactions for GL, etc.) AP may also have a interface table for suppliers, which are also very to common for AP. How do you populate these interface tables? Mostly through uploading spreadsheets, i.e. xsl files (MicroSoft Excel). The key is in a spreadsheet and its target interface table have the same column structure (including column names, Colum N type, column count, etc.).

Oracle also provides tools likeADI to help the upload data from spreadsheetsto interface tables.

Usually after your load your data into a interface table, you'll submit a concurrent program to validate the data and TR Ansfer the real transaction table.

Hence, this is reallya spreadsheet-adi-interface table-import process combination method.

--manual TYPING
3. It is pretty hard to deal with every high volumn data issue in a ideal. So manual typing are sometimes the only way. Even in this case, the users should find ways to use, say, batches, default values, existing auto triggers (like distribution Sets in AP), etc. to reduce the amount of manual typing.

--dataload
4. Dataload is also kind of tools this help, but of course, it isn't ideal in everycase. Dataload is very similar to Oracle ' s regression Test tool, which was very popular the even inside Oracle years ago. Nowadays it is isn't that attractive any more. People just have to live.

Hope This is the a little help for your guys.

What you said is like Interface Tables, which were in Oracle for years. If you have isn't used that, you should find a chance to try. I would say all interface tables were created to support spreadsheets (XSL files), and I believe the ' is ' still the best so Lution.