Category: PeopleSoft

Peoplesoft – Printing Balance sheet tree

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…

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…