EGL9.2: Tree Flattener Process (OI_TFLT) Not Inserting Data in PS_OI_TFLT Tables After Upgrade To FSCM 9.2 PUM13
Last updated on SEPTEMBER 27, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Check for currency 7-Jun-2017***
Having issues with Tree Flattener utility after 9.2 PUM13
Previously when using tree flattener, the flattened tree data was stored on OI_TFLT_OPRUNIT
After upgrade to PUM13 there appears three Tree Field Tables instead of one:
The three tables are:
OI_TFLT_OPRUNIT (OTBI table)
DL_TFLT_OPRUNIT (detail table)
R_TFLT_OPRUNIT (range table)
The data from the flatten request is now getting stored on R_TFLT_OPRUNIT and/or DL_TFLT_OPRUNIT, but not OI_TFLT_OPRUNIT
Data in OI_TFLT_OPRUNIT is blank.
Customer wants the data to still be written to OI_TFLT_OPRUNIT.
The issue can be reproduced at will with the following steps:
1. Page Tree Flattener ( Navigation path: Set Up Financials/ Supply Chain > Operational Reporting > Tree Flattener > Tree Fields) now showing 3 columns instead of 2 for Details, Ranges and OTBI
2. Run the tree flattener request (Navigation path: Set Up Financials/ Supply Chain > Operational Reporting > Tree Flattener > Tree Flattener Request) for process type Flatten Tree, Field Name Operating Unit
3. Check for the flatten data in OI_TFLT_OPRUNIT but returns 0 rows as the data got inserted in R_TFLT_OPRUNIT and/or DL_TFLT_OPRUNIT.
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