My Oracle Support Banner

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

Last updated on JANUARY 31, 2022

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.



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?



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.