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%PLW% 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.
Common Profile Options
The following profile options are created for each of our products:
• More4Apps: PLW 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: PLW Allowed Version - This profile option is similar to ‘More4Apps: PLW Minimum version’ but is more restructure. It will stop any version other than the listed version from operating.
• More4Apps: PLW Automatically Assign User - If this is set to ‘Yes’ Oracle will assign new users automatically up the maximum allowed by the licence key.
• More4Apps: PLW 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: PLW 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: PLW Latest Version Used - This profile option is for internal use only. It records the highest version number used.
• More4Apps: PLW Licence Key - This profile holds the licence key for the Wizard. If you have no licence key then this field will hold ‘Trial’ 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: PLW 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: PLW Load Counter - This profile may exist in your Profile Option list but is no longer used.
This profile was used when the Wizard was in trial mode and counted the number of transactions completed before the Wizard logged out of the Oracle instance.
• More4Apps: PLW Minimum version - This option allows you to enter the spreadsheet version number into this profile option. If the spreadsheet version does not match this then the Wizard will not operate.
• More4Apps: PLW Named User - This profile enables you to control the named users for Price List 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: PLW Nominated Sysadmin for user maintenance - This profile can be set to allow a nominated Oracle username 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.
Enter the person’s user name into this field. Note only one user can be assigned this profile option at the site level.
Note – This profile option is only available for clients with Wizard versions containing ‘Common Modules’ version 204 and greater.
• More4Apps: PLW 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: PLW 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: PLW 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: PLW 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: PLW 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: PLW 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: PLW Validate Only - Set this profile option to ‘Yes’ at the user level to prevent the user from uploading data. The user will only be able to validate the data, which uses the Wizard validation.
Product Specific Profile Options
The following profile options are specific to Price List Wizard:
• More4Apps: PLW Restrict Upload on Errored Lines – This profile can bet set to prevent the Wizard from uploading data if any line level data errors. When set to ‘Yes’ this will not allow the Wizard to load data to the API until all lines pass Wizard validation. When set to ‘No’ the Wizard will upload all lines to the API that pass validation, regardless if some lines error in the Wizard during validation.
Redundant Profile Options
These profile options may have been created by a prior version of Price List Wizard but are no longer being referred to by the current website version:
• More4Apps: PLW User Confirmation required before load
• More4Apps: PLW Concurrent
