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.
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.
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
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
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.
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.
http://psst0101.wordpress.com/resources-on-the-internet/
Hi Stephen,
I came across your site today when looking for information on Oracle SQL. It’s very comprehensive!
However, I did come across a few dead links, one of which (
https://psst0101.digitaleagle.net/2007/09/07/hcm90-reclaiming-index-space) links to http://www.dbazine.com/oracle/or-articles/weeg5 – which no longer exists.
I also run my own blog about Oracle SQL development:
https://www.databasestar.com
It might make a nice addition to your Resources page.
Either way, I hope this helps you out and keep up the great work with your site!
Thanks,
Ben