Profile Options

 
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% IW% (note the space before IW) as shown in the screenshot below and select the ‘Find’ button.
 
 
The profile option 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 re install your profile options. 
To do this refer to the Reinstall Profile Options available in the Common User Topics documentation.
 
The following profile options are created for each of our products:
 
•      More4Apps: IW 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: IW Allowed version – This profile option is similar to “More4Apps: IW Minimum version” but is more restrictive.  It will stop any version other than the listed version from operating.
 
•      More4Apps: IW 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: IW 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: IW 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: IW Downloader Manager – This has been replaced by profile option ‘More4Apps: IW Custom Query Manager’.
 
•      More4Apps: IW Latest version used – This profile option is for internal use only.  It records the highest version number used.
 
•      More4Apps: IW Licence Key - This profile holds the licence key for the Wizard.  For more details on licence keys refer to the following Installation and Configuration Guide: Enter the Licence Key.
 
•      More4Apps: IW Limit to preset Application ID – Set this profile to ‘Yes’ to limit the selection of user responsibilities to those assigned to the same application as the Wizard or set to ‘No’ or leave blank to display all responsibilities assigned to the user.
 
•      More4Apps: IW 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: IW Named User - This profile enables you to control the named users for Item 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: IW 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: IW Override Upload Security - Under normal circumstances the Wizard will check if the current responsibility has the right to do an upload based on the responsibility. If this profile is set to 'Yes' at the responsibility level, this security check is not done.
Note – If a user is a ‘Named User’ and does not have access to the Price List form in Oracle, this profile will enable this user to update and create price lists in Oracle if the security setting for the price list is ‘Global’ and the access level is ‘Maintain’.  To set security setting of Price List, navigation in Oracle is Oracle Pricing Administrator > Oracle Pricing Administrator Setup > Security > Privileges.
 
•      More4Apps: IW 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: IW Suppress Downloader Functionality – This has been replaced by profile option ‘More4Apps: IW Suppress Custom Query Functionality’.
 
•      More4Apps: IW 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: IW 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.
 
Product Specific Profile Options
 
The following Profile Options are specific to Item Wizard:
 
•      More4Apps: IW Enable Item Number Generation - Set this profile to ‘Yes’ to enable the Item Number generation.
 
•      More4Apps: IW Restrict Cross Reference mode - This profile option suppresses the named mode stated in the profile name.  When set to ‘Yes’, the user will not have access to us the particular mode.  When set to ‘No’ or left blank the user will have access to the named mode.  Please note this profile does not override functional accessibility.  By default, this profile is set to be blank.
 
•      More4Apps: IW Restrict Description Translations mode - This profile option suppresses the named mode stated in the profile name. When set to 'Yes' the user will not have access to use the particular mode. When set to 'No' or left blank the user will have access to the named mode. Please note this profile does not override function accessibility. By default, this profile is set to be blank.
 
•      More4Apps: IW Restrict Items mode - This profile option suppresses the named mode stated in the profile name. When set to 'Yes' the user will not have access to use the particular mode. When set to 'No' or left blank the user will have access to the named mode. Please note this profile does not override function accessibility. By default, this profile is set to be blank.
 
•      More4Apps: IW Restrict Maintain Categories mode - This profile option suppresses the named mode stated in the profile name. When set to 'Yes' the user will not have access to use the particular mode. When set to 'No' or left blank the user will have access to the named mode. Please note this profile does not override function accessibility. By default, this profile is set to be blank.
 
•      More4Apps: IW Restrict Organization Assignment mode - This profile option suppresses the named mode stated in the profile name. When set to 'Yes' the user will not have access to use the particular mode. When set to 'No' or left blank the user will have access to the named mode. Please note this profile does not override function accessibility. By default, this profile is set to be blank.
 
•      More4Apps: IW Restrict UDA Items mode - This profile option suppresses the named mode stated in the profile name. When set to 'Yes' the user will not have access to use the particular mode. When set to 'No' or left blank the user will have access to the named mode. Please note this profile does not override function accessibility. By default, this profile is set to be blank.
 
•      More4Apps: IW Restrict to modes only - Determines whether users MUST use modes or not.  If set to Yes, users can only use the Wizard by selecting a mode i.e., they cannot generate a pre-defined template sheet.  If set to No or left blank, then templating or mode options can be used.
 
•      More4Apps: IW Restrict to templates only - Determines whether users MUST use templates or not.  If set to Yes, users can only use the Wizard by selecting a template i.e., they cannot generate a pre-defined template sheet.  If set to No or left blank, then templating or mode options can be used.
 
•      More4Apps: IW Update Mode Only – If this profile is set to Yes then the Wizard will only let you use the Upload option of ‘Update’.
 
•      More4Apps: IW Use Primary UOM Description – If this profile is set, then when searching for an UOM you can search using the UOM Description, rather than just the UOM Code.
 
•      More4Apps: IW Validate Only - This profile can be set to ‘Yes’ to allow the customer to setup validate only for the user. 
 
•      More4Apps: IW Enable Extension Pkg – If the extension package is being used for the Wizard this profile will enable the architecture to ensure the extension package is used during upload. To enable this set the value to ‘Yes’.  By default, this profile is blank or ‘No’.
 
 
 
The following profiles are specific to the Item Extension Wizard and have no effect on the Item Wizard.  Please refer to the Item Extension Wizard for details:
 
•       More4Apps: IEW – Activate ABC Assignment Mode
 
•       More4Apps: IEW – Activate Container Item Mode
 
•       More4Apps: IEW – Activate Intraclass UOM Conversion Code
 
•       More4Apps: IEW – Activate Manufacture Part Mode
 
•       More4Apps: IEW – Activate Pending Item Status Mode
 
•       More4Apps: IEW – Activate Related Item Mode
 
•       More4Apps: IEW – Activate Sourcing Assignment Mode
 
•       More4Apps: IEW – Activate Subinventory Mode
 
•       More4Apps: IEW – Activate Transaction Default Mode (Note - Only applicable to Oracle instances below 12.2 in Item Extension Wizard)