Contact Us
Index
Version 5.13
Version 6.0 Version 5.14 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.1 Version 24.2 Version 24.3 Version 24.4 Version 25.2
Contact Us
New Release Notification
User Profile
Responsibility Selection
Excel Not Ready Error
Add-In Load Error
Multiple Instances
License Key Errors
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Snapshot
Upgrade Workbook
Shared Templates Drive
Drive Types
Dropbox
File Server
Oracle E-Business Suite Database
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
Custom Drill Columns
Journal 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
Discover Period Names
Discover Segment Properties
Discover Child Ranges
Discover Segment Values
Expand and Explode
Expand Segment Values
Expand Segment Value Hierarchy
Expand Account Combination
Explode Segment Values
Explode Segment Value Hierarchy
Explode Account Combination
Discover Level
List of Values – Create
Account Combination Enabled
Account Combination End Date
Account Combination Start Date
Account Type
Daily Rate
Enabled Flag
Functional Currency
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 Status
Period End Rate
Previous Segment Value
Period Name
Segment Description
Period Offset
Segment DFF
Period Start Date
Segment End Date
Segment Group
Segment Level
Segment Start Date
Drill Criteria Sheets
Drill Criteria – Balance
Drill Criteria – Journal Extract
Drill Using a Saved Template
Drill to Journal or Subledger
Analyze Balances
View Transaction R12
Support All Ledgers
Edit Template Layout
Save Template Layout
Manage Templates
Other Tools
Report Wizard
Hide Zeros
Import FSG
Configuration Sheet
Audit Get Balance
GL Wand User Options
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Load and Validation
Execution
Create Schedule
Running the Scheduler
SMTP Email Settings
Convert Get Balance
Load Budget
AutoPost Budget Wand Journals
Creating New Account Combinations
Budget Wand Requests
Budget Wand Messages
Budget Report Wizard
Budget Wand User Options
Open Existing Report
Create Report
Execute Report
Insert a Run Report Function
Run Report Filter
Modify a Run Report Function
Drill On Function
Drill to Saved Template
Refresh Mode
Refresh Reports Wand Functions
Parameter List
Report Editor
Template Manager
Clean Template
Show List of Values
Create List of Values
Reports Wand User Options
Report Definition
Create
Bind Variables
Bind Variable Errors
Custom SQL List of Values
Filters
SQL Errors
Edit
Security
Mass Administration
Import
Import Single to Excel
Import All 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
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
AutoPost Journal Wand Journals
Journal Wand Requests
Journal Wand Messages
Journal Wand User Options

Ledger and Segment Selector

Play Video

Once you have logged on the Book and Segment dropdowns will be populated based on the selected responsibilities.

Ledger

The Ledger dropdown list can be used to select the Ledger that you wish to work with. If you are licensed to use the Multiple Ledgers feature, or are in trial, then this list will contain multiple values in the following situations:

  • If you selected multiple responsibilities during the logon process all the Ledgers linked to those responsibilities will be listed.
  • If you selected the special “All Ledgers” option, all the Ledgers configured in the Oracle instance will be listed.
  • If you log on to an Oracle Release 12 instance and the data access set linked to the chosen responsibility contains more than one ledger or ledger set, then each of these ledgers will be listed.

The number in brackets () indicates the Ledger identifier. This number can be used in various GL Wand formulas and other functionality in order to obtain information from a specific Ledger.

The item also shows the responsibility that is linked to the chosen Ledger. This can be useful if ever there is doubt about which responsibility resulted in a particular Ledger being included in your GL Wand session.

Segment

This dropdown list will be populated with a list of the segments that are available in the currently selected Ledger. The number in brackets indicates the segment number. The segment list also includes the special value Period which is used for discovering period names. In the example shown the selected segment is Company and it is identified as segment 1. Certain GL Wand functions require the segment number as an input parameter.