R12 Uploading a Journal using Web ADI : Step by Step

By
Advertisement



R12 Uploading a Journal using Web ADI : Step by Step

Overview:

Web ADI brings Oracle E-Business Suite functionality to the desktop where the familiar
Microsoft Excel, Word, and Project applications can be used to complete your Oracle
E-Business Suite tasks.
The Web ADI integration with Microsoft Excel enables you to bring your E-Business
Suite data to a spreadsheet where familiar data entry and modeling techniques can be
used to complete Oracle E-Business Suite tasks. You can create formatted spreadsheets
on your desktop that allow you to download, view, edit, and create Oracle E-Business
Suite data. Use data entry shortcuts (such as copying and pasting or dragging and
dropping ranges of cells) or Excel formulas to calculate amounts to save time. You can
combine speed and accuracy by invoking lists of values for fields within the
spreadsheet.
After editing the spreadsheet, you can use Web ADI's validation functionality to
validate the data before uploading it to the Oracle E-Business Suite. Validation
messages are returned to the spreadsheet, allowing you to identify and correct invalid
data.

Key Features

Oracle Web ADI includes the following features:

Works Via Internet
Web ADI uses Internet computing architecture to lower the total cost of ownership by
having the product centrally installed and maintained. No installation is required on
client machines; you need only a Web browser and Microsoft Excel. This architecture
also provides superior performance over a WAN or dialup connection, since the
exchange between client and server is simplified through the use of HTML.

Presents E-Business Suite Data in a Spreadsheet Interface
Spreadsheets provide a familiar interface that is common in the business environment.
You can use familiar editing capabilities such as copying and pasting data, and moving
ranges of cells to create or edit large amounts of data. Recurring data entry is possible
by saving a spreadsheet, and then uploading it at needed intervals, such as every month
or every quarter. Spreadsheets offer additional flexibility in the way work is done; they
can be sent to others for approval or review, and they can be edited when disconnected
from a network.

Validates Data
All data in the spreadsheet can be validated against Oracle E-Business Suite business
rules before it is uploaded. This includes validation against key and descriptive
flexfields. Data is validated against accounts, segment security rules, and cross
validation rules. If any errors are found, messages are returned directly to the
spreadsheet, enabling you to correct the errors and successfully upload the data.

Enables Customizations
You can use the layout functionality to determine what fields appear in your
spreadsheet, where they appear, and if they contain default values. These definitions
can be saved, reused, and modified as needed.

Automatically Imports Data
Wed ADI automatically imports data into your Web ADI spreadsheets whenever you
create them. This information can come from the Oracle E-Business Suite or from a text
file. Imported information can be quickly modified in Excel, validated, and uploaded to
the Oracle E-Business Suite. This feature can be useful when migrating data from a
legacy system to the Oracle E-Business Suite.

Using Web ADI

The Oracle E-Business Suite task you perform on the desktop is determined by the
integrator you select in Web ADI. Each integrator is delivered with the E-Business Suite
product that provides the functionality being integrated with the desktop. Additional
information specific to each integrator can be found in the product-specific
documentation.
You can access Web ADI functionality through a Self Service link on your personal
home page.

Prerequisites

The following are the prerequisites for Web ADI:
• Client PC with Windows ME, Windows NT 4.0 (with Service Pack 3 or later),
Windows 2000, Windows XP, or Windows 98 installed on it.
• A Web browser supported by the E-Business Suite installed on the client PC.
• Microsoft Excel 2000, 2002, or 2003 installed on the client PC.

Changing Macro Security Settings for Excel 2002 or 2003

For Web ADI to work with Microsoft Excel 2002/2003, you must change the macro
settings for Excel 2002/2003. To do so:
1. In Excel, from the Tools menu, select Macro, then Security, then Security Level.
2. Select the "Medium" option.
3. Select the Trusted Sources tab.
4. Select the "Trust access to Visual Basic Project" option.


Steps need to perform:


1. You need to make sure underline responsibility should be attached to your user id.
WEBADI User linked to the correct Set of Books attached to your responsibility.

Navigation: System Administrator --> Security --> User --> Define.



 

2. Then go to Oracle WEBADI Responsiblity

