Wands (Oracle) 5.8 : System Administrator Configuration Options

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.

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

 

 

Attachments: