Analytics Catalog/Data dictionary/DOO_PROCESS_INSTANCES
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

DOO_PROCESS_INSTANCES

SharedUsed in 1 subject areas10 reporting columns

Order Management (DOO).

Likely primary key: DOO_PROCESS_INSTANCE_ID (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

ColumnKeyIn reportsDescription (inferred)
ACTUAL_COMPLETION_DATEActual completion date.
ACTUAL_START_DATEActual start date.
CREATION_DATEDate and time the row was created.
DOO_PROCESS_INSTANCE_IDPK?Identifier for the doo process instance.
JEOPARDY_REASONJeopardy reason.
JEOPARDY_SCOREJeopardy score.
PLANNED_COMPLETION_DATEPlanned completion date.
PROCESS_ACTIVEProcess active.
PROCESS_NUMBERProcess number.
REQUIRED_FULFILL_DATERequired fulfill 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_PROCESS_INSTANCES?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us