Good bye SES

With respect to PeopleSoft Campus Solutions, Oracle SES is for enabling a rich search features. It is much better than Verity and provides more options for your search, related actions etc. etc. Yes, the options looked great and robust. All enterprises require a better, efficient way of data mining capabilities and Oracle SES was the out of the box solution. I was excited and posted about its features way back when SES was released.

Notification Framework Error

Notification cannot be sent due to following error:  Notification cannot be sent.  Notification data cannot be saved due to error: Negative number assigned to an unsigned field: SCC_NTFREQ_HDR.SCC_NTFREQ_ID. (2,121)

Related Content Not Appearing

One of the first steps:
Verify the authentication domain set-up on the web profile configuration.

Easy Search Match Piece of Code for CRM

This is a pretty sleek implementation for PeopleSoft CRM applications.

Function Search_match(&strFirst_name, &strLAST_NAME, &strBIRTHDATE, &strEMAILID) Returns string;
   Local Record &ANO_PERS_TBL;

CRM Mail Reader Process Error

Future Reference Purpose:

Not sure how this is related to the Solution row, but that's what Oracle recommends.

The highlighted field  is required.  You must enter a value for it before
proceeding.{RB_EM_IB_CI.SETID} (15,54)

The highlighted field  is required.  You must enter a value for it before
proceeding.{RB_EM_IB_CI.RC_SUMMARY} (15,54)

Error saving Component Interface. {RB_EM_IB_CI} (91,37)

 The highlighted field  is required.  You must enter a value for it before
proceeding.{RB_EM_IB_CI.SETID} (15,54). The highlighted field  is required.
You must enter a value for it before proceeding.{RB_EM_IB_CI.RC_SUMMARY} (15,
54). Error saving Component Interface. {RB_EM_IB_CI} (91,37).  (0,0)

Error in Saving the Inbound Email component Interface (17834,7075)

Aborting Mailreader process because Inbound CI Error.Please contact your
System Administrator (17834,7150)

Response from Oracle Support:
ERMS RB_MAIL_READ not storing the Email in the PS_RB_IN_EMAIL and
throws Error in RB_EM_IB_CI. This issue Occurs in System Env if there are no
Solutions in the Env.

SetID not found for name='SETID' in CRM

For reference purpose.

1. Make sure you have the SHARE Set ID exist in the system. If that exist, go with the option 2
2. Set the User Preferences: Set Up CRM > Security > User Preferences & set the valid SetID value

SetID not found for name='SETID', value='' with record 'EOCF_EVENT_SEQ', tree ''. (2,214) EOCF_CLF_DE.RuleService.OnExecute  Name:SET_CONTROL  PCPC:2991  Statement:74
Called from:FUNCLIB_89_PRSN.PERSON_ID.FieldFormula  Name:CLATrigger  Statement:1189
Called from:FUNCLIB_84_PRSN.RC_POSTBUILD.FieldFormula  Name:PersonPostBuild  Statement:25
Called from:RD_PERSON.GBL.PostBuild  Statement:1

The PeopleCode built-in function GetSetID has been called with parameters that were
not found in the table set definitions.

Review the table set control tables and the PeopleCode and correct whichever is wrong.

PTF Tables & a Handy SQL

PeopleSoft Test Framework is used in several projects now a days. Although some are not ready to accept this testing tool, the benefits and the flexibility this tool provides in the testing phase is inevitable.

Couple of handy tips related to PTF given below.

Below are the main tables in PTF if you want to create a custom easy reporting from the back end.

PSPTTSTDEFN --Get information about the Test from the Test Definition Tabl
PSPTTSTERROR --Get all error messages associated with the Test
PSPTTSTDESCR --Get comments associated with the Test from the Test Description Table
PSPTTSTCASE --Get information about the Test Cases for this Test from the Test Case
PSPTTSTCOMMAND -- Get information about the Test Steps for this Test from the Test Command
PSPTTSTCMDDESCR --Get comments associated with the Test Steps from the Test Command
PSPTTSTCASEVAL --Get the values associated with the Test Cases from the Test Case Values
PSPTTSTLOG_LIST  --Get the PTF test status from this table
PSPTTSTLOG_LNS --Get the test log lines from tis table

Although there are couple of user level reports available with the package, those aren't much intuitive for the testing resources.

A simple but a very handy piece of SQL is given below:
SELECT A.PTTST_NAME,A.DESCR,B.PTTST_LOG_ID,CASE PTTST_LOG_RESULT WHEN 110 THEN 'Pass' WHEN 121 THEN 'Warning' WHEN 120 THEN 'Fail' END AS TEST_STATUS,
A.LASTUPDDTTM,A.LASTUPDOPRID FROM PSPTTSTDEFN A,PSPTTSTLOG_LIST B WHERE A.PTTST_NAME=B.PTTST_NAME
ORDER BY PTTST_NAME,PTTST_LOG_ID;