Technical development for PeopleSoft PeopleTools:
- Online Development
- Server Administration
The goal of this blog is three-fold:
- Documenting Things I Learn: in case I have to do it again
- Share My Knowledge: in case others happen to attempt the things that I do
- Networking: bulding a network of readers or acquaintances
I am a PeopleSoft Technical Consultant. I work for a small consulting firm who places me in contracts that generally have started as short term but have extended much longer.
I started my life with computers in middle school. My programming started in eighth grade with Visual Basic. For college, I got a computer science degree, and then, I started programming contracts. At first, I was using Java, but then, I worked my way into SQR and finally PeopleTools.
Here are some of the topics that I have had experience with:
- SQR: Worked on numerous SQR reports and processes for an HR Management company. The biggest was a Benefits reconciliation process.
- PeopleTools: Created numerous run controls, online pages for self-service, interfaces
- Application Engine: Created and maintained interfaces, etc.
- Component Interface: Created programs to load data into the Tax Data screens, Applicants, Person Data, Visa Data, User Profile/Security. Created programs to hire people in batch. Accessed component interfaces from Online PeopleCode and from Application Engine programming.
- System Administration: Installed HCM90, HCM91, PeopleTools 8.49, PeopleTools 8.50, Financials Demo systems. Maintained systems with Tax Updates and Bundles. Trained a technical team in System Administration tasks such as cloning and refreshing instances.
- Conversion: Built a Framework for converting from POISE, which stores data in VSAM files. Built a framework that could easily launch Application Engine programs in specified order to copy the data into the PeopleSoft tables.
- Training: Taught on-site courses in PeopleTools I, PeopleTools II, SQR, Application Engine, PeopleCode, etc.
- Linux Sagas: My journeys into the Open Source world with Linux and other open source programs and technologies.
- Digital Eagle: My personal ramblings, etc.
April 8, 2008 at 2:58 pm
This is Ram working as a PeopleSoft Admin.
Requesting your assistance with the below question:
We have a PeopleSoft application on DB2 database with operating system: AIX
Currently we have the PeopleSoft schema under “arbtadm”, similar to “sysadm” as both ownerid and accessid
I would like to change the ownerid: to “arbpadm” and leave accessid as-is “arbtadm”
How can I do that. Any documents that I can use to accomplish the same.
April 9, 2008 at 4:29 pm
That is a big question. I can’t give you a step by step answer, and I don’t know any resources offhand that might help. But, maybe a few thoughts might give you some ideas.
You can create a project with all of the records:
– Create a new project in App Designer
– Insert > Definitions into project (Ctrl + F7)
– Change the Definition Type to record
– Click the Insert button to load all the records in the system
– Click Select All to select them all in the list
– Click Insert again to insert into the project
– You should probably save the project at this point
You can create a build script by building the project
– Build > Project
– Click the Settings button
– On the Create tab choose: Skip table if it already exists, Recreate view if it already exists, and recreate index if it already exists
– On the Alter tab check: Alter even if no changes (important because you haven’t made any changes to these records)
– On the scripts tab select output to single file
– Click OK to go back to the build dialog
– For the build options: check all the options (Create tables, Create views, Alter tables, etc)
– For the Execute options: choose Build script file
– Click build
Once this completes you should have a script that will rebuild your entire database. From this point, I am guessing you could do something like a search and replace to change arbtadm to arbpadm.
As far as other things you will have to do:
– update the psadmin profiles (both App server and Process schedulers)
– security for tables that the access id needs (not sure off the top of my head — PeopleBooks should have some info here)
Let me know if I can help more. I am not sure if this is what you were asking or not. Hopefully, someone else will chime in if they have any better ideas.
Hope that helps,
November 21, 2008 at 8:18 pm
I found in a table which tables and which level they occur on a page,but, Where do I find in a giving page which table is parent and which table is child?
July 27, 2009 at 9:15 am
[…] Oracle planning to release PeopleTools 8.50 in September? The author of the PSST0101 blog has found a significant clue. The PeopleSoft Enterprise PeopleTools Maintenance Schedule for […]
January 27, 2010 at 3:14 am
I have a similar blog (only has one post right now but I intend to publish random findings, etc) and I have a similar background as yourself.
I thought perhaps we can exchange links on our sites? I found your site through a random query relating to the metadata tables.
My site is http://www.erpwizard.com/ and is equally spartan. 🙂
February 1, 2010 at 11:02 pm
I posted your site on my Resources page. Thanks for the info. Keep up the posting — I’m learning that it is harder work than I thought.
May 24, 2012 at 11:17 pm
Your site is very ultimate. It really helped me a lot. I completed a PeopleTools Upgrade recently from 8.42.15 to 8.51.15. Your site help me to complete this upgrade successfully. I sincerly dedicate my thanks to you…
May 25, 2012 at 6:32 am
Wow, I am glad that it helped. Check out my new site at http://psst0101.digitaleagle.net.