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.

8 Responses to “About”

  1. Ram Says:

    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. digitaleagle Says:

    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. Eva Says:

    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. PeopleSoft 8.50: See you in September? : PeopleSoft Wisdom Says:

    […] 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 […]

  5. Anonymous Says:

    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.

  6. digitaleagle Says:

    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/

  7. Abdul Says:

    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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: