Contact Us
Index
Version 24.1
Version 6.0 Version 5.14 Version 5.13 Version 5.12 Version 5.11 Version 6.1 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.2 Version 24.3 Version 24.4 Version 25.2
Contact Us
Wands for Oracle 24.1 – Home
Wands
Logging On
Antivirus Software
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
Drive Types
File Server
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
Table Security
About
Exit
Errors and Troubleshooting
Help and Shortcuts
Session Exit Confirmation
Excel Error
GL Wand
Ledger and Segment Selector
Quick Start
Report Wizard
Design Layout
Add Columns
Add Rows
Report Wizard Output
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 Description
Segment DFF
Segment End Date
Segment Group
Segment Level
Segment Start Date
Calculating
Execute Drilldown
Drill Criteria Sheets
Drill Criteria – Balance
Drill Criteria – Journal Extract
Drill Criteria – Average Balance
Drill Using a Saved Template
Drill to Journal or Subledger
Analyze Balances
View Transaction R12
Support All Ledgers
Customize Drilldown
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand Tools
Other Tools
Manage Criteria Templates
Hide Zeros
Import FSG
Configuration Sheet
Audit Get Balance
GL Wand User Options
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
GL Wand Drill Only
Journal Wand
Loading Journals
AutoPost Journal Wand Journals
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
Journal Wand Tools
Journal Wand Requests
Journal Wand Messages
Journal Wand User Options
Reports Wand
Responsibility Selector
Report
Open Existing Report
Create Report
Execute Report
Function
Run Report Order
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
Report Usage Statistics
Reports Wand User Options
Administration
Report Definition
Create
Bind Variables
Bind Variable Errors
Custom SQL List of Values
Filters
SQL Errors
Edit
Security
Multi Data Source (MDS)
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
insights
Generate Report Definitions
Create insights Tables
Search Report Definitions
Add Columns
Key Flexfield Label Integration
Advanced insights
Angles for Oracle
Import Angles for Oracle Report Definitions to Excel
Refresh Angles for Oracle 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
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
chat icon - ignore
Live Chat
Chat Offline

Journal Wand User Options

Configure your Journal Wand user preferences.

Option Description
Upload Zero-balance Lines Upload journal lines that have a zero balance i.e. the Entered Debit, Entered Credit, Accounted Debit and Accounted Credit fields have a value of zero. By default this is turned on. Disable this option to exclude zero-balance lines from the upload.
Force Balanced Budget Journals Validate that budget journals are balanced before uploading them to Oracle. By default this is disabled, meaning that unbalanced budget journals are permitted.
Submit Journal Import Automatically import journals during the upload process. By default this is turned on.
Submit Journal AutoPost Automatically post journals during the upload process. By default this is turned off. For more information regarding this option please see the AutoPost Journal Wand Journals section.
Submit Journal Approval Automatically submit journals for approval (via the Oracle E-Business Suite Journal Approval workflow process) where approval is enabled for the journal’s Ledger and required for its Journal Source. By default this is turned off.
Refresh concurrent requests every N seconds Set the amount of time between concurrent request status window refreshes.
Import Descriptive Flexfields This option controls the import of Descriptive Flexfields. Valid values are:

No Descriptive Flexfield values are not imported by the Journal Import program, even if populated in the Journal Wand template.
Yes – With Validation Descriptive Flexfield values are imported and validated by the Journal Import program.
Yes – Without Validation Descriptive Flexfield values are imported without validation by the Journal Import program.

The default value is Yes – With Validation.

Create Summary Journals Enable Journal Import to create summary journals i.e. Journal Import will create a single journal line within a journal for all source lines that share the same account. By default this is turned off. It is not possible to import Descriptive Flexfields when creating summary journals, therefore you cannot enable this option when the Import Descriptive Flexfields option is set to “Yes – With Validation” or “Yes – Without Validation”.
Upload Journal Attachments Enable journal attachment functionality i.e. the capture and upload of attachments via the Journal Attachments tool and the upload of attachments via the upload journals process (refer to Loading Journals). By default this is turned off.
Attach Template Workbook Upload the source Excel workbook, containing the Journal Wand template(s), and attach to the journals created by the upload process. By default this is turned off.
Allow Foreign Journal entered values to be zero Users can use zero values for Entered Dr and Cr fields, providing the Conversion Rate Type, Conversion Rate and Accounted Dr and Cr fields have been selected.
Cache Account Combinations limit Specify a limit only if extreme number of account code combinations exist causing Account Combination and Journal Processing dialogs to become non-responsive. A zero or null value implies this option is not enabled and default behavior will presume.

See Account Combinations for more detail.

 

Certain options are not applicable if Journal Import is not submitted from Journal Wand and they are disabled if the Submit Journal Import option is unchecked. The dependent options are Submit Journal AutoPost, Submit Journal Approval, Import Descriptive Flexfields, Create Summary Journals, Upload Journal Attachments and Attach Template Workbook.