Webadi_ Create a simple Webadi implementation journal upload (case)

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