with mytree as (select distinct tnode.tree_name, tnode.parent_node_num, tnode.tree_node_num, tnode.tree_node, tlvl.tree_level, glacct.account, glacct.account_type, tnode.parent_node_name, glacct.descr from sysadm.pstreenode tnode, sysadm.pstreeleaf tleaf, sysadm.ps_gl_account_tbl glacct, sysadm.pstreelevel tlvl where tnode.setid=tleaf.setid and tnode.tree_name=tleaf.tree_name and tnode.effdt=tleaf.effdt and tleaf.tree_node_num between tnode.tree_node_num and tnode.tree_node_num_end and glacct.account between tleaf.range_from and…
Category: PeopleSoft
Disabling client side PeopleTools debugging
This afternoon, while migrating some objects from development to QA, my PeopleTools session was generating an error message that stated… “Debugging disabled. Communication failure during connect(): 10061. (143,9)” Since I wasn’t actually debugging anything, I opened Configuration Manager and on…
How to determine PeopleTools version
SQL> select toolsrel from sysadm.psstatus; TOOLSREL ——————– 8.51 SQL>