EGL: Tree Flattener Process (OI_TFLT) Leaves Description Blank When The Tree Dates Are Not Equal
Last updated on SEPTEMBER 14, 2016
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
Application release 9.2
The tree flattener process (OI_TFLT) populates the flattened tree table, OI_TFLT_DEPT, with the full hierarchical tree structure for each node. However, if a node description on the node table has a different effective date than the tree effective date, the node description is blank.
Tree flattener should use the most recent effective dated row to be consistent with how tree manager usually works
When multiple effective dates exists for a tree , the tree leaves the description blank after using the tree flattener because it is looking for data related to the wrong date
Tree manager showing inconsistent descriptions and this is confusing
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