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.