EGL 9.2: Questions on Tree Flattener

(Doc ID 2193399.1)

Last updated on JUNE 14, 2018

Applies to:

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

Goal

On : 9.2 version, Documentation Image 19

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

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