The following table provides a quick reference to the Application Interface Wizard Ribbon and its functions.
Icon
Description/Functionality
Log In/Log Out
This will either log you into or out of EBS depending on your status (terminate or reinstate your Oracle database connection).
The icon will change depending on your current status. If you are currently logged in then the icon will show as ‘Log Out’. If you are not logged in the icon will show as ‘Log In’.
About
Displays product and package version information along with licencing and usage data.
You need to click on this button to load a new Licence Key, Modify/add a user of the Wizard or ‘View Usage’.
This button toggles the display of the ‘Login Info’ information on the ribbon.
Select Wizard Mode/Template
This icon will open the ‘Generate template’ form to select a template created by your System Administrator.
This icon will change to display the type of template and template name once selected.
New Sheet
A new worksheet will be created based on the selected template.
If the Template is invalid or not yet selected, the ‘Generate template’ form will appear.
Forms
The ‘Forms’ icon opens the ….??? in the current sheet.
You do not have to use forms, you can copy and paste or key directly into the cells of the worksheet if you prefer.
If you do use these forms, you can make use of the ‘Lists of Values’ and other validation as you are entering data.
Double-clicking in the particular section in the worksheet will also open the required form.
Clear Status Columns
This icon enables you to remove status column information from the worksheet:
Clear Status Columns – This only clears the Status Columns and not the ID’s.
Clear Status and ID Columns – This clears the Status Columns and ID’s. This functionality is helpful if you have downloaded an existing record and would like to clear the ID’s to enable you to use this as a template to create a new record.
Note – If a Wizard does not have ID columns and this option is selected, a message will appear stating there are no ID columns but all statuses have been cleared.
Normalization
Used for formatting data by adding duplicate parent rows based on child rows and removing duplicate parent rows respectively.
Denormalize the data is useful for when you need to sort the data in Excel. Click the Denormalize button and it will duplicate header data for the rows containing child data. Once you are finished sorting the data then you can normalize the data to remove the duplicate headers and prepare it for upload.
Normalize the data is used to prepare data for upload in the Wizard, whether you’ve just denormalized it for sorting or imported the data from an external source with duplicate headers. Normalization will only affect sections that have children with multiple rows of data.
Both functions will affect all the records on the active sheet.
Validate
Choose whether to ‘Validate Selected’ or ‘Validate All’ when uploading lines into the interface table.
This selection is used in conjunction with the ‘Upload Selected’ and ‘Upload All’ rows icon (as shown below).
Upload Selected
The selected rows (as indicated by the cursor) will be validated/loaded into Oracle.
Upload All
All rows in the worksheet will be validated/loaded into Oracle.
Upload Background Upload Selected
All selected rows (as indicated by the cursor) in the worksheet are validated/uploaded and processed using Oracle Concurrent processing.
This is useful when processing large amounts of data and you wish to continue working in the More4apps Wizard.
This process can be viewed using the Requests form in Oracle.
Upload Background Upload All
All rows in the worksheet are validated/uploaded and processed using Oracle Concurrent processing.
This is useful when processing large amounts of data and you wish to continue working in the More4apps Wizard.
This process can be viewed using the Requests form in Oracle.
Download Form
A form will open that will enable you to download information into the worksheet based on selected criteria.
Please note a download query needs to be assigned to the AIW loader template first.
After entering data or information into the worksheet, use your cursor to highlight the details and then use this icon to download all details which are associated with these values.
Please note a download query needs to be assigned to the AIW loader template first.
Submit Concurrent Request – This option submits the concurrent program associated to the Mode.
View Concurrent Request – Enables the user to view the concurrent requests on the Oracle Concurrent Manager.
Refresh Concurrent Status – This refreshes the line status of the records in the spreadsheet after the concurrent request has run. It will show errors or warning messages as applicable.
Delete From Interface– Deletes data from the interface.
Logging
Clicking the button will create a new sheet and name it ‘Debug’ which will record all actions being taken by the Wizard on upload. If a sheet already exists with the name Debug, this existing sheet will be named Debugx where x is the next available number e.g. If a sheet exists called ‘Debug’, it will be renamed ‘Debug1’. If a sheet exists called ‘Debug1’, it will be renamed ‘Debug2’ etc.
This is helpful for support to ensure that More4apps has all the information required to resolve your issue.
Help
Click this icon for help on any of the functionality of this Wizard. The three options are:
User Instructions – Link to the More4apps Webpage to find detailed explanation on the Wizard.
Release Notes – Link to the latest releases for the Wizard.
