Oracle Forms Hierarchical Tree

 SELECT 1, LEVEL, last_name ||' '|| first_name , '', employee_id
   FROM employees
  START WITH manager_id IS NULL
CONNECT BY PRIOR employee_id = manager_id

Select 5 columns:
I -    Status (0, 1)
II -   Hierarchical Level (Oracle LEVEL pseudo column)
III -  Label
IV -  Icon file name (or null)
V -   Value

Get the new frmwebutil.jar after 10.1.2.3 patch

Find the patch instalation directory


open CMD and go to:
[patchDir]\Disk1\stage\Patches\oracle.developer.forms.builder\10.1.2.3.0\1\DataFiles

run:
[$ORACLE_HOME$]\jdk\bin\jar xf webutil2.2.jar frmwebutil.jar

rename frmwebutil.jar0 to frmwebutil.jar

backup:
[$ORACLE_HOME$]\forms\java\frmwebutil.jar

copy the new frmwebutil.jar from
[patchDir]\Disk1\stage\Patches\oracle.developer.forms.builder\10.1.2.3.0\1\DataFiles
to
[$ORACLE_HOME$]\forms\java\

in the CMD go to:
[$ORACLE_HOME$]\jdk\bin

make sure to take down the apps server (using the EM)

run:
[$ORACLE_HOME$]\forms\webutil\sign_webutil.bat [$ORACLE_HOME$]\forms\java\frmwebutil.jar

restart the app server