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

Custom Drill Columns

The custom drilldown column functionality was added to allow customers to expand the drilldown reports to include additional data that is not available in the standard Oracle ERP Cloud views that support the drilldown reports. When a custom column is added to a drilldown, the SQL statement for the custom column is merged into the main drilldown query when it is executed. The SQL for custom drilldown columns must be constructed in a very specific way in order to work correctly. Custom drilldown columns can be added to a number of the drilldown reports. See the links below for the detailed instructions for each of the supported items:

  • Journal Custom Columns
  • Journal Full Custom Columns
  • Subledger Custom Columns