Oracle Fusion · Data dictionary
OKC_K_LINES_TL
SharedUsed in 8 subject areas3 reporting columns
Contracts (OKC), translation table, multi-language labels (join on the base key + LANGUAGE).
Likely primary key: K_HEADER_ID, LINE_NUMBER, LANGUAGE (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): K_HEADER_ID → OKC_K_HEADERS_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COMMENTS | ● | Comments. | |
| ITEM_DESCRIPTION | ● | Description of the item. | |
| ITEM_NAME | ● | Name of the item. | |
| K_HEADER_ID | PK? | ○ | Identifier for the k header. |
| LANGUAGE | PK? | ○ | Language. |
| LINE_NUMBER | PK? | ○ | Line number. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
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.
- Enterprise Contracts - Contracts Real Time
- Project Billing - Funding Real Time
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
- Project Costing - Actual Costs Real Time
- Project Costing - Expenditure Item Performance - Real Time
- Projects - Cross Subject Area Analysis - Real Time
- Projects - Grants Management - Award Funding Real Time
Need the extract + dbt staging for OKC_K_LINES_TL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table