R12 : Uploading a Journal using Web ADI : Step by Step

Posted on May 7th, 2008 by Sanjit Anand | Print This Post | Email This Post

In last two post we have seen , Web ADI is a Browser based application, which enables users to log into the Oracle database and upload ADI spreadsheets, without having the ADI application installed onto the users machine.We have already seen step by step setup in 11i , now this post is extension of previous post with a case of R12.

1. Responsibility: As mention earlier WebADI User linked to the correct Set of Books for your business. In R12 , the starting point would be responsibility called Desktop Integration

2. Navigate: Create Document

This is one of submenu you have to choose , to create a document first.

3. Select the Viewer

4. Click on the Dropdown on the Viewer field.

5. Select Excel 2003. make sure Excel 2003 will be install in your desktop.

If you marked the reporting flag is ticked you will not be able to upload the Journal, Make sure that the Reporting box is Not ticked for Journal Upload.

6. Click on Next

7. The Select Integrator window opens

8. Click on the Integrator Dropdown

9. Select the General Ledger - Journals Option

10. Click Next

11. Select the layout
12. Click on the Dropdown for the Layout Field.
13. Select the Layout option.

• Budgets - Multiple
• Budgets - Single
• Foreign Actual - Multiple
• Foreign Actual - Single
• Functional Actual - Multiple
• Functional Actual - Single
• The options are therefore:
• Functional or Foreign currency
  • Actual or Budget Balances
  • Multiple or Single spreadsheet

14. Having selected the option, Click on Next

15. Select whether you want to use a ‘Flat File’ source spreadsheet for the Journal, if so, you can select Text File - If you choose this option, you will be offered to browse to the file to use. If you select None, then you are offered a blank Integrator Layout to fill in yourself.

16. Select None.

Here you should note, If on checking the summary of all the options you have selected, and you want to change any of the options, you can click on the Back button, and re-select the options.

17. Click on Next and at the end , you will get Extra button for Create Document, that mean your document template is already created.

Now you can see the template get created.

Now this is your document, now you can use this to upload this.Rest of the stuff will be very similar to WEDADI in R11. Please refer to earlier article.

Suggested Reading

• WebAdi : Desktop Integration makes life easier
• 11i Uploading a Journal using Web ADI : Step by Step
• R12 Uploading a Journal using Web ADI : Step by Step