Oracle Fusion · Data dictionary
GL_SEG_VAL_HIER_CF
General LedgerUsed in 38 subject areas13 reporting columns
General Ledger (GL).
Primary key: SEG_VAL_HIER_CF_ID
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. | |
| SEG_VAL_HIER_CF_ID | PK | ○ | Identifier for the segment val hier cf. |
| TREE_CODE | ● | Code identifying the tree. | |
| TREE_VERSION_ID | ● | 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. You can't join across them in OTBI, the owned conformed model joins them on shared 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