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

Last updated on JUNE 22, 2016

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion General Ledger - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms