Topic
Technical development for PeopleSoft PeopleTools:
- PeopleCode
- Online Development
- SQR
- Server Administration
- Databases
- etc.
Goal
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
About Me
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.
Resume
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.
Other Blogs
- 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
Hello,
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.
Thank you.
Regards,
Ram.
April 9, 2008 at 4:29 pm
Ram,
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,
Stephen
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?
Thanks
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
Hi there,
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. 🙂
Thanks.
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.
https://psst0101.wordpress.com/resources-on-the-internet/
May 24, 2012 at 11:17 pm
My Friend,
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…
Regards,
Abdul.
May 25, 2012 at 6:32 am
Wow, I am glad that it helped. Check out my new site at http://psst0101.digitaleagle.net.