Profile options are common to all of our tools. To find the profile options applicable for this Wizard, in EBS navigate to System Profile and enter More%RTW% as shown in the screenshot below. 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: RTW 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: RTW Allowed version - This profile option is similar to “More4Apps: RTW Minimum version” but is more restrictive. It will stop any version other than the listed version from operating.
• More4Apps: RTW Automatically Assign User - If this is set to ‘Yes’ new Users will be automatically assigned up to the maximum allowed by the license key.
• More4Apps: RTW 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: RTW 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: RTW Latest Version Used - This profile option is for internal use only. It records the highest version number used.
• More4Apps: RTW 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: RTW 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: RTW 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.
Note – This profile option is only available for clients with Wizard versions containing ‘Common Modules’ version 204 and greater.
• More4Apps: RTW 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: RTW 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: RTW 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: RTW Validate Only - This profile can be set to ‘Yes’ to allow the customer to set up Validate Only for the user.
Product Specific Profile Options
The following profile options are specific to Routing Wizard:
• More4Apps: RTW Allow past dates in component effectivity columns - Standard Oracle doesn’t allow you to enter effectivity dates in the past. By default the Wizard doesn’t either. However if you set this profile option to Yes then you can load line items with effective dates in the past. (Not available in r11).
• More4Apps: RTW Insert Operation Into Next Available Sequence - When adding a new Operation Sequence the Wizard can automatically select a new sequence number or use up any blank sequences to create a new number.
e.g. Routing with 5 Operations: 10, 20, 40, 70, 80
If you want to add two more operations to it you can set the Profile Option to ‘No’ and the next values are 90 and 100. If you set the Profile option to ‘Yes’ the next values will be 30 and 60 – thus using up any blank sequences.
NOTE: This Profile option is longer valid as ‘New Operation Sequence’ is required (a value must be on the sheet) when adding a new Operation, and ‘Operation Sequence’ is required when updating an existing Operation. To update the Operation Sequence Number of an existing Operation the ‘New Operation Sequence’ is required alongside the existing ‘Operation Sequence’.
