Download - Web Adi Sample
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 1/26
ORACLE WEBADI
Introduction:
There are basically two ways to enter data into Oracle: by typing it into a user
interface (Java Form or Web Page) or by taking a file and programmatically
interfacing the data Web !"# falls into the second category in that it takes an $%cel
file and programmatically loads the data into Oracle #f you find it easier to enter
data into $%cel than Oracle forms& you should look into using Web !"#
Downloading a Web ADI
The first step in downloading a template is to locate the responsibility and menu that is linked to
that template. Some templates can be downloaded from the Desktop Integration menu andothers must be downloaded from a specific responsibility. For security, some templates are
linked to specific responsibilities. For example, we can download the G !ournals template fromthe Desktop Integration responsibility but we can"t download the #ro$ect Transaction Import
template from the same responsibility.
To download a template you will use the following components% integrator, &iewer, layout, and
content. 'ased on how the menu is setup, some of these components may default for you.
Integrator
The integrator defines what data you will be uploading to (racle. )ach integrator ser&es a
specific purpose and cannot be used to enter other data.
Viewer
The &iewer is the *icrosoft program you will use to enter data into the template
Layout
The layout is how the data columns are organi+ed on the template. ou ha&e two main sections
to a template% a header and lines. The header information applies to all the lines when the data is
uploaded to (racle.
Content
The content is a text file that you can import into your template. ou can use this feature if youha&e an external system that outputs text file and you want to import that into the template.
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 2/26
Pre-requisites for working on Deveo!"ent or use
of WEBADIs
'heck the value for profile option named *$ !llow *o +ecurity ,ule and set the
value to -es
2. Enable the Macros options for your ecel sheet
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 3/26
+elect $%cel option to set the properties
lick on .rust entre /0 .rust center +ettings
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 4/26
+elect 1acro +ettings /0 $nable all macros and check the option .rust access to the
2! Pro3ect ob3ect model
-pply and sa&e your settings
-ssign responsibility (racle )'-DI or Desktop Integrator to do the de&elopment of new
)'-DIs
!tep by !tep "rocedure for #ploading data through Web ADI
$usiness re%uire&ent '
e need to insert a new supplier details through -#I in supplier table
-ttached sample code for reference
CREATE OR REPLACE PACKAGE BODY APPS.xx_supplier_creation
AS
PROCEDURE supplier_import_pr (
p_vendor_number VARCHAR2,
p_vendor_name VARCHAR2,
p_enabled_flag VARCHAR2,
p_vendor_type_code VARCHAR2,
p_invoice_currency VARCHAR2,
p_payment_currency VARCHAR2,
p_term_id NUMBER,
p_payment_method VARCHAR2
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 5/26
)
AS
l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
-- l_vendor_rec l_vendor;
l_return_status VARCHAR (10);
l_msg_count NUMBER;
l_msg_data VARCHAR2 (240);
l_vendor_id NUMBER; l_party_id NUMBER;
error_exp EXCEPTION;
err_payment EXCEPTION;
BEGIN
l_vendor_rec.segment1 := p_vendor_number;
l_vendor_rec.vendor_name := p_vendor_name;
l_vendor_rec.ext_payee_rec.default_pmt_method := pi_payment_method;
l_vendor_rec.enabled_flag := p_enabled_flag;
l_vendor_rec.vendor_type_lookup_code := p_vendor_type_code;
l_vendor_rec.start_date_active := SYSDATE;
l_vendor_rec.invoice_currency_code := p_invoice_currency;
l_vendor_rec.terms_id := p_term_id;
l_vendor_rec.payment_currency_code := p_payment_currency;
fnd_msg_pub.initialize; ap_vendor_pub_pkg.create_vendor (p_api_version => 1.0,
p_init_msg_list => 'F',
p_commit => 'F',
x_return_status =>
l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_vendor_rec => l_vendor_rec,
x_vendor_id => l_vendor_id,
x_party_id => l_party_id
);
If pi_payment_method NOT IN ('Check','Clearing','Electronic','Wire','Pre-Purchase Aggrement')
then
RAISE err_payment;
END IF;
IF l_return_status = 'E'
THEN
RAISE error_exp;
END IF;
EXCEPTION
WHEN err_payment
THEN
raise_application_error ( -20000, 'Please check the PaymentMethod in the List of values');
WHEN error_exp
THEN
raise_application_error (-20000, l_msg_data);
WHEN OTHERS
THEN
raise_application_error (-20000, SQLERRM);
END;
END;
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 6/26
/
(. Creating Integrator'
/a&igate to 0esponsibility10*S eb -DI2reate Document
In that select Integrator has )* Integrator !etup
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 7/26
2hoose the )xcel (ptions has 3445, 3446 etc which is rele&ant to your desktop
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 8/26
Select the ayout has Integrator Setup for creating new Integrator
Select the 2ontent has /(/)
Then Select 2reate Document
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 9/26
Gi&e (pen to open the file
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 10/26
#lease wait until your document has been created
/ow the document has been created, 2lick 2lose button
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 11/26
This is how the excel file looks like for creating integrator in this )72) sheet some of
the fields are (8 , to see which of the fields double click on the each column ist of
8alues will be displayed
'y using )' -DI we can 9pload, Download and 9pdate the records into the system.e should create our custom integrator according to our business re:uirement. 1ere we
need to upload data so 2hoose 20)-T) has *etadata Type.
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 12/26
Similarly enter the below details for other columns)nter below Details and click on (racle ;< 9pload a&ailable under toolbar
+iled ,a&e Value
Metadata -ype 20)-T)
Application !hort ,a&e 29ST(*
Integrator #ser ,a&e Supplier DetailsView ,a&e
+or& ,a&e G)/)0-
A"I "acage ,a&e xx_supplier_creation
A"I "rocedure ,a&e supplier_import_pr
Interface #ser ,a&e Supplier Details
Interface "ara&eter List ,a&e Supplier=details
A"I -ype #0(2)D90)
(nce you enter the details Go to -ddIns(racle9pload
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 13/26
/ow you successfully created your Integrator.
/. Define the Layout for the integrator
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 14/26
/a&igation ;< Desktop Integrator ;< Define ayout ;< Select your custom integrator name
2lick on 2reate for creating a new layout.
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 15/26
Gi&e any name for the ayout
/ow all the a&ailable fields will be displayed which has been used in the #rocedure parameters
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 16/26
The layout is di&ided into two important sections;
>. *e%uired fields, where all mandatory parameters need to be aligned as per the re:uirement.
Instruct parameters can be used to pro&ide some tips to users who are using this )'-DI for
uploading data
3. 0ptional fields are non mandatory fields, we need to select the ones which needs to bea&ailable in our custom integrator
2lick /ext ? To define certain important layout features ? This functionality is a&ailable only to 0>3
users
• Data Entry *ows ? 9sing this property we can define the default number of rows which the -DI
will create when initiali+ed, in >>i we user had to insert the new row in case of access data
• *ead 0nly ? 9sing this feature we can define that which of the columns in our integrator will be
a&ailable as read only
• Width ? 9sing this option we can define the width of each of the columns which will be
a&ailable under the custom -DI
•Mo1e #pDown ? we can re;arrange the order of display of column in our integrator
ayout is Successfully 2reated
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 17/26
/ow you )'-DI will be a&ailable for use using seeded )' -DI responsibility
/a&igation ;< Desktop Integrator;< 2reate Document ;< Search for the custom integrator which
you created
2lick next and click on create the document which will now download your custom integrator
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 18/26
2lick on 2reate Document and please wait till the document has been created.
(ur document has been created with the needed fields
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 19/26
(nce the document has been created, please enter the details for creating new &endor.
e can also create exception in the procedure for &alidating any of the data.For example
In the abo&e example #ayment method should be entered only within the mentioned list ,
which we described in the procedure. If user enters any of the other &alues it has beencaptured and the error message has been notified to user for that particular row
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 20/26
/ow the error has been cleared by changing the payment type has 2heck and
> 0ow has been successfully uploaded
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 21/26
e can check the inserted row in the below table
-#=S9##I)0S or #(=8)/D(0S@8iewA
Integrator user name can be deri&ed from bne=integrators=&l table with help of following :uery%
select integrator_code, user_namefrom bne_integrators_vlwhere 1 = 1and user_name like 'Supplier%Details'order by creation_date desc
B.Defining the +or& +unction for Integrator
' Define the custom Form Function
/a&igation ;< -pplication De&eloper ;< -pplication ;< Function
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 22/26
Type ; SS- ser&let function
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 23/26
#arameters
bne%pageC'ne2reateDocbne%&iewerC'/)%)72)3446bne%reportingC/bne%integr
atorC9S)0=/-*)%Supplier Detailsbne%nore&iewCes
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 24/26
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 25/26
/ow you can /a&igate to your custom responsibility to see the -DI which you ha&eassigned.
2lick next and 2reate document and your custom integrator is a&ailable to user for uploading data
8/13/2019 Web Adi Sample
http://slidepdf.com/reader/full/web-adi-sample 26/26
.hank -ou