Oracle Fusion · Data dictionary
FND_LOOKUP_VALUES_TL
Common / FoundationUsed in 218 subject areas13 reporting columnsBICC incremental-ready
Foundation / Setup (FND) — translation table — multi-language labels (join on the base key + LANGUAGE).
Primary key: LOOKUP_TYPE, LOOKUP_CODE, LANGUAGE, VIEW_APPLICATION_ID · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DESCRIPTION | ● | Description. | |
| LANGUAGE | PK | ● | Language. |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LOOKUP_CODE | PK | ● | Code identifying the lookup. |
| LOOKUP_TYPE | PK | ● | Type of lookup. |
| MEANING | ● | Meaning. | |
| SET_ID | ● | Identifier for the set. | |
| SOURCE_LANG | ● | Source lang. | |
| VIEW_APPLICATION_ID | PK | ● | Identifier for the view application. |
4 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 FND_LOOKUP_VALUES_TL.
- AP System Parameters Report
- Asset Book Controls Report
- Lease BU Configurations Report
- Ledger Options Report
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.
- Budgetary Control - Transactions Real Time
- Cash Management - Bank Statement Balances Real Time
- Cash Management - Bank Statement Line Charges Real Time
- Cash Management - Bank Statements Real Time
- Cash Management - External Cash Transactions Real Time
- Costing - COGS and Gross Margin Real Time
- Costing - Cost Accounting Period Close Real Time
- Costing - Cost Accounting Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Inventory Valuation Real Time
- Costing - Item Cost Real Time
- Costing - Landed Costs Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Costing - Overhead Rates Real Time
- Costing - Period Intransit Inventory Valuation Real Time
- Costing - Period Inventory Valuation Real Time
- Costing - Periodic Average Cost Real Time
- Costing - Perpetual Average Cost Real Time
- Costing - Receipt Accounting Period Close Real Time
- Costing - Receipt Accounting Real Time
Need the extract + dbt staging for FND_LOOKUP_VALUES_TL?
We ship parameterized SQL, BICC config, and dbt models you own.