myPeopleSoft

PeopleSoft Community Network

Dale Kittel's Likes

September 2013

How to get the Hierarchy of Peoplesoft App E… Hierarchy of AE called within AE How to get the order of peoplesoft App Engine execution sequence e.g for GL_JEDIT it goes upto 12 level deeper Select ae1.ae_level, ae1.AE_section_ORDER, ae1.stmt_tre… Discussion How to get the Hierarchy of Peoplesoft App E… 1 Like Delete PeopleSoft Query There are or could be different reason when we would like to delete any query from the databas. Beloe i have mentioned the SQL that are used to delete a query from the database. DELETE FROM PSQRYD… Discussion Delete PeopleSoft Query 3 Likes

August 2013

Module 3: Course Planner

video Module 3: Course Planner 1 Like Getting data out of PeopleSoft We have a PeopleSoft installation and I am building a separate web application that needs to pull data from the PeopleSoft database. The web application will be on a different server than PeopleSoft,… Discussion Getting data out of PeopleSoft 1 Like

May 2013

Query to determine which records user can se… Query to determine which records user can see SELECT DISTINCT B.TREE_NODE, Z.RECDESCRFROM PSTREEDEFN A,PSTREENODE B,PS_SCRTY_ACC_GRP C,PSTREENODE E,PSROLECLASS X,PSROLEUSER Y,PSRECDEFN ZWHERE A.SETID… Discussion Query to determine which records user can se… 5 Likes Oracle PeopleSoft Enterprise

Group Oracle PeopleSoft Enterprise 39 Likes SQL Error Has anyone enountered the following Message (we are on 8.9 Financials) SQL Error.Stmt #: 843 Error Position: 0 Return: 30 - ORA-00030:User Session ID does not exist Discussion SQL Error 5 Likes Upgrading to Oracle 11g Anyone have any experience upgrading to Oracle 11g? We are seeing some definite performance hits on PeopleSoft Financials with respect to nVision and sqrs. I've searched on metalink for performance d… Discussion Upgrading to Oracle 11g 3 Likes

April 2013

PeopleSoft Mobile Approvals

video PeopleSoft Mobile Approvals 5 Likes PeopleSoft Mobile Inventory

video PeopleSoft Mobile Inventory 8 Likes

March 2013

Useful queries in peoplesoft "RenameQueries.sql"UPDATE PSQRYDEFN set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem where projectname = 'VCR_QUERIES_BM');UPDATE PSQRYDEFNLANG set… Discussion Useful queries in peoplesoft 5 Likes

Welcome to
myPeopleSoft

Sign Up
or Sign In

Or sign in with: