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.
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.
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