Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

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

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

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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

menu

2. Navigate: Create Document

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

3. Select the Viewer

4. Click on the Dropdown on the Viewer field.

3

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

4

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
5

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.

6

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.

7

9

Now you can see the template get created.

10

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.

dgreybarrow-2 Suggested Reading

Related Posts

Posted in Oracle General Ledger, Web ADI | 2 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
2 Responses
  1. How to know Web ADI Version ? Says:

    [...] R12 : Uploading a Journal using Web ADI : Step by Step [...]

  2. vijay Says:

    Hi, We have a custom integrator based on custom view. Now we added couple of columns in the view. Now I need steps to replicate those new columns in my layout. Appreciate some help on this.
    Thanks,
    Vijay

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.