Skip to main content

Journal Entries

 

Where do I download a new webADI template?

Top of page

 

What computer settings must I make for webADI to work correctly?
Settings in Excel 2007:

  • Click the Microsoft Office Button in the upper left hand corner, and then click Excel Options.
  • Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  • Click the options that you want:
  • click to choose- "Disable all macros *with* notification": This will allow you to choose to Enable Macros for ADI templates.
  • click to check box- "Trust access to the VBA project object model." Turn on access by selecting the check box.
  • Click OK to save the settings.
  • Open your webADI template. You should see a Security Warning white bar below the toolbar saying Macros have been disabled. Click Options and the button for "enable this content" and say OK.
  • Then you should have an option on the Excel toolbar called Add-ins -> under Add-Ins choose Oracle -> Upload.

Settings in Internet Explorer (IE) 7 or 8:

  • In IE, open Tools -> Internet Options. On the Security tab, choose "Custom Level". Scroll to the "Scripting" section and Enable all items in that section. Say "Yes" when prompted about saving all selections. Click "OK" to close Tools.

Top of page

 

What log-in do I use when uploading?
To upload or use chart lookups in webADI, sign in using your Oracle username and password, the same one you may use for eProcurement or Procurement Card approvals. Contact “Oracle Processing” if you are not sure what this user name and password are, or to reset your password.

Top of page

 

Why don’t I see Oracle->Upload available in Excel?
Macros must be enabled when the template is opened to be able to upload. Save your work, and close and re-open your template. Look for the Security Warning and choose to Enable Macros. If the Security Warning does not appear when the template is opened, check your Excel settings per the first FAQ.

Top of page

 

Why am I getting an “invalid journal entry line” message when there is no information on that line?
Even if there is no chart string or dollar amounts on a line, if the line has a flag under the Upl column (far left), ADI will try to upload the line. Double-click the flag to make it go away and this error should not recur.

Top of page

 

I have completed data entry but the Oracle Upload command doesn't work. What's wrong?
Make sure that you have pressed Enter or move the cursor off the cell into which you have finished entering data. Otherwise Excel thinks you are still editing that cell and won't allow Upload.

Top of page

 

My entry begins uploading but “stalls”.
Check your Internet Explorer (IE) 7 or 8 settings as described in the first FAQ. These settings need to be adjusted even if you do not use IE as your default browser.

Top of page

 

Why is my chart string invalid/incomplete?
Make sure that you have started entering the value for Entity in the Entity column, not the Upl column to the far left. The Upl column should be left blank; the system may put a flag symbol there but the user won't enter data there. Each chart string segment should be entered in a separate cell with no symbols such as periods or dashes included. If a chart string value begins with zero and this gets dropped (or Subactivity 0000 converts to 0), re-enter the number with a single quote ( ' ) before it so it will be interpreted as text and the beginning zeros will be preserved.

Top of page

 

Who do I contact for assistance with my journal entry?

Top of page

Last Updated: 5/3/10