Creating an Activity Guide : VFO from Oracle

Here is the last VFO of last week.

This time it is about Activity Guides, a powerful way to present business process to end users.

Why Upgrade to PeopleSoft SCM 9.2? : VFO from Oracle

Fifth VFO of the week talks about why customers should upgrade to PeopleSoft SCM 9.2

Mobile Time Entry : VFO from Oracle

They say the VFO team is on fire. And why not? This is the 4th VFO of the week.

It talks about the mobile time entry applications available in PeopleSoft.

Why Upgrade to PeopleSoft Financials 9.2? : VFO from Oracle

Third VFO of the week is an interesting one.

Why Upgrade to PeopleSoft Financials 9.2? Watch this short video.

eBill Payment : VFO from Oracle

Here is the second VFO of this week.

eBill Payment is part of PeopleSoft's credit to cash solution in Oracle's PeopleSoft Financial Management applications suite.

PeopleSoft Virtualization : VFO from Oracle

Oracle Information Development team have been busy this week and have been releasing at least one VFO per day. So here is the first one of the week.

This talks about the prebuilt virtual box images available for PeopleSoft 9.2 applications. A must watch for PS Admins out there.

Grants WorkCenter : VFO from Oracle

This is short video about the Grants WorkCenter in PeopleSoft Enterprise Service Automation 9.2 suite.

PeopleTools Patch 8.53.07 is Generally Available

Oracle released the PeopleTools Patch 8.53.07 this week. It is available for download via My Oracle Support.

How to download it from MOS

• Login to My Oracle Support.
• Click on ‘Patches and Updates’ Tab.
• In Product Or Family (Advanced), Select Product =‘PeopleSoft PeopleTools’,   Release=”PeopleTools 8.53”, Search. 
• Select the 8.53.07 patch, Download Patch Zip file.

Various IDs in PeopleSoft

You might have come across various Ids used to for signing on to PeopleSoft Application. User Id, Connect and Access Ids are most important of them. So what are they? What do they really do?

Here is a brief description of various Ids

User Id

The User Id is the ID associated with the individual user logging onto the PeopleSoft application, via PeopleTools.Validation of this ID is performed by the PeopleTools themselves at log-in time, by virtue of verifying that a row has been defined in the PSOPRDEFN table for this ID. The row in the PSOPERDEFN table contains information pertinant to PeopleSoft internal security administration, such as the access profile defining what areas of the application this ID will have access to, and a link to the ACCESS ID (defined later) associated with the UserId.

Connect Id

The Connect Id is the actual ID that makes the initial log on connection to the database.It requires SELECT ONLY access to three tables: PSSTATUS, PSOPRDEFN, and PSACCESSPRFL.Once the row is located in PSOPRDEFN associated with the User Id entered, the associated Access Id is validated within PeopleTools, and the Connect Id is disconnected, and the Access Id is logged on.

Symbolic Id

The Symbolic Id isn't really an Id at all, but is referred to as such in the PeopleTools documentation. The Symbolic Id provides the "link" between the row containing the User Id in table PSOPRDEFN with the row containing the corresponding Access Id and Password in table PSACCESSPRFL. The Symbolic Id field is a regular field on table PSOPRDEFN and the key field on table PSACCESSPRFL. For each Access Id defined, you should define a unique Symbolic Id within the PeopleTools table PSACCESSPRFL. The Access Id is associated with the unique Symbolic Id in table PSACCESSPRFL, and the Symbolic ID is then linked with the specific User Id in table PSOPRDEFN, by updating the PSOPRDEFN.SYMBOLICID column.

Access Id

The Access Id is the ID under which all DML is initiated.

Compare data from tables in 2 databases / MS SQL Server

Here is the SQL to compare the differences in the data in different tables with same structure. Will be helpful for comparing the data between databases. This works in MS SQL Server if both databases are on same server or if there is a linked server configured for the other database.

SELECT  * FROM
(SELECT Max(TableName) AS TableName, FIELD1, FIELD2, FIELD3
FROM (SELECT 'HRDB1..PS_MY_RECORD' AS TableName, FIELD1, FIELD2, FIELD3
FROM HRDB1..PS_MY_RECORD
UNION ALL SELECT 'HRDB2..PS_MY_RECORD' AS TableName, FIELD1, FIELD2, FIELD3
FROM HRDB2..PS_MY_RECORD ) A
GROUP BY FIELD1, FIELD2, FIELD3
HAVING COUNT(*) = 1) A
ORDER BY 1

 

Replace table names, database names and fields list accordingly.

Compare Report in CSV or HTML format

Most of us know how to do compare projects in Application Designer. But how do we take the compare report in CSV or HTML format?

Here is an article which talks about Compare Report in CSV or HTML format.