My Oracle Support Banner

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

Last updated on MARCH 21, 2024

Applies to:

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


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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

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