My Oracle Support Banner

EGL 9.2: Questions on Tree Flattener (Doc ID 2193399.1)

Last updated on JULY 07, 2020

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
****Checked for currency 21-MAR-2018****

Goal

 

Questions related to Image 19 tree flattener capabilities.

Question 1:

Can tree flattener only run on trees where we have “All Detail values in this Tree” selected?

Question 2:


User noticed that no tree flattener tables starting with R_TFLT have been populated when we ran the tree flattener. Is this normal, when should the R_TFLT… tables (ex; R_TFLT_OPRUNIT) table be populated?
 
Question 3:

Why is there no BU table for R_TFLD_BU?

Question 4:

What process exactly can run using the flattened tree data ?

Question 5:

How often can tree be flattened if we are using to run jobs?

Question 6:

What are the pro's/con's of using flattened data over the actual tree?

Question 7:

What are the configuration changes that we should consider if we move to using the flattened tree data?


 

Solution

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
Goal
Solution
References


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