My Oracle Support Banner

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 MAY 02, 2023

Applies to:

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

Symptoms

Issue:
-------

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


Steps to Replicate:
---------------------


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.

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.