WebADI - Creating Integrator Layout

In my earlier posts, we saw steps involved in WebADI Creating Custom Integrators and steps involved to Associate Function with Custom Integrators.
Now, continuing with WebADI custom Integrators, we need to define a layout. This layout actually defines how the XLSheet will look like for uploading actual data.

1) From “Oracle Web ADI” responsibility, click "Define Layout: function to create a Layout for existing or Custom Integrators.



2) Next select the Integrator we created in earlier steps.



3) Click Define Layout, give Layout a name and Layout Key.



4) Click Continue. The next screen shows all the procedure parameters.
Choose as Header if the value should remain same for all data lines or Line if the value changes for each line. See the screen shot below. Click Apply.
For complex layouts, we need to first identify Header and Lines at the start itself.



5) That's it !! We are done. And ready to use this custom integrator to load data into Oracle Apps without coding or programming anymoer.


Cheers
~Neeraj