The following table provides a quick reference to the AR Invoice API 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 > Show_Wizard_Toolbars and click ‘Run’
Hide Permanently- The Setup menu is hidden and cannot be displayed. Revert back to a copy of the original Wizard to display the menu as you will be unable to display the Setup ribbon again in the current Wizard.
Login Method
Choose one of three 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.
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”.
Edit Template
Show or Hide Template worksheet. If you modify the template worksheet, subsequent worksheets created using the ‘New Sheet’ button will be based on this template.
Customize Fields
This button will allow you to customize Wizard columns by Adding Mandatory indicators, Labels, Comments and Removing columns.
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 button. 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 Setting.
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 Wizard.
