Profile options are common to all of our tools. To find the profile options applicable for this Wizard, navigate to System Profile and enter More%AIW% as shown in the screenshot below, then select the ‘Find’ button.
The profile options applicable for this Wizard will show on the ‘System Profile Values’ form as shown below.
Many profile options can be set at the Site, Application, Responsibility or User level. Modify your search in the ‘Find System Profile Options’ form to set options at the appropriate level.
Profile Options are installed when you log into an instance (from the Wizard) for the first time. If a profile option is not available then you will need to reinstall your profile options. To do this, refer to the Reinstall Profile Options available in the Common User Topics documentation.
Common Profile Options
The following profile options are created for each of our products:
• More4Apps: AIW Allow MS-Word autocorrect characters - This profile can be set to prevent MS-Word AutoCorrect characters (which are non-ASCII) from being loaded – If these are loaded it can cause data corruption.
• More4Apps: AIW Allowed version - This profile option is similar to ‘More4Apps: AIW Minimum version’ but is more restrictive. It will stop any version other than the listed version from operating.
• More4Apps: AIW Automatically Assign User - If this is set to ‘Yes’ new users will be automatically assigned up to the maximum allowed by the licence key.
• More4Apps: AIW Banned - If this profile option is set to ‘Yes’ the Wizard will not operate. This can be set at the site, responsibility or user level.
• More4Apps: AIW Custom Query Manager – This profile allows customers to nominate a user to manage download queries. This is useful if the user lacks sysadmin access and cannot be granted sysadmin. The profile is set up at the user level.
• More4Apps: AIW Latest version used - This profile option is for internal use only. It records the highest version number used.
• More4Apps: AIW Licence Key - This profile holds the licence key for the Wizard. If you have no licence key then this field will hold ‘Trial Version’ as the licence key and some functionality will be limited. For more details on licence keys refer to the following Installation and Configuration Guide: Enter the Licence Key.
• More4Apps: AIW Limit to preset Application ID - This profile option is NOT applicable to Application Interface Wizard. Please ignore it.
• More4Apps: AIW Minimum version - This profile option allows you to record the minimum spreadsheet version number allowed. If the version number of the spreadsheet being used is less than the recorded value then the Wizard will not operate.
• More4Apps: AIW Named User - This profile enables you to control the named users for Application Interface Wizard and is set at the user level in Oracle. For more details on how to set up named users refer to the following Installation and Configuration Guide: Add Named Users.
• More4Apps: AIW Nominated Sysadmin for user maintenance - This profile can be set to allow a nominated Oracle user name which doesn't have System Administrator profile value access to maintain users for this product. Other users that do have System Administrator profile access can still maintain product users if this profile is set to a different person.
Note - This profile option is only available for clients with Wizard versions containing ‘Common Modules’ version 204 and greater.
• More4Apps: AIW Suppress Custom Query Functionality - This functionality can be suppressed by setting the profile option to ‘Yes’ at the user, responsibility or site level. When this profile option is set (at the appropriate level) selection of any custom query icon will produce a message of ‘The custom query functionality has been disabled by your System Administrator. Please contact your System Administrator’.
• More4Apps: AIW Template Manager – This profile allows customers to nominate a user to manage templates. This is useful if the user lacks sysadmin access and cannot be granted sysadmin. The profile is set up at the user level. To enable sysadmin access for templating select ‘Yes’ for the current user.
• More4Apps: AIW Unicode Encoding Option - This profile determines if character sets used by different applications are converted. By default this is set to ‘Automatic’ and should not be changed unless advised by More4Apps Support.
• More4Apps: AIW Validate Only - This profile option is NOT applicable to Application Interface Wizard. Setting it will have no effect.
Application Interface Wizard - Specific Profile Options
There are no Application Interface Wizard specific profile options; however there may be encoded licence key profiles for specific loaders which look similar to the example profile option below:
• More4Apps: AIW Disable PLSQL Development - This profile option disabled the use of PLSQL validation in the edit by sheet and manage templates forms. If set to ‘Yes’ this will disable the functionality. If set to ‘No’ or blank this will enable the functionality.
• More4Apps: AIW|XXXXX Licence Key - This is the specific licence key for a More4Apps supplied template loader.
• More4Apps: AIW|XXXXX Named User - This profile enables you to control the named users for Application Interface Wizard and is set at the user level in Oracle. For more details on how to set up named users refer to the following Installation and Configuration Guide: Add Named Users. The XXXXX in this profile refers to the MD5 template number generated when creating a loader.
• More4Apps: AIW Disable Table Modes - This profile option is used to disable the ability to create a loader that is a direct table insert/update or delete, therefore limiting the loader creation options to an EBS Attachment or Procedure. When set to ‘Yes’ this will remove the ‘Insert’ and ‘Delete’ from the table modes list of values. If set to ‘No’ or blank this will not limit the list of values for table modes.
• More4Apps: AIW User Password Update Allowed - A password can be assigned to any new user. The update to any password is regulated by the profile “More4Apps: AIW User Password Update Allowed”. This must be set to ‘Yes’ before you can update a user’s password. This is a free text field.
