My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.