My Oracle Support Banner

Clicking the Edit Icon on a Dynamic Leaf for the PROJECTS_ALL Tree Structure Returns a SQL Error. (Doc ID 2645800.1)

Last updated on JULY 22, 2020

Applies to:

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


When attempting to add a dynamic leaf to a projects tree, the user receives a generic SQL error.  "A SQL error has occurred. Please consult your system log for deteails."

The application server APPSRV log shows the detailed error below.

Replication Steps:

  1. Navigate to Tree Manager and open the "ALL_PROJECTS" tree
  2. Click the "Insert Detail" leaf icon
  3. Check the Dynamic Flag checkbox on the resulting "Detail Value Range" popup and click Add





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.