Contact Us
Index
Version 23.4
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 24.1 Version 24.2 Version 24.3 Version 24.4 Version 25.2
Contact Us
Wands for Oracle 23.4 – 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
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
GL Wand Drill Only
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
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
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
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

Budget Wand Messages

The Load Budget function can return a number of different results. They could be a validation that fails or a processing error that occurs. There are two main types of validation. Client Validation and Server Validation.

Client Validation Messages

Client Validation takes place automatically or as soon as a parameter in the Load Budget function has changed.

Return Status Description Formatting
Error (Budget Year Not Open) The specified Budget Year is not currently open or does not exist. None
Error (Budget Frozen) The specified Budget has been frozen. None
Error (Budget Inactive) The Budget is not active for the specified period. None
Error (Inactive Organization) The specified Budget Organization is inactive i.e. the current date falls outside of the specified start and end dates. None
Error (Input Value) The specified Input Value either does not exist or you have specified a non-numeric value. None
Error (Journal Source) The required journal source “Budget Journal” does not exist or has been modified. None
Error (Journal Category) The specified Journal Category is incorrect or does not exist. None
Error (Journal Line Length) The journal line description is longer than 240 characters. None
Error (Journal Name Length) The journal name is longer than 100 characters. None
Error (Organization Name) The specified Budget Organization does not exist or is incorrect. None
Error (Ledger) The Ledger is invalid. None
Error (Period) The period is invalid. None
Error (Currency) The currency is invalid. None
Error (Budget / Encumbrance) The budget or encumbrance name is invalid. None
Error (SegmentN) The specified Segment is invalid. None
Error (SegmentN Read Only) The balancing segment value specified is Read Only. See Data Access Set configuration in Oracle for the specific ledger being used. None
Error (Ledger Read Only) The ledger is Read Only. See Data Access Set configuration in Oracle for the specific ledger being used. None
Error (Server Validation) A server validation error has occurred. See table below for Server Validation error messages. Red with cell comment.

Server Validation Messages

All server validation messages have a cell return status of “Error (Server Validation)”. The full error message will be in the cell comment.

Return Status Error Message (in cell Comment) Description Formatting
Error (Server Validation) The account has incorrect currency on Budget Organization range. The currency specified in the Load Budget function does correspond to the currency specified for that account combination on the Budget Organization Range of accounts. Red with cell comment
Error (Server Validation) The account combination is inactive. The current date is not within the Effective From and To dates for the specified account combination. Red with cell comment
Error (Server Validation) The account combination is not enabled. The Enabled check box for this account combination has been unchecked. Red with cell comment
Error (Server Validation) The account combination does not have a type of “entered” on the Budget Organization range assignment. The account has not been added to the specified Budget Organization range with Account Type set to ‘Entered’. Red with cell comment
Error (Server Validation) The account combination does not exist. The account combination has not been created yet.

If you are trying to automatically create account combinations and you are receiving this message then please refer to the Creating New Account Combinations page for more information regarding this functionality.

Red with cell comment
Error (Server Validation) The account combination contains a parent segment value. We cannot create code combinations with segment values that are parents. Red with cell comment
Error (Server Validation) The account is not assigned to this Budget Organization. The account combination specified has not been assigned to the Budget Organization range of accounts. Red with cell comment
Error (Server Validation) The account combination does not allow budgeting. The Allow Budgeting check box for this account combination has been unchecked. Red with cell comment

Processing Error Messages

These messages could occur while processing the load budgets.

Return Status Description Formatting
Error (Account Code Combination) The account code combination supplied does not exist. None
Error (Concurrent Request) An error has occurred with the concurrent request submission. Red
Error (Code Combination Create) The account Code Combination could not be created. Red
Error (Interrupted) The process of loading budgets was interrupted. Not all budgets where loaded. Red
Error (Multiple Formulas) The specific cell contains more than one Load Budget function. Red
Error (Parent Value SegmentN) SegmentN contains a parent value. We cannot create code combinations with segment values that are parents. Red
Error (Duplicate [$A$1]) You are trying to load more than one cell containing the same account combination, period, Ledger etc. into Oracle. The cell that contains the duplicate function will be displayed within the square brackets. Orange
Error (Duplicate) There is a duplicate load budget in the budget interface table. This will only occur when loading standard budget amounts. It will not occur when loading Budget Journals. Orange

Other Messages

These are the standard cell return statuses that users will commonly see.

Return Status Description Formatting
Ready (####.##) The Load Budget function has passed the client side validation and is ready to be validated by the server and uploaded into Oracle. The brackets will contain the actual input value that is going to be loaded. None
Valid The Load Budget function has passed both the client side and server side validations. None
Loaded The Load Budget function has successfully loaded. None
Trial This is a trial version of Budget Wand. You may only load the first three periods of your fiscal calendar. None