The following table provides a quick reference to the Item Extension 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.
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.
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– This will use single-sign-on where available.
Alternate Login– This will use application level sign-on.
Standard Login (SSO Bypass) -This login method is available from Oracle EBS 11.5.9 onwards and 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”.
Format Sheet
Show or Hide Template worksheet. If you modify the template worksheet, subsequent worksheets created using the ‘New Sheet’ icon will be based on this template.
This sheet also stores the current logo that is used by default in the Wizard templates but can be changed at the user’s discretion.
This icon provides options to create new Templates, modify attributes of existing Templates or delete obsolete Templates.
Secure Modes
The secure modes option allows users to only have access to individual modes for transaction entry, upload and download. Individual modes can be removed by clicking the ‘Remove’ checkbox on the form and this will disable the mode.
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 workbook.
