Oracle Fusion · Data dictionary
PJF_EVENT_TYPES_VL
ProjectsUsed in 4 subject areas1 reporting columns
Projects Foundation (PJF), view layer, joins the base table with translations for the current language.
Likely primary key: EVENT_TYPE_CODE (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): EVENT_TYPE_CODE → XLA_EVENT_TYPES_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| EVENT_TYPE_CODE | PK? | ○ | Code identifying the event type. |
| EVENT_TYPE_NAME | ● | Name of the event type. |
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.
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
- Project Control - Budgets Real Time
- Project Control - Forecasts Real Time
Need the extract + dbt staging for PJF_EVENT_TYPES_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table