r12 uploading a journal using web adi

8/15/2019 R12 Uploading a Journal Using Web ADI

1/12

R12 UPLOADING A JOURNAL USING WEB ADI : STEP BY STEPPosted by Raju ERP

This is very useful r!i"le re#r$i%# We& ADI usi%# $uri%# u'l($i%# $! (% (r"le)

R12 U'l($i%# J(ur%l usi%# We& ADI : S!e' &y S!e'

Overview:

Web ADI brings Oracle E-Business Suite functionality to the deskto !here the fa"iliar

#icrosoft E$cel% Word% and Project alications can be used to co"lete your OracleE-Business Suite tasks&

'he Web ADI integration !ith #icrosoft E$cel enables you to bring your E-Business

Suite data to a sreadsheet !here fa"iliar data entry and "odeling techni(ues can beused to co"lete Oracle E-Business Suite tasks& )ou can create for"atted sreadsheets

on your deskto that allo! you to do!nload% *ie!% edit% and create Oracle E-Business

Suite data& +se data entry shortcuts ,such as coying and asting or dragging and

droing ranges of cells or E$cel for"ulas to calculate a"ounts to sa*e ti"e& )ou canco"bine seed and accuracy by in*oking lists of *alues for fields !ithin the

sreadsheet&

After editing the sreadsheet% you can use Web ADI.s *alidation functionality to*alidate the data before uloading it to the Oracle E-Business Suite& /alidation

"essages are returned to the sreadsheet% allo!ing you to identify and correct in*alid

data&

Key Features

Oracle Web ADI includes the follo!ing features0

Works Via Internet

Web ADI uses Internet co"uting architecture to lo!er the total cost of o!nershi byha*ing the roduct centrally installed and "aintained& 1o installation is re(uired on

client "achines2 you need only a Web bro!ser and #icrosoft E$cel& 'his architecture

also ro*ides suerior erfor"ance o*er a WA1 or dialu connection% since the

e$change bet!een client and ser*er is si"lified through the use of 3'#4&

Presents E-Business Suite Data in a Spreadsheet Interfae

Sreadsheets ro*ide a fa"iliar interface that is co""on in the business en*iron"ent&)ou can use fa"iliar editing caabilities such as coying and asting data% and "o*ing

ranges of cells to create or edit large a"ounts of data& Recurring data entry is ossible

http://www.oracleappshub.com/general-ledger/11i-uploading-a-journal-using-web-adi-step-by-step/http://www.oracleappshub.com/general-ledger/11i-uploading-a-journal-using-web-adi-step-by-step/http://www.oracleappshub.com/general-ledger/11i-uploading-a-journal-using-web-adi-step-by-step/


2/12

by sa*ing a sreadsheet% and then uloading it at needed inter*als% such as e*ery "onth

or e*ery (uarter& Sreadsheets offer additional fle$ibility in the !ay !ork is done2 they

can be sent to others for aro*al or re*ie!% and they can be edited !hen disconnectedfro" a net!ork&

Va!idates DataAll data in the sreadsheet can be *alidated against Oracle E-Business Suite business

rules before it is uloaded& 'his includes *alidation against key and descriti*e

fle$fields& Data is *alidated against accounts% seg"ent security rules% and cross*alidation rules& If any errors are found% "essages are returned directly to the

sreadsheet% enabling you to correct the errors and successfully uload the data&

Ena"!es #usto$i%ations

)ou can use the layout functionality to deter"ine !hat fields aear in your

sreadsheet% !here they aear% and if they contain default *alues& 'hese definitions

can be sa*ed% reused% and "odified as needed&

&uto$atia!!y I$ports Data

Wed ADI auto"atically i"orts data into your Web ADI sreadsheets !hene*er youcreate the"& 'his infor"ation can co"e fro" the Oracle E-Business Suite or fro" a te$t

file& I"orted infor"ation can be (uickly "odified in E$cel% *alidated% and uloaded to

the Oracle E-Business Suite& 'his feature can be useful !hen "igrating data fro" a

legacy syste" to the Oracle E-Business Suite&

'sin( We" &DI

'he Oracle E-Business Suite task you erfor" on the deskto is deter"ined by theintegrator you select in Web ADI& Each integrator is deli*ered !ith the E-Business Suite

roduct that ro*ides the functionality being integrated !ith the deskto& Additional

infor"ation secific to each integrator can be found in the roduct-secificdocu"entation&

)ou can access Web ADI functionality through a Self Ser*ice link on your ersonal

ho"e age&

Prere)uisites

