The following table provides a quick reference to the Element Entry Wizard - Setup Ribbon and its functions.
Excel 2007 or Later
Icon
Description/Functionality
Setup Visibility
Once your set-up is done you may not want your users to change the set-up so you can hide the setup ribbon.
Three options:
Show at Start-up– The setup menu always appears.
Hide at Start-up– The setup menu is hidden but can be found using:
View > Macros > ShowWizardToolbars and click ‘Run’.
Hide Permanently– The setup menu is hidden and cannot be displayed. Revert back to a copy of the original workbook to display the menu.
Login Method
You can choose one of the following methods for logging in:
Standard Login– This will use Single Sign-On where available.
Alternative Login– This will use application level sign-on.
Standard Login (SSO Bypass)– This will use Single Sign-On Bypassand can be used if you have SSO installed but want to bypass the SSO mechanism. The user will be authenticated to the internal FND_USERS table rather than the external SSO.
Default Browser Login- This will use the default browser on your PC to display the EBS Login page. This is the best method to use if the ‘Standard Login’ method does not work for you.
Debug Upload
For the five ‘Debug Upload’ options mentioned below, the user will be under instruction from More4apps Support (used for Support purposes only). The default value is ‘Debug off’ unless instructed by More4apps to change:
Debug off– Disables any of the above options that are enabled.
Debug mode– Turns on the More4apps debug facility to generate debug messages to assist with product troubleshooting.
DB Trace mode– Generates a database trace for database Version 9i.
End to End Trace– Database trace generated for performance analysis and product troubleshooting.
End to End Trace Unlimited Size- This option allows the maximum size of trace files created whilst debugging to become unlimited. This resolves the scenario when trace files are too large that they were being truncated.
A message box will be displayed when this option is chosen allowing the user to cancel and not set the trace off:
“Please only use this under More4apps advice. A very large trace file may be created. If you are unsure, please use the End to End Trace’ option rather than the ‘End to End Trace Unlimited Size’ option”.
Edit Template
Show or Hide Template worksheet.
If you modify the master template, subsequent worksheets created using the ‘New Sheet’ button will be based on this template.
This functionality is not recommended for Element Entry Wizard as the fields/columns are largely determined by the set up of the Element and should not be modified.
This sheet stores the current logo that is used by default in the Wizard templates but can be changed at the user’s discretion.
This button will allow you to customize your list of values.
Export URL
Export Login Configuration Settings to New Sheet.
The login configuration allows you to store links to multiple instances of Oracle Applications. Create a new blank sheet (insert worksheet) and click on this icon. The current login configuration will be copied into cell A1. This can then be copied into another workbook (into cell A1) and imported using the option below.
Import URL
Import Login Configuration Settings from Current Sheet.
The login configuration that has been copied into cell A1 of the current sheet will be used to set up the list of instances available in this workbook.
