Oracle Fusion · Data dictionary
GL_LOOKUPS
General LedgerUsed in 1 subject areas3 reporting columns
General Ledger (GL), configurable lookup values.
Primary key: LOOKUP_TYPE, LOOKUP_CODE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| DESCRIPTION | ● | Description. | |
| LOOKUP_CODE | PK | ● | Code identifying the lookup. |
| LOOKUP_TYPE | PK | ○ | Type of lookup. |
| MEANING | ● | Meaning. |
2 reports 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_LOOKUPS.
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.
Need the extract + dbt staging for GL_LOOKUPS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table