'he follo!ing are the rere(uisites for Web ADI0

5 6lient P6 !ith Windo!s #E% Windo!s 1' 7&8 ,!ith Ser*ice Pack 9 or later%

Windo!s :888% Windo!s ;P% or Windo!s or Web ADI to !ork !ith #icrosoft E$cel :88:?:889% you "ust change the "acro

settings for E$cel :88:?:889& 'o do so0


3/12

/0 In E$cel% fro" the 'ools "enu% select *aro% then Seurity% then Seurity 1eve!&

,0 Select the @#ediu"@ otion&

.0 Select the 2rusted Soures tab&

30 Select the @'rust access to /isual Basic Project@ otion&

Steps need to perfor$:

& )ou need to "ake sure underline resonsibility should be attached to your user id&WEBADI +ser linked to the correct Set of Books attached to your resonsibility&

4avi(ation: Syste$ &d$inistrator --5 Seurity --5 'ser --5 Define0

:& 'hen go to Oracle WEBADI Resonsiblity

4avi(ate: Ora!e We" &DI --5 #reate Dou$ent0

http://1.bp.blogspot.com/-Bkj2KgFwNRE/UVGB-8vUtmI/AAAAAAAABP0/SBQgEtn4Wyo/s1600/c1.jpg


4/12

.0 Se!et the Inte(rator

'his is first ste % !here you need to select the Integrator% there are nu"ber of integrator a*aible but you

to choose one of the" for each te"late&

6lick on 1e$t button&

30 Se!et the Viewer

'his is first ste % !here you need to select the *ie!er% there are nu"ber of *ie!er a*ailable but you to

choose one of the" for each te"late&

http://3.bp.blogspot.com/-pU4qG34mCxI/UVGDg8-YZrI/AAAAAAAABQI/d3agcHKfVYU/s1600/c3.jpghttp://2.bp.blogspot.com/-uPB28WR_Nt8/UVGDDFOUwuI/AAAAAAAABQA/gR-MPxQqKC4/s1600/c2.jpg


5/12

6lick on 1e$t Button&

60 #!ik on the Drop down on the Viewer fie!d0

)ou can see these are the different otions a*ailable for *ie!er&

70 Out of a"ove $ention !ist you need to hose 8E+e! ,.80 *ake sure E+e! ,.9 is insta!! in your

$ahine

http://3.bp.blogspot.com/-e2tZSOkA48k/UVGFjjdONeI/AAAAAAAABQs/Lw2XGb40soY/s1600/c6.jpghttp://3.bp.blogspot.com/-jISmk17Bk_c/UVGFH1ngauI/AAAAAAAABQk/B8syd0iXm7A/s1600/c5.jpghttp://4.bp.blogspot.com/-TVawrvDXXAc/UVGEdGwFZnI/AAAAAAAABQc/CMW1cwjXB_Q/s1600/c4.jpg


6/12

)ou should take a if the reorting flag is ticked you !ill not be able to uload the ournal& #ake sure this

should be unchecked&


0Se!et the !ayout

select the layout fro" the list !hich !e !ant&


;0Se!et ontent:

Select a 6ontent to i"ort data into your docu"ent& 6reate an e"ty docu"ent by selecting

1one&


http://2.bp.blogspot.com/-b1qANPE9T5Y/UVGHdqQ53cI/AAAAAAAABRE/f1sxOWPT97Q/s1600/c9.jpghttp://1.bp.blogspot.com/-Ei6hdXAFqzo/UVGHGGnvT4I/AAAAAAAABQ8/Ch7Wkt4YtHQ/s1600/c8.jpghttp://1.bp.blogspot.com/-cOrT1Od_yl0/UVGGaPrfx6I/AAAAAAAABQ0/L20kjU31Bz0/s1600/c7.jpg


7/12

6lick on 6reate Docu"ent&

6lick on Oen button&

6licking to this button !ill create docu"ent in e$cel :889% you need to !ait for fe! seconds untill thescreen !ill enable button&

Once docu"ent get created you can oen do!nload the e$cel % it !ill take so"e ti"e to get the

the te"late ready for uload&Once te"late loading get co"leted% close the confir"ation

!indo!&

http://2.bp.blogspot.com/-FANia6qITTI/UVGIscIeI0I/AAAAAAAABRU/_KZ_BXTsODY/s1600/c11.jpghttp://1.bp.blogspot.com/-M0cG-6NHd8s/UVGIB3F8ilI/AAAAAAAABRM/aaIkP9NcXb4/s1600/c10.jpg


8/12

Once !e get confir"ation click on close button&

'his is docu"ent !hich is ready for uload&

'o enter *alues into the fields Double 6lick on the !hite field to the right of the colored cells&

'his !ill oen a subsidiary !indo! to gi*e the find otions fro" the 4ist of syste" set *alue

otions&

)ou need to select by clicking on the Radio style button% and click on the Select Button&

