Oracle Fusion · Data dictionary
DOO_HOLD_INSTANCES
SharedUsed in 1 subject areas7 reporting columns
Order Management (DOO).
Likely primary key: HOLD_INSTANCE_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVE_FLAG | ● | Indicator (Y/N) for the active. | |
| APPLY_DATE | ● | Apply date. | |
| APPLY_SYSTEM | ● | Apply system. | |
| HOLD_COMMENTS | ● | Hold comments. | |
| HOLD_INSTANCE_ID | PK? | ● | Identifier for the hold instance. |
| HOLD_RELEASE_COMMENTS | ● | Hold release comments. | |
| RELEASE_DATE | ● | Release date. |
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.
Need the extract + dbt staging for DOO_HOLD_INSTANCES?
We ship parameterized SQL, BICC config, and dbt models you own.