EGL9.2: Error While Running Tree Flattener For Business Unit Trees: ORA-00904: "DV"."DESCR": invalid identifier (Doc ID 2090504.1)

Last updated on JANUARY 04, 2017

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
----------
While attempting to run Tree Flattener process for Business Unit trees whose tree detail record doesn’t have DESCR field goes to No success.


Steps to Replicate:
---------------------
1. In PIA navigate to Set Up Financials/Supply Chain > Operational Reporting > Tree Flattener > Tree Flattener Request
2. Create a request to run Tree Flattener process for field Business unit & Tree :AR_BUSINESS_UNITS & click Run.
3. Create a request to run Tree Flattener process for field Business unit & Tree :AR_BUSINESS_UNITS & click Run
4. Observe the process status & message log in process monitor after the process completes.


Please see Replication screenshots for more details.

Error:
------

ORA-00904: "DV"."DESCR": invalid identifier

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