When all the details of the ournal is entered% using double click 4ist of /alues search tool% click on the

Oracle #enu&

4avi(ate to 'p!oad:

http://3.bp.blogspot.com/-TTgewxTbF8c/UVGNQBhE_uI/AAAAAAAABRs/Q2BEnsDdWmk/s1600/c13.jpghttp://4.bp.blogspot.com/-GF2CnvkfXYA/UVGJQYeXG8I/AAAAAAAABRc/elTve0Vbrxw/s1600/c12.jpg


9/12

Select all the +load Para"eters

http://3.bp.blogspot.com/-3P07nJbfqS0/UVGOuz15cZI/AAAAAAAABSA/afdez86W3_A/s1600/c15.jpghttp://4.bp.blogspot.com/-qvIeGHFTGuc/UVGONENJSfI/AAAAAAAABR4/Vr2vI2JXyQE/s1600/c14.jpg


10/12

)ou !ill find these otions for Ro!s to +load

• All Ro!s - 'his ignores !hether an indi*idual ro! is flagged% and uloads all ro!s

• >lagged Ro!s - When ro!s are tyed into% a >lag sy"bol is entered auto"atically into the

>lagged colu"n& If you cut and aste into the sreadsheet% the flags !ill not auto"atically be entered&

'hey can be forced into the colu"n by tying a 6aital O% !hich generates the sy"bol% this can be

dragged do!n using the E$cel Autofill facility&

• /alidate before +oad - 'his checks for *alid account co"binations before sub"itting the

ournal&

• Auto"atically Sub"it ournal I"ort - 'his 'riggers the ournal I"ort function in Ceneral

4edger&

• 6reate Su""ary ournals - Where Su""ary Accounting is e"loyed% the Su""ary ournals !ill

be generated&

• Descriti*e >le$fields

o Do 1ot I"ort - 'his relates to any e$tra Descriti*e >le$fields added to the ournal

4ayout

o I"ort !ith /alidation - 'his otion allo!s for the e$tra >ields to be transferred% !ith

*alidation&

o I"ort !ithout /alidation - Allo!s all data to transfer to the Ceneral 4edger

1e$t you need to click on +load to initiate the 'ransfer to C4% and if the Auto"atically Sub"it journal I"ort otion is checked% the Ceneral 4edger ournal i"ort is triggered

6onfir"ation of the success of the sending and the triggering of the i"ort is dislayed&


11/12

Success indicators ,Creen S"iley faces aear

1o! you can check the journal +load confir"ation screen !ith the ournal I"ort Re(uest I D

nu"ber is dislayed

http://1.bp.blogspot.com/-MpRljVZLJ1o/UVGR6AS0tyI/AAAAAAAABSg/LQLidTHsIsI/s1600/c18.jpghttp://4.bp.blogspot.com/-1fyrkjA2O30/UVGQIh81DiI/AAAAAAAABSU/jhgyWb1LqUw/s1600/c17.jpghttp://3.bp.blogspot.com/-dp1nGGI-6t8/UVGParPreKI/AAAAAAAABSM/-CriQN5WzhY/s1600/c16.jpg


12/12

)ou can check this is standard Oracle% see the final outut and the rogress of the ournal i"ort&

)ou can *alidate this is oracle&

1a*igation0 Ceneral 4edger -- ournal -- Enter

Enter the follo!ing ara"eters for searching the journals&

Sources0 #anual

Period0 an-9

6ategory 0 Adjust"ent&

6lick on find&

http://orafnappssetups.blogspot.in/2013/03/r12-uploading-journal-using-web-

adi.html
http://4.bp.blogspot.com/-e2AQ7WCC2Ws/UVGSasgRPuI/AAAAAAAABSs/f41OMF1FqOQ/s1600/c19.jpg

r12 uploading a journal using web adi

Documents