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%RIW% 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: RIW Named User - This profile enables you to control the named users for AR (API) Invoice 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: RIW Minimum version – This profile option allows you to record the minimum Wizard version number allowed. If the version number of the Wizard being used is less than the recorded value then the Wizard will not operate.
• More4Apps: RIW 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: RIW 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: RIW Allowed version – This profile option is similar to ‘More4Apps: RIW Minimum version’ but is more restrictive. It will stop any version other than the listed version from operating.
• More4Apps: RIW Latest Version Used - This profile option is for internal use only. It records the highest version number used.
• More4Apps: RIW 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: RIW 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: RIW 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: RIW 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: RIW 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: RIW 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: RIW 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.
Product Specific Profile Options
The following profile options are specific to AR Invoice API Wizard:
• More4Apps: RIW Download Orig System Ref – This profile can be set to determine if the ‘Original System Ref’ is included in download results. Only set this profile to ‘Yes’ if this field needs to be downloaded otherwise there could be performance degradation.
• More4Apps: RIW Allow Skip Workflow Update – This is only applicable when creating an applied credit memo. This profile can be set to determine if Workflow can be skipped and provides control over whether users can elect to bypass the Approval Workflow.
• More4Apps: RIW Limit Tax Classifications LOV by OU – This profile is used to restrict the tax codes by operating unit.
• More4Apps: RIW r12 Tax Validation only uses Tax Rate Name Column – If set to ‘Yes’ then the Wizard validation and upload routine would ignore and disable all the R12 Tax columns except ‘Tax Rate Code’. Therefore you could delete them from the Wizard. Note – This functionality requires that the ‘Tax Rate Name’ chosen is unique otherwise the interface will reject it.
• More4Apps: RIW Allow Direct Table Updates for Distribution DFFs – If you are using Receivables AutoAccounting to create your GL Accounts instead of entering this information in the Wizard worksheet, set this profile to ‘Yes’ to allow distribution level DFFs to be updated after the API automatically creates the transaction distribution information. This allows Distribution DFF data to exist on the worksheet without corresponding GL Account information.
• More4Apps: RIW Allow Direct Update of Attributes Using Special Value Sets – The AR Invoice API does not support Special Validation for DFF Attributes (i.e. DKFFs), this profile will allow you to upload Special Value set values via direct table updates.
• More4Apps: RIW Allow Price List Defaulting – This profile enables the use of the API QP_PREQ_PUB.PRICE_REQUEST to default the Unit Selling price from the Price list against the Item.
• More4Apps: RIW Default Ship Location – Set this profile to ‘Yes’ to enable functionality. During validation ‘Ship Location’ will be defaulted from the column ‘Ship to Cust Number’.
• More4Apps: RIW Default Tax Rate and Amount - Set this to Yes to enable functionality. During validation on a tax line, Tax Rate will be derived from the "Tax Rate Name" column. This will then be calculated against the Total Amt of the Line designated by the "Link To Line” column. This will only occur when the Tax Rate and Total Amt are blank (i.e. If the Line amount or Tax Rate Name were to change after defaulting, the original values would remain). You can use the "Calc" button in the form (next to Total Amt) to overwrite these defaulted values if you wish.
• More4Apps: RIW Override Upload Security - This profile is set at the responsibility and has an LOV with the values ‘Yes, No’. Selecting a value of ‘Yes’ will mean the Wizard skips the responsibility form function check.
• More4Apps: RIW Use Alternative Credit Refresh – There is an Oracle bug that returns a false error when skip_workflow is set to Yes. This profile causes the Wizard to do a different status check which avoids this issue.
• More4Apps: RIW Validate Only - This profile can be set to ‘Yes’ to allow the customer to setup validate only for the user.
Obsolete
• More4Apps: RIW Use Customer Name as Primary Column – This profile makes Customer Name drive the Customer Number e.g. when you change the Customer Name, the Customer Number will change to match the Name, instead of the other way around.
