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. 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.
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