The following table provides a quick reference to the Special Information Wizard - Setup Ribbon and its functions.
Excel 2007 or Later
Icon
Description/Functionality
Setup Visibility
Once your Setup is done you may not want your users to change the Setup, so you can hide the setup ribbon.
There are 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 or contact More4apps.
Alternatively, you can raise a support case via our website and attach the Wizard you are using, and we will be able to reinstate the ribbon and return this version to you.
Login Method
Choose one of the following methods for logging in:
Standard Login– Will use single sign-on where available.
Alternative Login– Will use application level sign-on.
Standard Login (SSO Bypass)– 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”.
This icon is used for support purposes to record the details of an upload when an issue is encountered. When an upload is undertaken a new ‘More4apps’ worksheet will be created and will be used for the support team to resolve any issues.
By default, this will be set to ‘OFF’.
Edit Template
This button will 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.
Note: This Wizard has a Template Form that should be used to select the special information type and associated columns to display in the worksheet. In most cases it will be unnecessary to modify the template worksheet directly.
A form will open that will enable you to select a special information type and associated fields that need to be included in new worksheets.
You can subsequently re-open this form and select other special information types and create worksheets with different layouts for different purposes.
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 Setting 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 worksheet.
