It actually surprised me that an application button had a name, but that was the PeopleSoft style. Anyway, the (more...)
Saving Gateway Metadata
There is a new functionality that saves the integrationgateway.properties configuration file in the database for future (more...)
Where PS_INSTALLATION could be any single-row table in the PeopleSoft data model.
If you look at the previous statement, the SELECT clause is not retrieving any field from the PS_INSTALLATION table, but just using it to comply with ANSI SQL. The same statement could be written in Microsoft SQL Server like this:
In order to keep customer's investment on custom reports safe, Oracle kept updating Crystal Reports certifications for those customers who purchased PeopleSoft (more...)
PS_JOB is probably the most popular and well known table in Peoplesoft HCM… The name explains by itself the content, job data component is in there.
If I would have a table on my own, I’d like to add line(s) with my name in it…
It just means that I’m always looking for a new contract. This is the intent of that blog entry. Sorry to the people who are seeking a technical subject, it’s (more...)
Today, I'm simply putting up a link to the best Oracle press release on recent cloud announcements. The release touts the six new platform services for (more...)
Our approach for identifying tables was not perfect. By examining the traces and logs, we missed some tables that were directly impacted by Application Designer (we did not enable tracing while copying the PeopleTools projects as it would have (more...)
If you are looking for any training in Oracle world customized to your specific needs, kindly contact email@example.com or visit www.d12tech.com
This naturally required both PeopleTools versions to coexist. Now, as you know, you cannot just install the new PeopleTools release binaries and point them to the new release. Each PeopleTools release can only connect to a database for which the PSSTATUS.TOOLSREL (more...)
Ok. Maybe this is a rant, but Data Mover can sometimes get under my skin! Some things you just expect to work, and when they don’t, it is very frustrating.
Here’s my problem. I created this very, very simple data import:
set log C:tempaa_setup_import_FADEV.log; set input C:tempaa_setup_export_AATST.dat; replace_data RQ_GRP_SHR_SET; delete PS_RQ_GRP_TBL where RQRMNT_USEAGE = 'ADV'; import RQ_GRP_TBL where RQRMNT_USEAGE = 'ADV';
It gave me this error:
Importing RQ_GRP_TBL Error: Syntax error in where (more...)
If you average out all of Oracle's new product development, (more...)
The new PUM images are a boon for anyone wanting to get a PeopleSoft instance up and running quickly. Once you’ve downloaded the zip archives however, you might find that the delivered zip file doesn’t work by default for everyone.
gives me the following error:
'unzip' is not recognized as an internal or external command
I’m not sure where the unzip utility is supposed to be from, but it’s not delivered (more...)