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, VIEW_APPLICATION_ID, SET_ID, LANGUAGE, ENTERPRISE_ID, SANDBOX_ID (Oracle's FND_LOOKUP_VALUES_TL_PK) · 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 | PK | ● | 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. 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.
- 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.
Problems that run through this table