My Oracle Support Banner

EGL: Getting SYSAUDIT Error "TREE-09 -Tree Structure Table Contains Summary Tree That Does not Exist in Tree Level table" During Fin 9.2 Installation (Doc ID 2066896.1)

Last updated on JANUARY 03, 2023

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 Image 12
Peopletools 8.54.10

ACTUAL BEHAVIOR
---------------
Getting TREE-09 reported on SYSAUDIT as follows

(TREE-09) Tree Structure table contains Summary Tree that does not exist in Tree Level table

Tree Structure ID
---------------------
DEPTID_SUM
DEPTID_SUM2
ACCOUNT_SUM
ACCOUNT_SUM2


Description
-------------------------------
Summary of MFG_DEPARTMENTS
CLASS
Summary Rollups of ACCTROLLUP
CLASS

Detail Set ID
-------------------
SHARE
SHARE
SHARE
SHARE

Detail Tree Name
---------------------
DEPTSUMMARY
DEPARTMENTS
ACCTROLLUP
ACCTROLLUP2


EXPECTED BEHAVIOR
-----------------------
There should be no TREE-09 issue on the sysaudit report

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install 9.2 Image 12 with Peopletools 8.54.10
2. Run sysaudit

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.