EGL9.2: Tree Flattener Process (OI_TFLT) Not Inserting Data in PS_OI_TFLT Tables After Upgrade To FSCM 9.2 PUM13 (Doc ID 2063373.1)

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

Symptoms

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.


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

Cause

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