2014-06-01 Baoxinjian
I. Summary
Webadi the original fixed asset import and the journal import some tools to develop, because the finance department personnel mostly very familiar with Excel, hoped unexpectedly possibly as much as possible uses the Excel tool to carry on the financial operation
Webadi provides a possibility to import data into EBS via Excel, by creating customized APIs or interface processing
In 11i, Webadi may not be perfect enough and requires a lot of code manipulation and registration
In R12, the function of Webadi is further strengthened.
Personally feel that if the data import API or interface is not too frequent, the amount of data is not too much, the use of Webadi is a very good choice, can be very effective to improve user interaction
However, if the data import is very frequent, the volume is very much, as far as possible to avoid the use of Webadi, you can use other import technology, such as Sql_loader
Second, the case
Requirements: Create a simple Webadi to enable journal import to custom staging table
1. Establish integrator
2. Establish interface
3. Building Content
4. Establish uploader
5. Establish importer
6. Define the layout that corresponds to this Webadi
(1). Define Layout Header
(2). Define the location of each layout element
7. Testing
(1). View the resulting Excel document
(2). Query the table data results after uploading
III. implementation of the case
1. Establish integrator
2. Establish interface
3. Building Content
Ignore
4. Establish uploader
5. Establish importer
Ignore
6. Define the layout that corresponds to this Webadi
(1). Define Layout Header
(2). Define the location of each layout element
7. Testing
(1). View the resulting Excel document
(2). Query the table data results after uploading
Thanks and regards