How to Upload Oracle Journal Entries From Office 2007

Oracle is a database for information management. According to Search Oracle, the software is designed for "high-end workstations and minicomputers." When uploading an Oracle journal entry from Office 2007, problems will sometimes arise that prevent the upload from going through. The problem stems from the settings in Office 2007, which do not allow the Web Application Desktop Integrator, or ADI, used for Oracle to access the journal. Changing the settings will allow the journal to upload.

Things You'll Need

  • Web ADI
Show More

Instructions

    • 1

      Click the "Office" button in the upper left-hand corner to open the drop-down menu. Select "Options."

    • 2

      Select "Trust Center" and then "Trust Center Settings."

    • 3

      Click "Macro Settings." Click "Disable All Macros With Notification." Check the box by "Trust Access to the VBA Project Object Model."

    • 4

      Open Web ADI. Click "Options" and check the "Enable This Content" button followed by "OK."

    • 5

      Select "Add-ins" on the Office toolbar. Click "Oracle" and then "Upload" to finish the setting changes.

    • 6

      Open the Web ADI. Select "Oracle Web ADI" under the responsibility. Select "Create Document" when prompted.

    • 7

      Pick "Viewer" and then select the Office 2007 program from the list. Click "Next."

    • 8

      Browse the next list to find "General Ledger - Journals." Click on the option and then "Next."

    • 9

      Open the drop-down menu on the next page and select "Functional Actuals - Single" from the available layout options. Click "Next" to bring up the next page.

    • 10

      Browse the options and locate the Office 2007 file to upload in the journal. Review the information and then select "Create Document." The file from Office 2007 is uploaded as a journal into Oracle. Edit as necessary.

Learnify Hub © www.0685.com All Rights Reserved