Contact Us
Index
Version 21.1
Version 20.3 Version 20.4
Contact Us
Split Text
Combine Text
Last Refreshed By
Last Refreshed Time
Snapshot
Common Options
Shared Templates Drive
Drive Types
Dropbox
Edit a File
File Server
Oracle Cloud Connector Database
Navigator
Open a File
Create a File
Delete a File
System Administrator Options
System Administrator User Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
Discover Period Names
Discover Segment Properties
Expand and Explode
Expand Segment Value Hierarchy
Explode Segment Values
Explode Segment Value Hierarchy
Expand Segment Values
Discover Segment Values
Discover Level
List of Values – Create
Next Segment Value
Get Balance
Multiple Ledgers
Get Balance Options
Period Offset
Functional Currency
Period Name
Segment Start Date
Enabled Flag
Parent Flag
Segment Tree
Account Type
Financial Category
Segment End Date
Ledger Set
Segment Description
Ledger Name
Previous Segment Value
Period End Date
Period Start Date
Period Name by Date
Analyze Balances
Drill to Journal or Subledger
Drill Criteria Sheets
Drill Criteria – Journal Extract
Drill Criteria – Balance
Drill Using a Saved Template
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand User Options
Other Tools
Hide Zeros
Advanced Options
Email
Drilldowns
Parameters
Source Report
Named Ranges
Execution
Load and Validation
Running the Scheduler
Create Schedule
SMTP Email Settings

Segment Tree

Returns the segment tree name for the chosen segment value. The tree code is represented in brackets next to the name. The tree can be configured in Oracle Cloud.

Parameter Description
Segment Value The segment value.
Segment The segment number.
Ledger Optionally enter a Ledger Id to bind the formula to a specific Ledger. If this parameter is omitted, the Ledger currently selected in the Ledger dropdown list will be used.
Independent Value For dependent segments, enter the independent value that the segment value relates to.

Example: =OCL_GLW_Segment_Tree(“1210”,3,1)