My Oracle Support Banner

EGL9.2:Processes Uses Flattened Tree Tables Even Though Installation Option is Set with Maintain Flatten Tree Data = 'General Ledger Reporting’ (Doc ID 2650852.1)

Last updated on MARCH 19, 2020

Applies to:

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

Symptoms

Batch processes such as Allocations (FS_ALLC) and Chartfield Security Build (SEC_BLD) are referencing the flattened tree tables ex - PS_OI_TFLT_ACCOUNT even though Installation Option: Maintain Flatten Tree Data = 'General Ledger Reporting’.
The Oracle documentation indicates that batch process will use the flattened tree tables only if Maintain Flatten Tree Data = 'Detail List’ option is checked on.

Steps to replicate:

1. Navigate to Set Up Financials/Supply Chain > Install > Installation Options
   and select 'Use Flatten Tree Data' checkbox. Then, click 'Maintain Flattened Tree Data' hyperlink and select 'General Ledger Reporting' option.
2. Run either Allocations (FS_ALLC) and Chartfield Security Build (SEC_BLD) process.
3. Check trace files. Noted that process uses the flattened tree tables

See replication here.

Changes

 

Cause

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
Symptoms
Changes
Cause
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.