About

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

View my Linked In profile.

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.

7 thoughts on “About

  1. 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.

  2. 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

  3. 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

  4. 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.

  5. 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

Leave a Reply to Anonymous Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.