Navigate: Oracle Web ADI --> Create Document.



3. Select the Integrator

This is first step , where you need to select the Integrator, there are number of  integrator avaible but you to choose one of them for each template.



 Click on Next button.

4. Select the Viewer

This is first step , where you need to select the viewer, there are number of viewer available but you to choose one of them for each template.



Click on Next Button.

5. Click on the Drop down on the Viewer field.




You can see these are the different options available for viewer.

6. Out of above mention list you need to chose 'Excel 2003'. Make sure Excel 2003, is install in your machine




You should take a if the reporting flag is ticked you will not be able to upload the Journal. Make sure this should be unchecked.

Click on Next Button.

7.Select the layout

select the layout from the list which we want.


Click on Next Button.

8.Select content:

Select a Content to import data into your document. Create an empty document by selecting None.


Click on Next Button.

 Click on Create Document.

Click on Open button.


Clicking to this button will create document in excel 2003, you need to wait for few seconds untill the screen will enable button.



 Once document get created you can open download the excel , it will take some time to get the the template ready for upload.Once template loading get completed, close the confirmation window.


Once we get confirmation click on close button.

This is document which is ready for upload.

To enter values into the fields Double Click on the white field to the right of the colored cells. This will open a subsidiary window to give the find options from the List of system set value options.

You need to select by clicking on the Radio style button, and click on the Select Button.



When all the details of the Journal is entered, using double click List of Values search tool, click on the Oracle Menu.

Navigate to Upload:



Select all the Upload Parameters



You will find these options for Rows to Upload
  • All Rows - This ignores whether an individual row is flagged, and uploads all rows
  • Flagged Rows - When rows are typed into, a Flag symbol is entered automatically into the Flagged column. If you cut and paste into the spreadsheet, the flags will not automatically be entered. They can be forced into the column by typing a Capital O, which generates the symbol, this can be dragged down using the Excel Autofill facility.
  • Validate before Upoad - This checks for valid account combinations before submitting the Journal.
  • Automatically Submit Journal Import - This Triggers the Journal Import function in General Ledger.
  • Create Summary Journals - Where Summary Accounting is employed, the Summary Journals will be generated.
  • Descriptive Flexfields
    • Do Not Import - This relates to any extra Descriptive Flexfields added to the Journal Layout
    • Import with Validation - This option allows for the extra Fields to be transferred, with validation.
    • Import without Validation - Allows all data to transfer to the General Ledger

Next you need to click on Upload to initiate the Transfer to GL, and if the Automatically Submit journal Import option is checked, the General Ledger Journal import is triggered

Confirmation of the success of the sending and the triggering of the import is displayed.



Success indicators (Green Smiley faces) appear



Now you can check the journal Upload confirmation screen with the Journal Import Request I D number is displayed


You can check this is standard Oracle, see the final output and the progress of the Journal import.



 You can validate this is oracle.

Navigation: General Ledger --> Journal --> Enter

Enter the following parameters for searching the journals.

Sources: Manual

Period: Jan-13

Category : Adjustment.

Click on find.


 

