I just saw that Packt is running a special on their books. To celebrate their 2,000th title, you get a free eBook with your purchase. If you’re in need of a book, now’s the time to check it out.
You can learn more on the Packt Website.
Ubuntu has been my choice of OS for some time now. It works great for the most part until I start trying to interact with the Microsoft-centric business world. App Designer is one of those pressure points. Normally, my clients give me a Windows-based remote desktop, but for playing around with things outside a client, I needed a way to run App Designer locally on my laptop.
I finally figured out how to install App Designer for Oracle’s PeopleSoft VM images directly in Ubuntu. Here’s what I did…
I ran into this error with the Ben Admin Snapshot process. It was the second time I ran into it, so I thought that I had better make sure that I got this in my notes so I would remember it.
Here’s the error…
Costs Not Found For Pgm/Plan/Optn: <benefit program>/<plan type>/<option code>. Application Program Failed In Pgm Section : MOVE-TO-PDEFN Application Program Failed In Pgm Section : TABLE-ACCESS(PSPBATBL) Application Program Failed In Pgm Section : MAIN(PSPBASCH)
This isn’t best practice, but I found a way to switch out a record in a query without redoing the criteria. Here’s the situation: I have a query in which the row-level security is causing problems. It is slowing down the query and also eliminating future-dated rows from the results. So, I created a view of the table which would select all of the rows from the original table. It was basically a copy with the query security view removed. The next challenge was to change the query to use that new record. If I remove the old record and add the new, I would have to redo the whole complicated query just about.
So, I found that I could update two records in the database:
UPDATE PSQRYFIELD SET RECNAME = '<new record name>' WHERE QRYNAME = '<query name>' AND RECNAME = '<old record name>'; UPDATE PSQRYRECORD SET RECNAME = '<new record name>' WHERE QRYNAME = '<query name>' AND RECNAME = '<old record name>';
After that, I found that I needed to open the query online in query manager, make a small change, and save it. After that, it worked fine with no problems.
Warning: use at your own risk. This isn’t the intended way to edit queries.
A common development task is to move data between two different PeopleSoft environments. You can use App Designer to move code, table structures, and pages, but data is a different story. Data Mover is your tool for moving your data.
My biggest challenge is that I don’t use it enough to have the syntax memorized. This post is a list of common tasks with the syntax to make it easier to remember…
The process scheduler provides a good standard way to launch a process. You simply add a subpage to your run control page, and the delivered “Run” button does all of the work for you. But sometimes, you want to run the process other ways. Sometimes, you might want to create a more customized feel on a end-user page and launch a process from a push button. Or, you might want to launch an additional process from an App Engine program.
In this post, I would like to drop notes to make this easier the next time I need to do it.
COBOL in PeopleSoft has long been one of my frustrations. I have had trouble with change assistant not getting the right version of the files in the correct directories. The compiler is an extra set of steps for installing and getting the system working. The license has to be installed in addition to the compiler, and most likely several run time environments. Typically, you would have to ship the COBOL programs between servers assuming you only have one server that is licensed to compile.
I can understand paying money for a program that you use, but COBOL doesn’t fit that description in my mind. Every client that I have worked at won’t touch a COBOL program: every customization must be outside the COBOL programs. So, why then should I have to pay thousands of dollars for a COBOL compiler?
So, I thought I would play with an open source compiler. I thought it would do two things:
So, here’s what I learned:
Switch to our mobile site