The following table provides a quick reference to the Application Interface Wizard - Setup Ribbon and its functions.
Icon
Description/Functionality
Setup Visibility
Once your set-up is done you may not want your Users to change the set up, 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.
Login Method
There are three login methods available:
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 Bypass 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.
Debug Upload
For the 5x ‘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”.
The Template123 can be modified so that new worksheets are created based on the modified format.
For Application Interface Wizard this could be used to put in a custom logo.
Store Password
You can protect your worksheet after data-entry to prevent further changes. However, you must store the password in order to use the upload/validate functions.
Click on this button and store the password that you have used to protect the worksheet.
The Manage Templates icon provides options to create new Templates, modify attributes of existing Templates or delete obsolete Templates.
Import Template
The Import Template icon enables templates stored as XML files on your PC to be uploaded into the Wizard.
Toggle DBMS output
To see the results of DBMS Output messages from your code, set this profile to 'Create DBMS Output'.
When the data is uploaded a new worksheet will appear in the Wizard workbook displaying all DBMS Output messages.
Select 'Ignore DBMS Output' to suppress this functionality.
Note - The Sheet can simply be hidden, or deleted when finished with. DBMS Output messages will only be displayed for the last row loaded where there are multiple lines.
Export URL
Export Login Configuration Settings to separate sheet.
This option is only applicable to the ‘Oracle EBS’ connection method.
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 separate sheet.
This option is only applicable to the ‘Oracle EBS’ connection method.
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.
