Wands (Oracle) 5.10 : System Administrator Configuration Options

Created by Shaun Pendrigh, last modified on Aug 18, 2015

Set the configuration options.

 

OptionDescription
Show Error on Account Access ViolationShow an error if the user requests accounts they do not have access to.
Show Excel4apps enabled Responsibilities Only

Only show responsibilities that are flagged as Excel4apps responsibilities. See Excel4apps Responsibility Profile Option for instructions to create the required configuration.

Icon

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 Excel4apps Wands.

Show Excel4apps Users Only

Tick this option to only load those users that have the Excel4apps responsibility assigned to their Oracle user account. This option can help significantly if your Oracle user table has many thousands of records in it.

Icon

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.

Track User Activity

Logs an entry in the icx_session_attributes table when a user connects with an Excel4apps application. Can be used to determine which users are actively utilizing the Excel4apps 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
Database Fetch Batch SizeBatch 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.
Reports Wand Row LimitLimits the number of rows returned by a Reports Wand query. Leaving this empty will return all rows.
Reports Wand NoetixViews SchemaSet the NoetixViews Schema. Only enabled under certain conditions, see NoetixViews.
System Administrator Contact NameThe name of the person in your organization that your users should first contact with Excel4apps software queries.
Balance HintSQL hint added to the Get Balance formula that summarizes balances.
Journal HintSQL hint added to the Get Balance formula that summarizes journals.
Read TimeoutTime that the client waits for an answer from the server.
Suppress Support Expiry Messages UntilSuppress support expiry warnings until the date entered. The date must be between todays date and 1 year in the future.
Drive Type

Select the Shared Templates Drive type. The options are Oracle E-Business Suite Database, Dropbox or a central File Server.

Icon

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.

Maximum File SizeEnter the maximum file size that can be stored in the Shared Templates Drive.
File Server PathIf the Shared Templates Drive type is set to File Server, enter the folder location here.

 

 

Attachments:

configuration_options.png (image/png)
configuration_options.png (image/png)
configuration_options.png (image/png)
configuration_options.png (image/png)