ADI stands for Applications Desktop Integrator. ADI acts as an interface tool with which a user can upload data into Oracle General Ledger. ADI is mainly used in inputting journal entries into Oracle. ADI works as an add-on to Micrsoft Excel. Data upload through ADI ensures critical validations such as journal entry must balance, restricting posting to previous periods, uploading data to incorrect accounts and cost centers etc. An example of how the excel spreadsheet for Applications Destop Integrator looks like is shown below. Creating journal entries using ADI is a step by step process. I have included a summary of the steps below.

1. Logging On to ADI is the first step. Once you are logged on to ADI select the enter journals icon in the drop down menu to start the journal wizard. To create a journal entry select the functional actuals and single journal entry for a new workbook.

2. The next step is to prepare the journal entry worksheet. Here the user should specify the date, select category of journal entry, adjustment, reversing, reversing accural, accrual etc.

3. Once the date and other parameters for the journal entry have been specified, you can start entering your journal entries. After journals are entered, they would look like the spreadsheet shown in the screenshot above.

4. Once journals are entered, they are ready to be uploaded into Oracle GL. A user is presented with various options at the time of journal upload. ADI gives the option to upload all rows or only flagged rows, pre-validate journals, post account errors to suspense and whether to import descriptive flexfields or not. The options to upload a journal are shown in the screenshot below.

5. Once journals are uploaded, user receives a message that all journals were uploaded. In case errors are encountered during upload of journal entries through applications desktop integrator ADI, user needs to correct the errors and upload again.

6. Once all journals are uploaded into Oracle GL, user needs to review the journal entries uploaded and finally post the journal entries. Posting the uploaded journal entries is the last step in creating journals through ADI applications desktop integrator.

More on Oracle Applications

Oracle Mass Maintainence , Choosing a Set of Books , Cross Validation Rules