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

ACN_IDEA_RELATIONSHIP_V

SharedUsed in 4 subject areas10 reporting columns

denormalized view.

Primary key: not yet catalogued for ACN_IDEA_RELATIONSHIP_V — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
DERIVED_COMPONENT_IDIdentifier for the derived component.
DERIVED_CONCEPT_IDIdentifier for the derived concept.
DERIVED_PROPOSAL_IDIdentifier for the derived proposal.
DERIVED_REQUIREMENT_IDIdentifier for the derived requirement.
DERIVED_REQUIREMENT_LINE_IDIdentifier for the derived requirement line.
DEST_OBJ_TYPEType of dest obj.
FINAL_DERIVED_IDIdentifier for the final derived.
OBJECT_VERSION_NUMBEROptimistic-locking version number, incremented on each update.
RELATIONSHIP_IDIdentifier for the relationship.
SRC_OBJ_TYPEType of src obj.

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 ACN_IDEA_RELATIONSHIP_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us