Contact Us
Index
Version 6.1
Version 6.0 Version 5.14 Version 5.13 Version 5.12 Version 5.11 Version 6.2 Version 6.3 Version 6.4 Version 20.1 Version 20.2 Version 20.3 Version 21.2 Version 22.1 Version 22.3 Version 22.4 Version 23.1 Version 23.2 Version 23.3 Version 23.4 Version 24.1 Version 24.2 Version 24.3 Version 24.4 Version 25.2 Version 25.3 Version 25.4 Version 26.1 Version 26.2 Version 26.3
Contact Us
Wands for Oracle 6.1 – Home
Wands
Logging On
Applet Launch
Java Web Start Launch
New Release Notification
User Profile
Responsibility Selection
Excel Not Ready Error
Add-In Load Error
Multiple Instances
License Key
License Key Errors
Insert Wands Function
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Tools (Wands)
Snapshot
Upgrade Workbook
Shared Templates Drive
File Server
Drive Types
Dropbox
Oracle E-Business Suite Database
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
Administrator
Custom Drill Columns
Journal Custom Columns
Journal Attachment Custom Columns
Subledger Custom Columns
Subledger SLA Custom Columns
Add a Custom Drilldown Column
System Administrator Options
System Administrator License Key
System Administrator User Permissions
System Administrator User Options
System Administrator Product Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
Wands Responsibility Profile Option
Payroll Drilldown Responsibility
Custom Options
Active Data Guard Support
About
Exit
Errors and Troubleshooting
Help and Shortcuts
Excel Error
GL Wand
Ledger and Segment Selector
Discover
Discover Segment Values
Discover Level
Discover Period Names
Discover Segment Properties
Discover Child Ranges
Expand and Explode
Expand Segment Values
Expand Segment Value Hierarchy
Expand Account Combination
Explode Segment Values
Explode Account Combination
Explode Segment Value Hierarchy
List of Values
List of Values – Create
Insert GL Wand Function
Account Combination Enabled
Account Combination End Date
Account Combination Start Date
Account Type
Daily Rate
Enabled Flag
Functional Currency
Get Average Balance
Get Average Balance Summary
Get Balance
Descriptive Flexfield Criteria
Segment Combination Criteria
Get Balance Options
Get Balance Summary
Multiple Ledgers
Historical Rate
Ledger Name
Ledger Set
Next Segment Value
Parent Flag
Period Average Rate
Period End Date
Period End Rate
Period Name
Period Name By Date
Period Offset
Period Start Date
Period Status
Previous Segment Value
Segment End Date
Segment Description
Segment Group
Segment Level
Segment DFF
Segment Start Date
Customize Drilldown
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand Tools
Other Tools
Report Wizard
Hide Zeros
Import FSG
Configuration Sheet
Audit Get Balance
GL Wand User Options
Calculating
Execute Drilldown
Drill Using a Saved Template
Drill to Journal or Subledger
Analyze Balances
View Transaction R12
Support All Ledgers
Drill Criteria Sheets
Drill Criteria – Balance
Drill Criteria – Journal Extract
Drill Criteria – Average Balance
Report Distribution Manager
Create RDM Template
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Edit RDM Template
Execute Report Distribution Manager
Load and Validation
Execution
Scheduler
Create Schedule
Running the Scheduler
RDM User Options
SMTP Email Settings
GL Wand Drill Only
Reports Wand
Responsibility Selector
Report
Open Existing Report
Create Report
Execute Report
Function
Insert a Run Report Function
Run Report Filter
Modify a Run Report Function
Drill On Function
Drill to Saved Template
Refresh
Refresh Mode
Refresh Reports Wand Functions
Show
Parameter List
Report Editor
Template Manager
Reports Wand Tools
Clean Template
Show List of Values
Create List of Values
Audit Run Report
Reports Wand User Options
Administration
Report Definition
Create
Bind Variables
Bind Variable Errors
Custom SQL List of Values
Filters
SQL Errors
Edit
Security
insights
Generate Report Definitions
Create insights Tables
Add Columns
Search Report Definitions
Mass Administration
Import
Import All to Excel
Import Selected to Excel
Process
Process All
Process Single
Upgrade
Upgrade Version 4 Report Definitions
Fixing Duplicate Bind Variables
Upgrade Version 4 Templates
Upgrade Reports Wand Administrator Templates
NoetixViews
Import NoetixViews Report Definitions to Excel
Refresh NoetixViews Security Manager
Essays
Search Answers
Create Join Definition
Discoverer Converter
Convert using Discoverer Plus (.xml) Export
Export Workbook .xml From Discover Plus
Using the Discoverer Converter
Assign Reports
Refresh List
PL/SQL Stored Procedures
Reports Wand Database Package
Create a Stored Procedure
Assign a Stored Procedure
Exception Handling
Budget Wand
Ledger Selector
Insert Budget Wand Function
Convert Get Balance
Load Budget
Load Option Selector
Loading Budgets
AutoPost Budget Wand Journals
Creating New Account Combinations
Budget Wand Tools
Budget Wand Requests
Budget Wand Messages
Budget Report Wizard
Budget Wand User Options
Journal Wand
Journal Wand Ledger Selector
Create Journal Wand Template
Edit Journal Wand Template
Create Journal Wand Template from Drilldown
Populate Journal Wand Template
Account Combinations
Descriptive Flexfields
Journal Attachments
Load Options
Loading Journals
AutoPost Journal Wand Journals
Journal Wand Tools
Journal Wand Requests
Journal Wand Messages
Journal Wand User Options
chat icon - ignore
Live Chat
Chat Offline

