AnsweredAssumed Answered

Orphans records in INV_HIERARCHIES

Question asked by another_martink on Sep 14, 2010
Latest reply on Oct 20, 2010 by sundar
Just wondering about the orphan records in INV_HIERARCHIES ...

The Tech ref says
INV_HIERARCHIES
This table stores hierarchical relationship information between investments. It maps the parent to child relationships and also indicates what percentage of a child investment is allocated.

Column
Description

CHILD_ID
This column provides a reference to the child investment. The value corresponds to the ID found in INV_INVESTMENTS.

CREATED_BY
This column refers to the resource (CMN_SEC_USERS.ID) that created this row.

CREATED_DATE
This column refers to the date and time this row was created.

DEFAULT_ALLOC_PCT
This column indicates the default percentage allocated from the child investment to the parent investment.

LAST_UPDATED_BY
This column indicates the user who last updated the record.

LAST_UPDATED_DATE
This column provides the date when the record was last updated.

PARENT_ID
This column provides a reference to the parent investment. The value corresponds to the ID found in INV_INVESTMENTS.

When I created a new program a record is inserted in INV_HIERARCHIES where the program ID is the child_id. The table description does not give any indication of that. When I create a new project that does not happen. Why might that be? A program is likely to have projects or other under it and thus more likely to be a parent than a child.

Martti K.

Martti K.

Outcomes