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
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern