http://www.peoplesoftguys.com Tricks & Tips from PeopleSoft ERP Professionals Thu, 12 Feb 2009 00:59:13 +0000 http://backend.userland.com/rss092 en When first looked into PeopleBooks on how to implement the Fortgot Password functionality, it was very disappoing that the information provided is no where close to a successful implementation. After a deep struggle I was able to set this thing up, but if I look back I felt like "Oh! ... http://www.peoplesoftguys.com/2009/02/11/configuring-peoplesoft-forgotten-password-site/ The PSAPPSRV is responsible for the majority of the work on the application server.  It is just as important to start enough PSAPPSRVs as it is to not start too many.  By default, each PSAPPSRV has it's own Cache folder (unless you enabled shared cache).  For example, if you start 10 PSAPPSRV ... http://www.peoplesoftguys.com/2008/08/25/starting-the-correct-number-of-psappsrv-servers-performance/ To delete the server cache, normally we bring down the application server services and deltete the contents under $PS_HOME/appserv/{domain}/cache folder. We can workaround this complicated process by invalidating the current cache. You can use the following command to invalidate the cache. UPDATE PSSTATUS SET LASTREFRESHDTTM = SYSDATE Hope this helps some of you ... http://www.peoplesoftguys.com/2008/08/25/clearing-the-application-server-cache-without-shutting-it-down/ I know this sounds little stupid for some people, but for some people this is helpful. I know one guy who gets confused all the time with these two terms and comes and asks me all the time. I thought I would list these here and ask him to remember ... http://www.peoplesoftguys.com/2008/02/22/difference-between-custom-objects-and-customized-objects/ The following are the common AR Transaction tables PS_ITEM  - Item related information will be stored. PS_GROUP_CONTROL – Groups related information will be stored PS_PENDING_ITEM  - Pending items related to pending group will be stored. PS_ITEM_DST - Accounting information related to a pending group will be stored. PS_PENDING_DST - Accounting information related to a posted ... http://www.peoplesoftguys.com/2008/02/22/peoplesoft-ar-transaction-tables/   PeopleSoft change assistant is a standalone application delivered with PeopleTools 8.4x onwards. PeopleSoft change assistant can be used for applying patches and fixes for maintenance updates. PeopleSoft change assistant grabs all the required information from the Environment Management Hub and uploads it to the PeopleSoft customer connection site. With this environment ... http://www.peoplesoftguys.com/2008/02/22/peoplesoft-change-assistant/ Recently I wrote the following UNIX command line code to delete the older files in report repository and log files. I thought it might be useful for some one. Reports Delete find /psreports/PSPROD/* -type d -prune -mtime +15 -exec /bin/rm -R {} \; The above command will delete all the directories under /psreports/PSPROD ... http://www.peoplesoftguys.com/2008/02/21/unix-commands-to-delete-older-files/ PeopleSoft Data Mover issues COMMIT statements after most successful SQL commands, except for EXPORT and IMPORT commands. But for EXPORT and IMPORT commands, PeopleSoft Data Mover issues a COMMIT after each record. With IMPORT commands you can associate a  SET COMMIT n command, which will perform a COMMIT after the ... http://www.peoplesoftguys.com/2008/02/17/commit-statement-usage-in-peoplesoft-data-mover/ ENCRYPT_PASSWORD  Encrypt one or all user passwords defined in PSOPRDEFN table.   Example: ENCRYPT_PASSWORD ROGERS; EXPORT  EXPORT command will be used to export the data from a table or a join of tables and store the result set in a file. You can use the generated export file as input for migrating data to ... http://www.peoplesoftguys.com/2008/02/17/peoplesoft-data-mover-commands/ You can connect to PeopleSoft data mover in two modes depending on the previlages that your user id has. The following two are the modes that you can connect to the data mover. Regular mode. Most of the time you connect using this mode. To sign in to the data mover in ... http://www.peoplesoftguys.com/2008/02/17/peoplesoft-data-mover-operating-modes/