1) Select "Oracle Web ADI” responsibility and click on "Create Document" function.
2) Select the viewer, generally Excel, to generate the document.
3) Select our custom Integrator from the list of available integrators.
4) Select out layout we defined in our earlier steps.
5) Select "None" on the Content tab.
6) Review and click on Create Document.
7) This will create and excel sheet with all the columns we defined in the layout. Fill the excel sheet with the data we want to upload.
8) Click on Oracle -> Upload and wait for it to upload the records.
Upon successful upload, a smiley icon is shown for each record.
NOTE :- Integrator commits only if all rows are uploaded successfully.
We can check the results from the database to verify the success .
That’s it.. We have created our Integrator and used it to upload data into Oracle Apps using WebADI !!!!!!
Cheers
~Neeraj
6 comments:
This is great.
Do you know how to call PL/SQL program or concurrent program after validation process like GL upload.
Thanks
Dinesh
Dinesh,
Do you want to call Conc Program after u load data using Integrators ?
Regards
Neeraj
do u have any idea how to automatically submit a Concurrent Request after the upload completes
Can i add own LOVs to spreadsheet columns of webadi
Hi Neeraj
Please can you tell me how to display error messages in the Messages field in Excel Sheet.
I have to do some custom validations in the API procedure which i am creating and display the error messages in spreadsheet if any errors.
In R12, Oracle Web ADI resp has been discontinued. This functionality is missed.
Post a Comment