Oracle Fusion · Data dictionary
ENQ_ISSUES_B
SharedUsed in 5 subject areas13 reporting columns
base table, language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: ISSUE_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): ISSUE_ID → ENQ_ISSUES_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_RESOLUTION_DATE | ● | Actual resolution date. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DISPOSITION | ● | Disposition. | |
| DOWNTIME | ● | Downtime. | |
| EXPECTED_RESOLUTION_DATE | ● | Expected resolution date. | |
| ISSUE_ID | PK? | ● | Identifier for the issue. |
| ISSUE_NUMBER | ● | Issue number. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LIKELIHOOD_OF_RECURRENCE | ● | Likelihood of recurrence. | |
| QUALITY_TYPE_ID | ● | Identifier for the quality type. | |
| REPORTED_BY | ● | Reported by. | |
| SEVERITY | ● | Severity. | |
| SOURCE | ● | Source. |
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 Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Maintenance Management - Maintenance Exception Real Time
- Manufacturing - Production Exceptions Real Time
- Product Management - Change Order Real Time
Need the extract + dbt staging for ENQ_ISSUES_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table