18 comments:

  1. This is very useful article regarding Web ADI using during uploading data on oracle.

    ReplyDelete
    Replies
    1. I got my already programmed and blanked ATM card to withdraw the maximum of $1,000 daily for a maximum of 20 days. I am so happy about this because i got mine last week and I have used it to get $20,000. Mike Fisher Hackers is giving out the card just to help the poor and needy though it is illegal but it is something nice and he is not like other scam pretending to have the blank ATM cards. And no one gets caught when using the card. get yours from Mike Fisher Hackers today! *email cyberhackingcompany@gmail.com


      Delete
    2. iI’m lauriel from New York, United States. I lost my job a few months back after my divorce with my wife. I tried everything positive to make sure I took good care of my kids but all failed, and I was in debt which makes everything worse. I was kicked out of my home and i had to live with my neighbor after pleading with her to allow me to stay with her for some days while I figured out how to get a home which she agreed to, but no one was willing to help anymore. I bumped into this page from google and I was excited about this, then I contacted the hackersBill Dean. I had just $200, so I pleaded with them to help me because of my condition but they never accepted. I believed in this, so I managed to pawn a few things and got $500. I ordered the $10,000 card and I got my card delivered to me by Ups 4 days later. I never believed my eyes! I was excited and upset as well, I managed to withdraw $2000 on the ATM and $2500 the second day. I went to Walmart and a grocery store and bought a couple of things for $3000. The card got blocked the third day and I contacted them and I was told it's a mistake from my end. I’m so happy, I have started all over again and have a good apartment with my kids you can contact him through is via email (globalatmcardhackingservice@gmail.com)or his whatsap contact (+1 301-887-5071)

      Delete
  2. Really Helpful.. Thanks Raju

    ReplyDelete
  3. Can u tel me how to write validation for each field before loading it

    Thanks in Advance

    ReplyDelete
  4. Can we upload multiple journals for different entity at one go?

    ReplyDelete

  5. BEST WAY TO HAVE GOOD AMOUNT TO START A GOOD BUSINESS or TO START LIVING A GOOD LIFE….. Hack and take money directly from any ATM Machine Vault with the use of ATM Programmed Card which runs in automatic mode. email (williamshackers@hotmail.com) for how to get it and its cost . ………. EXPLANATION OF HOW THESE CARD WORKS………. You just slot in these card into any ATM Machine and it will automatically bring up a MENU of 1st VAULT $1,000, 2nd VAULT $2,000, RE-PROGRAMMED, EXIT, CANCEL. Just click on either of the VAULTS, and it will take you to another SUB-MENU of ALL, OTHERS, EXIT, CANCEL. Just click on others and type in the amount you wish to withdraw from the ATM and you have it cashed instantly… Done. ***NOTE: DON’T EVER MAKE THE MISTAKE OF CLICKING THE “ALL” OPTION. BECAUSE IT WILL TAKE OUT ALL THE AMOUNT OF THE SELECTED VAULT. email (williamshackers@hotmail.com) We are located in USA.

    ReplyDelete
  6. Hey Man! If you want to convert any file to other format then use this;

    File Free Converter

    ReplyDelete
  7. We would like to acknowledge the exceptional service that we received during the entire refinancing process. Mr Lee professionalism and knowledge of the loan company was impressive and truly appreciated. Mr Lee is a reliable loan officer.In the past, we have had experience with several others banks and have found the process frustrating and tedious. Mr Lee went above and beyond to ensure that all of our needs were met and that everything was handled thoroughly and efficiently. We have and will continue to recommend him in the future.”Mr Lee Contact Email /Whatsapp 247officedept@gmail.com+1-989-394-3740

    ReplyDelete
  8. I simply want to say I’m very new to blogs and actually loved you’re blog site. Almost certainly I’m going to bookmark your blog post . You absolutely come with great well written articles. Valentine week 2021

    ReplyDelete
  9. http://softwareerrors.blogspot.com/

    ReplyDelete
  10. I am glad to come here! Thanks for sharing such valuable information with us.
    Bovine Pericardium Tissue
    Transcatheter Valve Consulting

    ReplyDelete
  11. iI’m lauriel from New York, United States. I lost my job a few months back after my divorce with my wife. I tried everything positive to make sure I took good care of my kids but all failed, and I was in debt which makes everything worse. I was kicked out of my home and i had to live with my neighbor after pleading with her to allow me to stay with her for some days while I figured out how to get a home which she agreed to, but no one was willing to help anymore. I bumped into this page from google and I was excited about this, then I contacted the hackersBill Dean. I had just $200, so I pleaded with them to help me because of my condition but they never accepted. I believed in this, so I managed to pawn a few things and got $500. I ordered the $10,000 card and I got my card delivered to me by Ups 4 days later. I never believed my eyes! I was excited and upset as well, I managed to withdraw $2000 on the ATM and $2500 the second day. I went to Walmart and a grocery store and bought a couple of things for $3000. The card got blocked the third day and I contacted them and I was told it's a mistake from my end. I’m so happy, I have started all over again and have a good apartment with my kids you can contact him through is via email (globalatmcardhackingservice@gmail.com)or his whatsap contact (+1 301-887-5071) 

    ReplyDelete