EGL9.2: Error While Running Tree Flattener For Business Unit Trees: ORA-00904: "DV"."DESCR": invalid identifier
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.
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.
ORA-00904: "DV"."DESCR": invalid identifier
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