Oracle Fusion · Data dictionary
GL_SEG_VAL_HIER_CF
General LedgerUsed in 38 subject areas13 reporting columns
General Ledger (GL).
Primary key: ENTERPRISE_ID, TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, CF_TREE_NODE_ID (Oracle's GL_SEG_VAL_HIER_CF_PK)
Joins (inferred from key columns): TREE_VERSION_ID → FND_TREE_VERSION_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| DEP0_PK1_VALUE | ● | Dep0 pk1 value. | |
| DEP22_PK1_VALUE | ● | Dep22 pk1 value. | |
| DEP23_PK1_VALUE | ● | Dep23 pk1 value. | |
| DEP24_PK1_VALUE | ● | Dep24 pk1 value. | |
| DEP25_PK1_VALUE | ● | Dep25 pk1 value. | |
| DEP26_PK1_VALUE | ● | Dep26 pk1 value. | |
| DEP27_PK1_VALUE | ● | Dep27 pk1 value. | |
| DEP28_PK1_VALUE | ● | Dep28 pk1 value. | |
| DEP29_PK1_VALUE | ● | Dep29 pk1 value. | |
| DEP30_PK1_VALUE | ● | Dep30 pk1 value. | |
| DEP31_PK1_VALUE | ● | Dep31 pk1 value. | |
| TREE_CODE | PK | ● | Code identifying the tree. |
| TREE_VERSION_ID | PK | ● | Identifier for the tree version. |
1 report read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to GL_SEG_VAL_HIER_CF.
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Cash Management - External Cash Transactions Real Time
- Costing - Cost Accounting Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Costing - Receipt Accounting Real Time
- Expenses - Expense Transactions Real Time
- Financials Common Module - Intercompany Transactions Real Time
- Fixed Assets - Asset Assignments Real Time
- Fixed Assets - Asset Balances Real Time
- Fixed Assets - Asset Depreciation Real Time
- Fixed Assets - Asset Retirements and Reinstatements Real Time
- Fixed Assets - Asset Transactions Real Time
- Fixed Assets - Asset Transfer Real Time
- General Ledger - Balances Real Time
- General Ledger - Journals Real Time
- General Ledger - Transactional Balances Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Invoices - Trial Balance Real Time
- Payables Payments - Disbursements Real Time
- Procurement - Procure To Pay Real Time
Need the extract + dbt staging for GL_SEG_VAL_HIER_CF?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table