Java Web Start Launch

When launching Wands applications using JWS the Wands Java applet will now appear as a separate window instead of being displayed directly within the web browser.

The navigation for all browsers share the following common steps:

  1. Open your preferred browser.
  2. Login to Oracle E-Business Suite.
  3. Choose the Wands responsibility to initiate the download of the wands_wands_oracle.jnlp file.

Microsoft Internet Explorer 11

  1. A download dialog window appears at the bottom of the browser window.
  2. When prompted select Open and the JNLP file is downloaded to the web browser’s cache directory.
  3. The JWS Launcher progress dialog appears as the product loads and the JNLP file will be automatically removed.

Mozilla Firefox Rapid Release and Extended Support Release (ESR)

Firefox ESR 52 is the final release that supports both the Java Plug-in in addition to JWS. All later versions will only support JWS.

By default, Firefox requires the user to choose the appropriate action on what to do with the JNLP file that is downloaded when launching, for example:

  1. Firefox displays the following message: “What should Firefox do with this file?”, as shown in the following image:
  2. Choose the first option “Open with” and in the corresponding drop-down list, select “Java(TM) Web Start Launcher (default).”
  3. Select the checkbox “Do this automatically for files like this from now on” in order to associate the JNLP file extension with the Java Web Start Launcher executable on the client PC.
  4. Click OK.

Each new JNLP file is saved into the default download location, as defined in Firefox. The JWS Launcher will then automatically remove this file from that location.

The JNLP file association can also be manually configured by completing the following steps in Firefox:

  1. Click Menu.
  2. Click the Options icon.
  3. Select the Applications tab.
  4. Search for Content type “JNLP File.”
  5. In the “Action” drop-down list, select “Use Java(TM) Web Start Launcher (default).”

Google Chrome

Google Chrome has not supported the Java Plug-in since release 45 so Chrome can only run with JWS. The following describes a common use case when launching the Wands application.

  1. Google Chrome displays the following message: “This type of file can harm your computer. Do you want to keep wands_wands.jnlp anyway?”
  2. Click Keep to save the JNLP file.
  3. Click the JNLP file in the download bar.
  4. Wands is now started with JWS.

Note that the warning message in step 1 is expected due to restrictions enforced by Google Chrome.

The JWS launcher automatically removes the downloaded JNLP file from the browser’s download folder.

Microsoft Edge

Wands can only run with JWS when using the Microsoft Edge web browser.

The download dialog displays at the bottom of the screen and the downloaded JNLP file is saved in the Downloads folder as shown in the following image:

  1. Click Open to execute the JNLP file.
  2. The Wands application is started with JWS.
  3. Optionally under “Advanced Settings” set “Ask me what to do with each download” Off.

The JWS launcher automatically removes the downloaded JNLP file from the browser’s download folder.

Known issues

Internet Explorer with 64-bit JRE

When Wands applications are launched in IE and the Open button is clicked, nothing happens and the product does not launch. This is a known issue (JDK-8185661) when having installed JRE 8 32-bit and 64-bit at the same time. We recommend using only 32-bit in this instance. Alternatively as a workaround you can select the Save option when prompted, then Open Folder and manually launch the downloaded JNLP file.

Build-up of JNLP files in the Browser’s Download Folder

Launching the Wands applet requires the download of a JNLP file. Mozilla Firefox, Google Chrome and Microsoft Edge save these JNLP files in their respective download location. These are automatically removed by JWS when launched from the web browser.

A build-up of JNLP files on the local file system may occur if the end user does not launch the downloaded JNLP files. It is safe to manually remove old JNLP files from the browser’s download directory.

Certificate confirmation message

During the launch you will see a confirmation message to accept the Wands security certificate. You may also tick the option to not show the message again.

However, despite selecting the option to not show the message again, this message continues to display on each launch. This is the expected behavior as, from Java’s perspective, a new application is being launched each time and therefore it will continue to display the confirmation.

You have the following options:

  1. Simply continue to accept the message on each launch as it is a simple step.
  2. If you would like to suppress the message you can attempt the following procedure which is known to work in certain configurations:
    1. Open a windows command prompt
    2. In the command prompt window enter the following command, editing as required to match your launch URL:
      javaws “https://server.domain.com:8000/OA_HTML/wands?launchMethod=jws”
    3. The application will attempt to launch, accept the certificate message and tick the option not to show it again.
    4. The application will continue launching but will fail with a logon error. This is expected.
    5. Close down the command prompt, Excel and all browser windows and start a clean launch.
    6. The certificate message should no longer display.