FAQ: Updating Hierarchy Data Via the Rapid Implementation Template (Doc ID 2152440.1)

Last updated on MARCH 21, 2024

Applies to:

Goal

Qn1:When creating hierarchies via the Rapid Implementation (RI) template, which processes get launched automatically?
 
Qn2:When a hierarchy is created via Rapid Implementation (RI) the tables GL_SEG_VAL_HIER_CF and GL_SEG_VAL_HIER_RF get updated with the information of the hierarchies.

When the hierarchy is updated also using the RI template, to for instance add one value to the hierarchy, those tables don't get updated with the new value.
This is seen by running the queries below, which don't return any rows:
select pk1_value from GL_SEG_VAL_HIER_RF
where tree_code = '&tree'
and pk1_value = '&new_value';

select dep0_pk1_value from GL_SEG_VAL_HIER_CF
where tree_code = '&tree'
and dep0_pk1_value = 'new_value';

It is necessary to run the flattening programs separately to force flattening after updating the hierarchies via RI. After that the new values get populated in the tables.
Is this the expected behavior?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.