System Administrator Configuration Options

Set the configuration options.

Option	Description
Show Error on Account Access Violation	Show an error if the user requests accounts they do not have access to.
Show Wands Users Only	Tick this option to only load those users that have the Wands responsibility assigned to their Oracle user account. This option can help significantly if your Oracle user table has many thousands of records in it. If your Oracle user table has more than 50 000 records in it this option will be pre-selected and you will not be able to unselect it. This is due to the fact that the process of loading so many users into this maintenance dialog can be very time consuming.
Database Fetch Batch Size	Batch size determines how many rows are interfaced from the server to the client at a time and also the size of batches written to Excel.
Maximum File Size	Enter the maximum file size that can be uploaded by Wands products. This also restricts the maximum file size that can be stored in the Shared Templates Drive.
Show Wands enabled Responsibilities Only	Only show responsibilities that are flagged as Wands responsibilities. See Wands Responsibility Profile Option for instructions to create the required configuration. Do not tick this option unless the required configuration has been created and you have flagged the applicable responsibilities by setting the new profile option to Yes. If this is not done, users will have no responsibilities to select when they log on with the Wands.
Track User Activity	Logs an entry in the icx_session_attributes table when a user connects with an Wands application. Can be used to determine which users are actively utilizing the Wands applications. In order to query this data use the following SQL statement: `SELECT attr.*, s.first_connect, s.last_connect, s.disabled_flag, u.user_name, icx_sec.check_session (s.session_id) status FROM icx_sessions s, icx_session_attributes attr, fnd_user u WHERE s.session_id = attr.session_id AND attr.NAME = 'EXCEL4APPS' AND s.user_id = u.user_id ORDER BY s.last_connect DESC`
Read Timeout	Time that the client waits for an answer from the server, as well as the time that any SQL has to complete on the database. The database session for any SQL that runs for longer than the read timeout setting will be killed, thus preventing long running SQL that cannot be cancelled.
Reports Wand Row Limit	Limits the number of rows returned by a Reports Wand query. Leaving this empty will return all rows.
Reports Wand NoetixViews Schema	Set the NoetixViews Schema. Only enabled under certain conditions, see NoetixViews.
Reports Wand Enable Reports Wand insights	Enable the Reports Wand insights features. Please see the insights section of the user guide for more information.
Journal Wand Secure Journal Source	Indicates whether Journal Source is secured in Journal Wand and thereby restricted to the value specified in the Journal Source field.
Journal Wand Journal Source	The only valid Journal Source that may be used for uploading journals via Journal Wand.
System Administrator Contact Name	The name of the person in your organization that your users should first contact with Wands software queries.
Suppress Support Expiry Messages Until	Suppress support expiry warnings until the date entered. The date must be between today’s date and 1 year in the future. Expiry of trial products and notifications of new versions will also be suppressed until this date. These notifications and warnings are suppressed for users only. Wands administrators will continue to see this messages.
Balance Hint	SQL hint added to the Get Balance formula that summarizes balances.
Journal Hint	SQL hint added to the Get Balance formula that summarizes journals.
Drive Type	Select the Shared Templates Drive type. The options are Oracle E-Business Suite Database, Dropbox or a central File Server. It is extremely important to understand the requirements and setup for the selected Drive type, please familiarize yourself with the help for the relevant type before selecting or changing this option.
Restrict access based on product license	Restrict access to shared templates based on the users assigned product license. i.e. GL Wand users will only be able to access GL Wand shared templates, Reports Wand users will only be able to access Reports Wand shared templates. This setting does not apply to Wands administrators.
File Server Path	If the Shared Templates Drive type is set to File Server, enter the folder location here.
Active Data Guard Support Enabled	Enable the optional Oracle Active Data Guard feature. See Active Data Guard Support for more detail.