tag:blogger.com,1999:blog-75916418450606777302024-03-14T13:43:56.778-04:00PeopleSoft Learning Sharing PeopleSoft LearningsSandeep Ghttp://www.blogger.com/profile/16233707014779544910noreply@blogger.comBlogger288125tag:blogger.com,1999:blog-7591641845060677730.post-73187971163280964242019-10-16T14:21:00.001-04:002019-10-16T14:21:45.985-04:00Excel - to CI - Compile error - User Defined Type not defined.<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
When using ExcelToCI on Windows 10, trying to load template or stage and submit data, it gave a 'Compile error' that reference to Visual Basic code reference to DOMDocument object. </div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
Users usually get a "Compile error: User-defined type not defined" error</div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
This not an error in the Windows 7 OS, it is an issue with Windows 10. More corporate users are now moving the Windows 10 as the support earlier OS is coming to an end.</div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
More users are facing the issue with the Excel-to-CI on there Windows 10 system. There are multiple solutions on different blogs to update the code (which works).</div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
For easy access, I have attached the complete template for 8.54 and 8.55 (and Above) tools versions to the user the Excel to CI template for the Windows 10 OS.</div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
This is provided by Oracle and it works fine in both old and new OS.</div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
<br /></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
8.54 - <a href="https://drive.google.com/open?id=14yosVvznYCRGqGqw1lVK55fqRgpEZEDh">https://drive.google.com/open?id=14yosVvznYCRGqGqw1lVK55fqRgpEZEDh</a></div>
<div style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">
8.55 - <a href="https://drive.google.com/open?id=12UtPA7vxUWIxpYsk1SsPZ7NBd-sojADJ">https://drive.google.com/open?id=12UtPA7vxUWIxpYsk1SsPZ7NBd-sojADJ</a></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-77591371801424067742019-10-04T00:56:00.001-04:002019-10-04T00:56:23.928-04:00PSQuery Performance issues with Rowlevel Query Security Tables<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<h4 style="text-align: left;">
<b>PSQuery Performance issues with </b>Query Security Tables</h4>
<b><br /></b>
We see PSQuery having bad performance due to many Query Security Join tables that the PSQuery tool adds to the PSQuery SQL for security.<br />
<br />
<br />
We have few options to work around to easily improve the performance without much involving tunning from the DBA perspective which can time consuming.<br />
<br />
<i> <b>If security is not required for this query </b></i><br />
<br />
Change the Query type to 'Process'. Process queries override the automatic row-level query security logic that is applied to all other types of queries.<br />
<br />
It will be useful for the PSQuery in Pagelet specific to the logged-in users where security is not important.<br />
<br />
If you are using Campus Solution and you don't know Campus solution specific query tables, you don't need Security to join tables.<br />
<br />
<i><b> If Security is required</b></i><br />
<i><b><br /></b></i>
Select the Security optimization checkbox, it will eliminate duplicate security.<br />
if still, more than one Security join tables are added and need improvement in performance, <br />
one security join should be fine usually and for other records view of the table without security join table.<br />
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-54848605140432640992019-10-01T20:42:00.002-04:002019-10-17T19:02:30.850-04:00Identify navigation in PeopleSoft by a Process name or a Job name<div dir="ltr" style="text-align: left;" trbidi="on">
<h4 style="text-align: left;">
<b><u>Identify navigation in PeopleSoft by a Process name and/or Job name</u></b></h4>
<br />
There are many SQL statements in different blogs to identify the navigation for a process.<br />
But I have modified that to get the Navigation for a Job.<br />
<b>Single SQL works for both Process and Job.</b><br />
<br />
<br />
SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label), '>-')) ,' >- ') PATH<br />
FROM PSPRSMDEFN<br />
WHERE portal_name = 'EMPLOYEE'<br />
AND portal_prntobjname = 'PORTAL_ROOT_OBJECT'<br />
START WITH portal_uri_seg2 IN (<br />
SELECT DISTINCT pnlgrpname<br />
FROM ps_prcsdefnpnl<br />
WHERE prcsname = UPPER(<b>:1</b>)<br />
UNION<br />
Select Distinct PNLGRPNAME<br />
FROM PS_PRCSJOBPNL<br />
Where PRCSJOBNAME = UPPER(<b>:1</b>) )<br />
CONNECT BY PRIOR portal_prntobjname = portal_objname;<br />
<br />
<br />
Hope this will be useful.</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-25715564752627790682019-10-01T20:27:00.002-04:002019-10-03T22:30:48.364-04:00SQL to Identify detailed Security access for a Page or Component.<div dir="ltr" style="text-align: left;" trbidi="on">
<h4 style="text-align: left;">
<i><u>SQL to Identify detailed Security access for a Page or Component.</u></i></h4>
<br />
When you want details about a single page in the component.<br />
<br />
select a.menuname,a.barname,a.baritemname,rc.rolename, rd.descr , a.classid, c.classdefndesc,a.Displayonly,ac.pageaccessdescr<br />
from psauthitem a, psclassdefn c, psroleclass rc, psroledefn rd, PSPGEACCESSDESC ac<br />
where a.pnlitemname = :1<br />
and a.classid = c.classid<br />
and a.classid = rc.classid<br />
and rc.rolename = rd.rolename<br />
and a.Authorizedactions = ac.Authorizedactions<br />
Order by rc.rolename;<br />
<br />
<br />
When you want details about a component.<br />
<br />
select a.menuname,a.barname,a.baritemname,rc.rolename, rd.descr , a.classid, c.classdefndesc,a.Displayonly,ac.pageaccessdescr<br />
from psauthitem a, psclassdefn c, psroleclass rc, psroledefn rd, PSPGEACCESSDESC ac<br />
where a.BARITEMNAME = :1<br />
and a.classid = c.classid<br />
and a.classid = rc.classid<br />
and rc.rolename = rd.rolename<br />
and a.Authorizedactions = ac.Authorizedactions<br />
Order by rc.rolename;</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-55770423018777519562015-09-15T09:00:00.002-04:002015-09-15T09:03:01.105-04:00Sending EMAILS in PeopleSoft - Deep Dive !! - Different Options and Other details<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="field-item even" property="content:encoded" sizcache="20" sizset="35">
Sending an email is very simple and easy concept, but there are so many
different things that we need to keep in mind from best practices to new
additional methods that can be useful in different purpose. I am trying to cover
all the different aspects of sending emails, this will be <strong>Bible
</strong>for sending emails in the PeopleSoft.<br />
<strong><br /></strong>
<strong>Best Practice</strong><br />
1) Anything that works is not correct or best method to follow while writing the
PeopleCode. First thing comes to the mind - <strong>SendMail </strong>function
to send the email, it is an <strong>deprecated </strong>method and should not be
used. Application Class <strong>MCFOutboundEmail </strong>needs to be used
and it is the fully SMTP Protocol compliant to RFC 821/822. It uses Javamail
functionality using this package.<br />
<strong><br /></strong>
<strong>Where to Configure</strong><br />
MCFOutBoundEmail() function uses the SMTP section of the Application Server's
psappsrv.cfg file, and Process Scheduler's SMTP section of the psprcs.cfg file,
just as the SendMail() function does. No special configuration is required for
the MCFOutboundEmail() function to work.<br />
<br />
<strong>Sample Code send Email</strong><br />
import PT_MCF_MAIL:*;<br />
import PT_MCF_MAIL:MCFOutboundEmail;<br />
import
PT_MCF_MAIL:MCFEmail;<br />
<div sizcache="20" sizset="35">
Local PT_MCF_MAIL:MCFOutboundEmail &email =
create PT_MCF_MAIL:MCFOutboundEmail();<br />
&email.Recipients = "<a href="mailto:FINQAGenUser10@ap6023fems.us.oracle.com">FINQAGenUser10@ap6023fems.us.oracle.com</a>";<br />
&email.From
= "";<br />
&email.BCC = "";<br />
&email.Subject = "MCF Outbound Email
test";<br />
&email.ReplyTo = "";<br />
&email.Text = "Email Body - This is a
Test of the MCF Outbound Email";</div>
&res = &email.Send();<br />
<strong><br /></strong>
<strong>Best Performance for sending Bulk email </strong><br />
<em> if you need to send several emails where content is specific to each
email is different. Following code will help if you need to send email
notification on the component peoplecode, as it make one SMTP connection to send
all the emails and performance will be better.</em><br />
import PT_MCF_MAIL:MCFOutboundEmail;<br />
import
PT_MCF_MAIL:MCFBodyPart;<br />
import PT_MCF_MAIL:MCFMultipart;<br />
import
PT_MCF_MAIL:MCFMailUtil;<br />
import PT_MCF_MAIL:SMTPSession;<br />
Local integer &noOfMails = 20;<br />
Local array of PT_MCF_MAIL:MCFOutboundEmail &mails;<br />
Local PT_MCF_MAIL:MCFOutboundEmail &email;<br />
Local integer &i;<br />
Local PT_MCF_MAIL:SMTPSession &commonSession = create
PT_MCF_MAIL:SMTPSession();<br />
&commonSession.Server =
"ap6023fems.us.oracle.com";<br />
&commonSession.Port = 25;<br />
&mails =
CreateArray(&email);<br />
<div sizcache="20" sizset="36">
For &i = 1 To &noOfMails<br />
&email =
&commonSession.CreateOutboundEmail();<br />
&email.From = "<a href="mailto:sender@sender.com">sender@sender.com</a>";<br />
&email.Recipients
= "<a href="mailto:receiver@receiver.com">receiver@receiver.com</a>";<br />
&email.BCC
= "<a href="mailto:sender@sender.com">sender@sender.com</a>";<br />
&email.Subject =
"Mail: " | NumberToString("2.0", &i) | " Hi there";<br />
&email.Text =
"<html><body>Mail No: " | NumberToString("2.0", &i) | "One of
multiple mails from from
java</body></html>";<br />
&email.ContentType =
"text/html";<br />
&mails &i = &email;</div>
End-For;<br />
<strong><br /></strong>
<strong>Local PT_MCF_MAIL:MCFMailUtil &util = create
PT_MCF_MAIL:MCFMailUtil();<br />Local array of integer &allRes =
&commonSession.SendAll(&mails);</strong><br />
<strong><br /></strong>
<strong>Debugging </strong><br />
In case if mails are not working for you and you are not able to figure out
the issue.<br />
You should look into smtp logs for more details and it will tell
you exactly what is happening.<br />
Before using the SMTP logs , you need to
enable it.<br />
For enabling SMTP logs for App Server you need to edit the app
server configuration file :psappsrv.cfg.<br />
Open the psappsrv.cfg file and find
“SMTP”.Look for SMTPTrace variable.<br />
It will be SMTPTrace=0 initially.<br />
<br />
Set
the value of this variable <strong>SMTPTrace</strong>=1 and save the file.<br />
This change does not require a Application Server boot and changes will be
reflected immediately.<br />
If you are using mail classes from Process Scheduler, you may need to set
their trace also.<br />
The psprcs.cfg file needs to be modified for this.<br />
Open
the file and look for SMTP and change the settings as done in the App server
configuration file.<br />
<em>It will generate Trace file SMTP.LOG in LOGS Folder
under<br />$PS_HOMEappservdomain_namelogsSMTP.LOG for Appserver and
$PS_HOMEappservprcsdomain_namelogsSMTP.LOG for Batchserver.</em><br />
<strong><br /></strong>
<strong>Creating an Email from Rich Text Editor Output</strong><br />
Using the ParseRichTextHTML - you can send the Rich Text with messages.
Follwoing link has the complete details of the sample code.<br />
<div sizcache="20" sizset="39">
<a href="http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tpcr/htm/tpcr25.htm#g4099d8f5418c1a59_ef90c_1249bedebd7__7d13">http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tpcr/htm/tpcr25.htm#g4099d8f5418c1a59_ef90c_1249bedebd7__7d13</a></div>
<strong><em><br /></em></strong>
<strong><em>Validating Email Address</em></strong><br />
<strong>ValidateAddress</strong><em>(addresslist) - </em>Use the
ValidateAddress method to validate a comma- or semicolon-separated list of email
addresses. This method checks the syntax of the email address. It does not
verify the domain name or the validity of the user name.<br />
import PT_MCF_MAIL:*;<br />
Local PT_MCF_MAIL:MCFMailUtil<br />
&emailutil = create PT_MCF_MAIL:MCFMailUtil();<br />
Local boolean &result =
&emailutil.ValidateAddress(&email.Recipients);<br />
Local array of string &bAddresses = &emailutil.badaddresses;<br />
If (&result = False) Then<br />
If (&bAddresses <> Null) Then<br />
&i
= 0;<br />
While &bAddresses.Next(&i)<br />
Warning ("Bad email address in input = " |
&bAddresses [&i]);<br />
End-While;<br />
End-If;<br />
End-If;<br />
<strong><br /></strong>
<strong>Creating an HTML Email with Images</strong><br />
Sending the HTML content and sending the Client Image may be requried. It
looks good to send them in the email, Rather than the boring static emails which
doesn't have much of details in it.<br />
Following link has the details of the code to send the same.<br />
<div sizcache="20" sizset="40">
<a href="http://docs.oracle.com/cd/E41509_01/pt852pbh2/eng/psbooks/tpcr/chapter.htm?File=tpcr/htm/tpcr25.htm%23H4247">http://docs.oracle.com/cd/E41509_01/pt852pbh2/eng/psbooks/tpcr/chapter.htm?File=tpcr/htm/tpcr25.htm%23H4247</a></div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
2) <b> Notification Framework</b> A<span style="font-family: inherit;">nother option is not explored very well by developers to send emails. It can be easy way sending the </span>email for many scenarios, where code can be simple and provide configurable options.</div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
The Notifications Framework uses the generic templates of the PeopleTools Workflow Technology, and the reader is urged to review the information in PeopleTools: Workflow Technology, “Using Notification Templates,” for a more comprehensive understanding.</div>
<div style="text-align: left;">
<br /></div>
<div sizcache="20" sizset="40">
Entity Registry to generalize all notifications into a single structure. The architecture is modeled on a pluggable channel-based approach. Each notification type is supported by a dedicated channel that supports the idiosyncrasies of the particular notification type.</div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
After creating Templates</div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
PeopleTools, then select Workflow, then selectNotifications, then selectGeneric Templates </div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
Notification Setup page (select Set Up SACR, then select System Administration, then select Utilities, then select Notifications, then select Notification Setup)</div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
Notification Consumer Setup page (select Set Up SACR, then select System Administration, then select Utilities, then select Notifications, then select Notification Consumer Setup).</div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
Write an AppClass that extends AbstractNotification class. The Consumer ID must be passed to the Super Class constructor</div>
<div sizcache="20" sizset="40">
Implement the abstract method createNtfContext().</div>
<div sizcache="20" sizset="40">
Implement the abstract method populateNtfContext(). This method populates the context create above with the necessary values </div>
<div sizcache="20" sizset="40">
Invoke the send(), remind(), or resend() methods.</div>
<div sizcache="20" sizset="40">
Override the OnSuccess() and OnError() for custom behavior</div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
Consultants can refer to the Delegated Access Application Class SCC_DA:NOTIFY as a reference for how to trigger the Notifications Framework as a consumer.</div>
<div sizcache="20" sizset="40">
<br /></div>
<div sizcache="20" sizset="40">
<br /></div>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-2688715611984654572015-08-28T15:09:00.000-04:002015-09-15T09:03:14.427-04:00How HCM and CS is different in providing Row Level Security to an User ID ? <div dir="ltr" style="text-align: left;" trbidi="on">
HCM - RowLevel security directly driven by the - "RowLevelSecurity"
Permission list.<br />
User Profile needs to have Rowlevel Security Permission
assigned to get the security.<br />
<br />
We can have Department based -
RowLevelSecurity as well as based on the custom Security Set Properties.(It can
be based on COMPANY, BUSINESS UNIT etc.).<br />
<br />
1) Security by Department 2) Security by Permission List.<br />
<br />
<br />
Rowlevel security is enforced in the components by user Security Views as Search Records, where OPRID is a non-search key field. PeopleSoft<br />
<br />
Rowlevel Security in the PSQuery is achieved by Search - Query Security Record - which is an property of the Record. Query Security Record (which a security view) is added to query automatically.<br />
<br />
Since the Campus has different security model, using HCM Personal data records in PSQuery for Campus Solutions will be a problem.<br />
<br />
Campus solution Module doesn't use the "RowLevelSecurity" Permission list in
the User Profile.<br />
<br />
Campus solution has 2 options -<br />
<br />
a) SCAR security based on the data element
linked to student is accessed. Like INSTITUTION, CAREER, PROGRAM, PLAN.<br />
Each
User ID needs to be configured in the SCAR security for each of the data
elements like CAREER, PROGRAM, PLAN etc.<br />
<br />
b) Person Mask security, even if user have access to different data elements
in the SACR for the configuration purpose, we can restrict the access to student
data by using this configuration.<br />
PERSON_SRCH - Delivered search view is used
to control the security and part of many search records of the components in
Campus solution.<br />
<br />
In this case, User "Primary Permission" list needs to be configured in the
Person Mask component and Person Mask process needs to be executed so that User
can get the access to view Student information in the campus solution.<br />
<br />
Set up SACR > Security > Secure Student Administration > Permission
List > Demographic Data Access<br />
Set up SACR > Security > Secure Student Administration > Process
> Demographic Data Access<br />
<br />
Since the HR Person records has Row level security attached for the PSQuery
and Campus doesn't use the Rowlevel security model similar to HR. We cannot use
the base Personal records in Campus to create the PSquery reports (unless
security is replicated).<br />
<br />
Core Person Model -- Record PS Query View for CS<br />
ACCOMPLISHMENTS --
SCC_ACCOMP_QVW<br />
ACCOM_DIAGNOSIS -- SCC_ACCOM_D_QVW<br />
ACCOM_JOB_TASK --
SCC_ACCOM_T_QVW<br />
ACCOM_OPTION -- SCC_ACCOM_O_QVW<br />
ACCOM_REQUEST --
SCC_ACCOM_R_QVW<br />
ADDRESSES -- ADDRESS_NPC_VW<br />
AUDIOMETRIC_TST --
SCC_AUDIO_T_QVW<br />
CITIZENSHIP -- SCC_CITIZEN_QVW<br />
CITIZEN_PSSPRT --
SCC_CITZN_P_QVW<br />
DISABILITY -- SCC_DISABLE_QVW<br />
DIVERSITY --
SCC_DIVERS_QVW<br />
DIVERS_ETHNIC -- SCC_DIV_ETH_QVW<br />
DRIVERS_LIC --
SCC_DRIVERS_QVW<br />
EMAIL_ADDRESSES -- SCC_EMAIL_QVW<br />
EMERGENCY_CNTCT --
SCC_EMERG_C_QVW<br />
EMERGENCY_PHONE -- SCC_EMERG_P_QVW<br />
EYE_EXAM --
SCC_EYE_EXA_QVW<br />
NAMES -- SCC_NAMES_QVW<br />
PERSON --
PERSON_NPC_VW<br />
PERS_DATA_EFFDT -- SCC_PER_EFF_QVW<br />
PERS_DATA_CAN --
SCC_PDE_CAN_QVW<br />
PERS_DATA_USA -- SCC_PDE_USA_QVW<br />
PERS_NID --
SCC_PERS_NI_QVW<br />
PERSON_PHONE -- SCC_PERS_PH_QVW<br />
PHYSICAL_EXAM --
SCC_PHYS_EX_QVW<br />
PUBLICATIONS -- SCC_PUBLICA_QVW<br />
RESPIRATORY_EXM --
SCC_RESP_EX_QVW<br />
VISA_PMT_DATA -- SCC_VISA_P_QVW<br />
VISA_PMT_SUPPRT --
SCC_VISA_S_QVW <br />
<br />
<br />
Query Views to be used in place of core Person Model Tables with
PeopleSoft<br />
Query for Campus Solutions reporting needs.</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-88420337084776940772015-08-27T18:20:00.003-04:002015-09-15T10:58:40.520-04:00Write Custom Messages to PeopleSoft Trace File to Help Debugging ? <div dir="ltr" style="text-align: left;" trbidi="on">
PeopleSoft Trace provides a lot useful information to find the bugs, issues
and understand the application state. The main problem with this is it provides
a so much of information that it hardly gets used completely.<br />
<br />
PeopleSoft Trace is not very reader friendly, with a lot of information
overload. How can we debug the code provide the details of the critical variable
values. Many Application Framework come with support for the Custom Logging
capability.<br />
<br />
Application Logging is very much different for what we use "WinMessage" to
debug and get the values of the variables. The main problem with this is every
time you have to remove the code for winmessage and add the code back when you
want to debug the same PeopleCode. What if you had switch to control the
"Winmessage" like debug statements work only when it is required and not always.
?? <strong>Welcome to "Application Logging".</strong><br />
Application Logging is the answer for this and there is 2 options that we can
use withe PeopleSoft (Atleast for my knowledge).<br />
<br />
How can you achieve this in the PeopleSoft?<br />
1) PeopleSoft do have one which can use for the Application Log
facility. Application logging enables you to do error logging using an
independent application log fence mechanism. It also enables you to write to the
PeopleTools log using the WriteToLog built-in function<br />
In PeopleTools, a log fence is a type of barrier. Application error messages
are only written to the PeopleTools log if the log fence setting that the
messages are written to the log with (using WriteToLog) is less than or equal to
the current application log fence setting (AppLogFence) in the application
server configuration file (PSAPPSRV.CFG ).<br />
Following document will explain in more detail about this.<br />
<a href="http://docs.oracle.com/cd/E38689_01/pt853pbr0/eng/pt/tpcd/task_UsingApplicationLogging-0749d1.html">http://docs.oracle.com/cd/E38689_01/pt853pbr0/eng/pt/tpcd/task_UsingApplicationLogging-0749d1.html</a><br />
2) We do have custom method that we can use for the logging the application.
Custom method - well not really custom method, we basically using the JavaAPI -
Log4J - is an standard Logging method for the Java based applications. Since
PeopleSoft supports the Java we can use this mechanism to get the application
log.<br />
<em>Since it's framework and works with Java - Any version of the PeopleSoft
can adapt to this method.</em><br />
<em>You can configure the log level, targets, and layouts from a
configuration file without touching your production code. You can change the Log
Level using the Peoplecode Dynamically.</em><br />
<br />
You can get more information about this in the below link, where Jim has explained about the Log4J method.<br />
<br />
<a href="http://jjmpsj.blogspot.in/2006/09/logging-peoplecode_15.html">http://jjmpsj.blogspot.in/2006/09/logging-peoplecode_15.html</a></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-8763416905070099522015-08-27T18:18:00.004-04:002015-08-27T18:18:57.784-04:00Automated Configuration Management - Automate Configuration<div dir="ltr" style="text-align: left;" trbidi="on">
In PeopleSoft ERP Projects, PeopleSoft Admins have to create several
instances, refresh production to Development and Test Instances. These are not
just database copy there are so many tasks that needs to be completed after the
PeopleSoft database is copied. Starting from Integration Broker configuration,
PTF configuration, SES configuration and several other tasks that needs to be
executed.<br />
<br />
In 8.53 new feature Automated Configuration management was released in trail
basis, in 8.54 this feature is full implemented and provided to be use
easily.<br />
What it does basically is to create to automate the configuration of the
PeopleSoft environments with single click of a button. We need to save the
configuration information in a Template, which saved as Template file. Template
just is a collections of the Plug-ins which configure the PeopleSoft
Environment.<br />
<br />
Plug-ins take input parameter values and on execute take care of the
configuration and manual configuration is not required. For example, the value
for your Integration Gateway URL, which you would normally add manually on the
Gateways page, can be entered in your template or template file once, and then
retrieved by the automated configuration management framework and inserted into
the database each time you refresh that environment.<br />
<br />
You can create the Template for all the related configuration Plug-ins and
execute them as required. It can be executed in the PIA - Application Engine or
it can be executed from the command line.<br />
Now, you may be wondering what is an Plug-ins, these are just Application
Class. For example, to configure IB Gateway nodes, the application
class(plug-in) PTIBConfigureGatewayNodes in the application package PTEM_CONFIG
is used.<br />
<br />
There are <strong>18 devlivered plug-ins </strong>that are available, these
configurations are mainly available for<br />
1) Integration Broker<br />
2) Search Framework Configuration<br />
3) PTF Configuration<br />
4) Process Scheduler<br />
5) Performance Monitor configuration.<br />
<br />
After setting up the basic infrastructure of a PeopleSoft environment,
including database, application server, Process Scheduler server, and PIA
domain, you run the configuration program (either using PIA or command line).
This configuration program reads your environment properties from the template
or template file, and inserts the stored values into the database, saving you
from updating the settings manually each and every time you create or refresh an
environment.<br />
<strong>Sensitive data</strong>, like passwords, can be encrypted so that
these parameters are not exposed if sharing the property file among multiple
environments and multiple development or testing teams. With simple option of
the encrypt_password = "true" and decrypt_password = 'true'.<br />
<br />
There is an option to <strong>Verify </strong>the configuration using this
framework - Automated Environment Configuration framework verifies the settings.
The parameters provided in the property file are validated against the
corresponding values inserted into the database to ensure they are
identical.<br />
You can monitor the execution of the Template, View the results in the PIA
page, You can review results after execution with icon displaying against each
plugin like Success, Error, Manual Verification.<br />
<br />
You can check for the dependency between the Plug-ins.<br />
You assign a value to a template variable which is in-turn used to assign
values for properties in cases where values are recurring in multiple places in
a template or template file.<br />
<br />
<strong> Extending Plugins and Creating Plugins</strong> - Plugins are
Applications Classes and hence it is easy to Extend the features and create new
plugins based on the project requirement.<br />
After you create a template, you must add the template to a permission list.
PeopleTools provides the PTPT4800 specifically for the purpose of automated
configuration.<br />
Use the ACM Templates page to add a template to the PTPT4800 permission
list.If a template is not added to the PTPT4800 permission list, you cannot use
the template for a configuration run.<br />
Use the PTEM_CONFIG application package to create a plug-in. If you need to
use a custom package, ensure that the custom package starts with PTEM_CONFIG.
Write the plug-in class. The new plug-in class must extend from the base class —
PTEM_CONFIG:EMConfigurationPlugin.<br />
Override and implement the four base class methods<br />
1) getProperties<br />
2) dependant_plugins<br />
3) getPluginHelpMessage<br />
4)
isInternalPlugin<br />
<br />
Register the Custom Plugin in the following location.<br />
<br />
PeopleTools, then selectAutomated Config Manager, then selectACM
Utilities, then select Register Plugin</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-34103555895375708212015-08-27T18:13:00.002-04:002015-08-27T18:13:32.691-04:00Methods to Reduce Customization/Modification in PeopleSoft<div dir="ltr" style="text-align: left;" trbidi="on">
PeopleSoft ERP delivered Business Process might not be application for all
customers. Customer prefer to change the PeopleSoft rather than change their
business process to suite their requirements.<br />
Customizing PeopleSoft all time is not good idea, can we avoid it ? No, we
cannot avoid customization to PeopleSoft Application as it might not suite
customer requirements.<br />
Lets see what are the options provided by PeopleSoft to avoid Customization
to delivered objects so that it will be easy to handle during the customization
and retro-fit efforts are reduced.<br />
1) Most common customization is to add additional fields on the delivered
components to C<b>apture additional information.</b><br />
a) <strong>Related Content Framework </strong>- it can be used to display
additional custom page in the delivered component where additional parameters can
be captured. It is very powerful solution where you can display the page from
PeopleSoft, Query Results, External Application, Web applications.<br />
<strong>Related Action Framework</strong> - Will help to related
different related transaction.<br />
b) <strong>Common Attribute Framework </strong>- It is an feature in the
Campus Solution - where many of the delivered component related to
Student/Prospect Personal information loaded from PDL process and processed from
admission application. Using the simple configuration we can store additional
values in different format like Scroll and Attributes. This can be applicable
for other pages with minimal configuration. This feature should be available for
HCM and FSCM as well.<br />
2) <strong>Creating New Custom Approval Workflow Process.</strong><br />
Workflow in an Important feature required of the Business Process, most of
the configuration for AWE can be done online, but what if the customer need New
Approval Process ?<br />
<strong>PeopleSoft Forms and Approval Builder </strong>enables business
analysts to create electronic, routable forms without having to use PeopleSoft
Application Designer. A typical form can be designed and in use within 30
minutes and requires no writing of code. The intuitive wizard guides you step by
step through establishing a form. Options include adding instructions to the
form, similar to what you would find on the back of a paper form; adding
attachments to the form for users to read, submit, or both; and being able to
create your own fields on the form. On Final Approval - Component Update from CI
is possible using the configuration.<br />
This is available from PeopleSoft 9.1 on-wards and hence available for
Peopleoft HCM, FSCM, CRM only and yet to available for PeopleSoft Campus
Solution.<br />
3) Creating an Webservice/Interface for the External System to get the
real-time data from PeopleSoft.<br />
a) <strong>CI Based </strong><b>Web service</b> - Which doesn't need any code
development where component can be operated easily and no coding and
customization is required.<br />
b) If the data is required to be fetched from other than the component -
CI will not be applicable.<br />
<strong>QAS - Query as </strong><b>Web service</b> - Creating Simple Query can pull
the data from multiple records and apply data security and other business logic.
It is easy to create this webservice and third party system can make use of it.
It can be simple interface for the Down stream system.<br />
4) Reading Inbound interface file or loading the data from file - It is one
of the common requirement.<br />
<strong>File Parser </strong> - is a Campus Solution feature it not
available for HCM, FSCM and CRM Application. it is very useful to load any data
from File, without any coding required.<br />
5) <b>Sending Emails/Work list/Notifications</b> for different users on Events in the
PeopleSoft Application -<br />
Following method doesn't avoid customization but reduce the amount
customization and retro-fit effort. It will be standard method to send Worklist,
Emails - Which can be easily tracked. It should be used as standard method and
Best practice as it has a lot features that can used with less
customization.<br />
<strong>Events and Notifications Framework </strong><br />
The PeopleSoft Events and Notifications framework provides three features
that can be configured and used to monitor business processes and create
messages when unusual situations or errors occur within a PeopleSoft process or
table. These messages can be routed to different users (PeopleSoft or
non-PeopleSoft) to prompt the user to resolve the issue. Links can take the user
directly to the page for correction or resolution.<br />
The three features are: • Events • Notifications • Alerts<br />
<br />
Following is the simple code Raise the event, Event handler can handle the
rest.<br />
import EOEN_MVC:EOEN_MODEL:EOENInterface;<br />
Local EOEN_MVC:EOEN_MODEL:EOENInterface &myEvent;<br />
Local Record &recContext;<br />
&myEvent = create EOEN_MVC:EOEN_MODEL:EOENInterface("", 0);<br />
&recContext = &rsContextRec(1).GetRecord(Record.CONTEXT_REC);<br />
<br />
&myEvent.AddContextRecord(&recContext);
&myEvent.RaiseEvent("EventName");</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-627781583806667692013-05-28T07:20:00.002-04:002013-05-28T07:20:34.284-04:00Oracle Learning Library<div dir="ltr" style="text-align: left;" trbidi="on">
Oracle Learning Library<br />
__________________<br />
<br />
This has a lot of trainings related to the new features released in 8.53 and 8.52 version.<br />
<br />
<br />
<a href="http://apex.oracle.com/pls/apex/f?p=44785:2:0:::2:P2_GROUP_ID:1022">http://apex.oracle.com/pls/apex/f?p=44785:2:0:::2:P2_GROUP_ID:1022</a><br />
<br />
<br />
<br />
<br />
<br /></div>
Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7591641845060677730.post-15154710660497401402012-09-18T07:16:00.000-04:002012-10-03T07:40:59.187-04:00Script to update the Tablespace for all the records in the Project.<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
Script to update the Tablespace for all the records in the Project. when we import Project in the client instance, we can use this SQL to change the tablespace for all the records at time, rather changing it one by one.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Update PSRECTBLSPC</div>
<div class="MsoNormal">
SET DDLSPACENAME = {NEW TABLESPACE}<new_name></new_name></div>
<div class="MsoNormal">
WHERE DDLSPACENAME = {OLD TABLESPACE};<span style="color: red;"><old_name></old_name></span></div>
<div class="MsoNormal">
and RECNAME IN (Select A.OBJECTVALUE1 from PSPROJECTITEM A, PSRECDEFN B </div>
<div class="MsoNormal">
Where A.PROJECTNAME = {PROJECTNAME} and A.OBJECTTYPE = 0 and A.OBJECTID1 = 1 and A.OBJECTVALUE1 = B.RECNAME and B.RECTYPE =0)</div>
<div class="MsoNormal">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-410819687558087822012-09-12T03:51:00.001-04:002012-09-12T03:58:32.678-04:00Test third Party webservices integration with PeopleSoft<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div align="center" class="MsoNormal" style="text-align: center;">
Test third Party
intergration w/ sample Peoplecode</div>
<div align="center" class="MsoNormal" style="text-align: center;">
<br />
<div style="text-align: left;">
Consume third Party web services.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<a href="https://docs.google.com/open?id=0B32w8c73CcOEVDBLakNlLUx0aWs">https://docs.google.com/open?id=0B32w8c73CcOEVDBLakNlLUx0aWs</a></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Download the document for all the steps.</div>
</div>
</div>
</div>
Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7591641845060677730.post-56291173238424174992012-09-11T04:37:00.002-04:002012-09-12T03:53:24.690-04:00Creating PeopleSoft Mockup Pages Made Easy<div dir="ltr" style="text-align: left;" trbidi="on">
Creating a PeopleSoft Mockup page while creating the Functional Design document and Requirement collection process is very important in the PeopleSoft Consulting Projects.<br />
<br />
Usually Paint and screen captures are used to create the mock-ups.<br />
<br />
Here find the the link to excel document, which has the collection of all the possible images/icons that you need to create easy mock-up pages quickly.<br />
<br />
<a href="https://docs.google.com/open?id=0B32w8c73CcOEYU8zWDdMLW1KaDg" target="_blank">PeopleSoft Mockup Template</a><br />
<br />
Download the file to view it in the Microsoft Excel.</div>
Unknownnoreply@blogger.com7tag:blogger.com,1999:blog-7591641845060677730.post-74009790669568419652012-08-26T02:26:00.002-04:002012-08-26T02:27:51.482-04:00TraceMagic: Utility for analyzing *.tracesql trace files <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; font-size: x-small;"><span style="font-family: Times, Times New Roman, serif;"><br /></span></span>
<span style="font-family: inherit;"><span style="background-color: white;">TraceMagic is a utility that gives PeopleSoft system administrators, programmers and support engineers the ability to quickly isolate performance </span><span style="background-color: white;">bottlenecks in SQL Statements and/or PeopleCode functions. It accomplishes this by turning the text-based, time-ordered tracesql file into a </span><span style="background-color: white;">sortable-grid display, allowing the user to quickly locate system performance issues.</span>
</span><br />
<span style="background-color: white; font-size: x-small;"><span style="font-family: inherit;"><br /></span></span>
<br />
<div style="text-align: left;">
<span style="font-family: inherit;">TraceMagic is designed primarily to address the difficulty in working with tracesql files when attempting to<br />determine which SQL statement(s), and or PeopleCode programs are causing performance problems. As such, it tends to assume that certain trace flags were set during the creation of the trace file.</span></div>
<br />
<br />
<h3 class="km" style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; padding-top: 0.5em;">
Requirements</h3>
<div style="background-color: white;">
<span style="font-family: inherit;">Trace Magic requires Version 4 of the Microsoft dot.net Framework. The setup.exe program used to install TraceMagic on an end users machine will<br /> inspect the target system for the presence of the prerequisite software, and request permission from the installer to download and install the<br /> required software if needed. TraceMagic has been tested on the following platforms:</span></div>
<ul style="background-color: white;">
<li><span style="font-family: inherit;"> Windows XP (32-bit)</span></li>
<li><span style="font-family: inherit;"> Windows 7 (32-bit)</span></li>
<li><span style="font-family: inherit;"> Windows 7 (64-bit)</span></li>
</ul>
<div style="background-color: white;">
<span style="font-family: inherit;"><br />Other platforms may or may not function correctly with TraceMagic. Platforms that will not run the Microsoft dot.net framework will not<br />likely run TraceMagic.</span></div>
<br />
<span style="background-color: white;"><span style="font-family: inherit;"><br /></span></span>
<span style="background-color: white;"><span style="font-family: inherit;">Download link - Login Required.</span></span><br />
<span style="background-color: white;"><span style="font-family: inherit;"><a href="https://support.oracle.com/epmos/downloadattachmentprocessor?attachid=1470578.1%3ATM_VERSION1.2&docType=DIAGNOSTIC%20TOOLS&action=download">https://support.oracle.com/epmos/downloadattachmentprocessor?attachid=1470578.1%3ATM_VERSION1.2&docType=DIAGNOSTIC%20TOOLS&action=download</a></span></span></div>
Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7591641845060677730.post-15726464679368430742012-08-23T06:27:00.000-04:002012-09-12T04:02:00.218-04:00PeopleTools 8.52 popup prompts <div dir="ltr" style="text-align: left;" trbidi="on">
A new feature in PeopleTools 8.52 are popup modal prompts. These are automatically enabled wherever the PeopleCode PROMPT function is used. You most often see this in Query Manager prompts.<br />
<br />
<br />
Prompt("Enter EMAIL ID" &TLMlbx1Str, "",TL_MAILBOX_WRK1.EMAIL, "Enter Enter Emailid ",&TLEMAILID);<br />
<br />
This prompt similar to PS Query for the Bind parameter but, here it can be used on the regular PeopleSoft Components.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtF198qWyP34Kqk79aGWk53qxMs3NmBZoSbDfJBl1M_PMsJIukfGirXotbKfSgoMvgF2IeTEoJ5Kuv5dwIQPTSOgFMoDgqWCJv4hq4CrtFRtHXJVxl7MJa0_1LBu2B-DosXrO2sctjpzM/s1600/SNAG-0795.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtF198qWyP34Kqk79aGWk53qxMs3NmBZoSbDfJBl1M_PMsJIukfGirXotbKfSgoMvgF2IeTEoJ5Kuv5dwIQPTSOgFMoDgqWCJv4hq4CrtFRtHXJVxl7MJa0_1LBu2B-DosXrO2sctjpzM/s1600/SNAG-0795.jpg" /></a></div>
<br /></div>
Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7591641845060677730.post-59440706970613281272012-08-23T06:20:00.000-04:002012-08-26T02:28:01.220-04:00Paperless Office with PeopleSoft Forms & Approval Builder <div dir="ltr" style="text-align: left;" trbidi="on">
<br />
PeopleSoft applications are helping to make paper and email-based forms a thing of the past so that you will know what was submitted, when it was submitted, and who approved it. We recently released Forms and Approval Builder as a part of Common Components 9.1. Forms and Approval Builder allows you to build electronic forms that are configurable by business analysts, enabled with approval workflows, and immediately deployable and auditable to enable you to replace paper and email-based forms. Forms and Approval Builder is currently available, at no additional charge, to all PeopleSoft 9.1 customers. It was part of the FSCM Feature Pack March 2011, and it is also available in the Enterprise Components 9.1 Common Objects Bundle 1 2011 for use in any PeopleSoft 9.1 Pillar, including, of course, HCM. It does require PeopleTools 8.51.03 or greater.<br />
<br />
<br />
<h3 style="text-align: left;">
Form Design</h3>
<br />
PeopleSoft Forms and Approval Builder enables business analysts to create electronic, routable forms without having to use PeopleSoft Application Designer. A typical form can be designed and in use within 30 minutes and requires no writing of code.<br />
<br />
<br />
The intuitive wizard guides you step by step through establishing a form. Options include adding instructions to the form, similar to what you would find on the back of a paper form; adding attachments to the form for users to read, submit, or both; and being able to create your own fields on the form. These fields can be plain text, numbers, date and time, yes/no, fields that prompt against existing PeopleSoft records, and code fields. The code field type enables you to build a list of items on the fly that a person who is filling in the form can select from when perusing the drop-down list. You can create these user prompt values in the code fields without having to enter them in a standard PeopleSoft record beforehand.<br />
<br />
Main Menu > Forms > Design a Form<br />
<br />Fields can be organized into one or two columns on the page, and every field on the form has the option of being made required to ensure that users thoroughly complete the form.<br />
<br />
<br />
You specify the location of the form in the PeopleSoft Main Menu through an easy-to-navigate folder hierarchy, and you select the flow of approvers that the form will follow using the approvers from within the Approval Workflow Engine. <br />
<br />
There is also the ability to make forms available for limited periods of time. <br />
<br />
<h3 style="text-align: left;">
Efficient and Effective Forms Management for your Organization </h3>
Knowing how many of each type of form are in the system and their approval status is essential in monitoring your business processes. PeopleSoft Forms and Approval Builder comes with its own summarization table, enabling you to see at a glance how many forms of each type have been created and how many forms are in each approval status. This central Form Management repository also enables you to activate and deactivate your forms within the system in one place, eliminating the need to go back into the design of each form and activate it. <br />
<br />
The ability to find a particular form in an instant is also important in supporting efficient operations. Forms are searchable by subject, form type, priority, due date, and approval status to eliminate the need for searching through piles of paperwork.<br />
<br />
<br />
Easy to Navigate Forms Available to Your Users When they Need Them<br />
<br />
Any given form may be accessed through either the central forms repository or the link you designate for it in within the PeopleSoft Menu navigation. Users open a blank form; enter the required information; download, read, fill in, and upload attachments; and submit their form for approval. <br />
<br />
Forms are available to the approver instantly, and approvals are also available as soon as they are granted.<br />
<br />
Finally, because the Forms and Approval Builder utilizes the existing infrastructure of the Approval Workflow Engine and the Supplemental Data Framework, your forms and approvals are migrated like all other application data during an upgrade between PeopleSoft Releases.<br />
<br />
</div>
Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-7591641845060677730.post-32101830972486260782012-01-25T00:58:00.001-05:002012-08-26T02:28:01.214-04:00Delivered EIPs in PeopleSoft across different modules<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<h1 class="TITLES" style="font-family: arial, helvetica, sans-serif; font-size: 18px; margin-bottom: 1px; margin-left: 0px; margin-right: 0px; margin-top: 3px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: -webkit-auto; text-decoration: none;">
Oracle's PeopleSoft Enterprise Integration Point (EIP) Diagrams</h1>
<div>
<br /></div>
<div>
Following link provides the details of the EIP for different modules in PeopleSoft. It will be handy while integrating modules in PeopleSoft.</div>
<br />
<br />
<a href="http://docs.oracle.com/cd/E18171_01/EIPAPP91/index.html">http://docs.oracle.com/cd/E18171_01/EIPAPP91/index.html</a></div>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7591641845060677730.post-72338325459975929072012-01-21T08:30:00.000-05:002012-08-26T02:28:01.227-04:00PeopleTools Meta Data Tables<div dir="ltr" style="text-align: left;" trbidi="on">
We often search for the PeopleSoft Tools Meta Data tables for various reasons.<br />
There are a lot of blog and websites providing these details on the Internet. In this blog I will only post just consolidate list of them.<br />
<br />
<a href="http://www.go-faster.co.uk/peopletools/">http://www.go-faster.co.uk/peopletools/</a><br />
<br />
<a href="http://www.go-faster.co.uk/peopletools/psversion.htm">http://www.go-faster.co.uk/peopletools/psversion.htm</a><br />
<br />
<a href="http://www.pscustomizer.com/peoplesoft-examples/peopletools-metadata/">http://www.pscustomizer.com/peoplesoft-examples/peopletools-metadata/</a><br />
<br />
<a href="http://www.erpassociates.com/peoplesoft-corner-weblog/peopletools/mapping-peopletools-tables.html">http://www.erpassociates.com/peoplesoft-corner-weblog/peopletools/mapping-peopletools-tables.html</a><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-33748316310127193012012-01-05T15:01:00.000-05:002012-08-26T02:28:01.216-04:00PeopleTools 8.52 - Restful Webservices<div dir="ltr" style="text-align: left;" trbidi="on">
Hi PeopleTools 8.52 - Support the Restful web services. I was just wondering what is this Restful which generates WADL vs WSDL.<br />
<br />
I found some of the interesting post/documents that expain SOAP/WSDL and Restful/WADL.<br />
<br />
Document provides the detail differences between the WSDL and WADL.how they are different from the WSDL 2.0.<br />
<br />
http://public.dhe.ibm.com/software/dw/specs/ws-wadlwsdl/WADLWSDLpaper20080621.pdf<br />
<br />
http://www.ajaxonomy.com/2008/xml/web-services-part-1-soap-vs-rest<br />
<br />
<br />
WADL and WSDL 2.0 HTTP binding are similar but do have some differences. Each<br />
specification has both its pros and cons. In short, WADL is simple and has limited scope. By<br />
design, WADL is limited to describing HTTP applications and does not address features such<br />
as security. On the other hand, the WSDL 2.0 HTTP binding is more feature rich, at the cost<br />
of increased complexity, yet still lacks a true resource-centric model.<br />
It will be interesting to watch as each of these technologies matures and gains broader<br />
adoption.<br />
</div>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7591641845060677730.post-52658255242098771182011-10-07T10:31:00.001-04:002011-10-07T10:31:46.567-04:00Creating Secured Webservice<div dir="ltr" style="text-align: left;" trbidi="on">Webserivces are one of the best methods to communicate 2 systems. Data is transmitted between the system over the network needs to be safe. Webservices security is very important.<br />
<br />
Here are some of the links that will be useful for implementing the webservice security. Later I will post the detailed steps for the implementing the webservice security.<br />
<br />
<strong>Oracle Support documents</strong><br />
<br />
E-IB: How to Implement WS Encryption for Inbound Web Services Security (Doc ID 661275.1)<br />
E-IB: How to Setup Inbound WS-Security Processing Using SAML Token in Integration Broker (Doc ID 1322740.1) <br />
E-PORTAL: WSRP Red Paper For PeopleTools 8.49-8.50 (Doc ID 1073454.1)<br />
E-SEC: Does Peoplesoft Support the Securty Assertion Markup Lanuage (SAML) Directly? (Doc ID 623055.1)<br />
<br />
<strong>PeopleBook Links</strong><br />
<br />
Home > PeopleBooks > Enterprise PeopleTools 8.50 PeopleBook: Integration Broker Administration > Setting Up Secure Integration Environments > Understanding WS-Security Processing using SAML Tokens<br />
<br />
<br />
Home > PeopleBooks > Enterprise PeopleTools 8.50 PeopleBook: PeopleTools Portal Technology > Configuring WS-Security For WSRP Consumption and Production > Determining Security Requirements <br />
<br />
Home > PeopleBooks > Enterprise PeopleTools 8.50 PeopleBook: Integration Broker Administration > Setting Up Secure Integration Environments > Understanding WS-Security Processing using SAML Tokens<br />
<br />
Home > PeopleBooks > Enterprise PeopleTools 8.50 PeopleBook: Integration Broker Administration > Setting Up Secure Integration Environments> Understanding WS-Security Processing using Username Tokens<br />
<br />
Prerequisites for Implementing WS-Security in PeopleSoft Integration Broker Implementing WS-Security for Inbound Integrations (Username Tokens)<br />
<br />
</div>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7591641845060677730.post-90380593656513593772011-10-07T10:09:00.001-04:002011-12-10T11:30:20.492-05:00Implementing CAPTCHA using ReCaptcha in PeopleSoft<div dir="ltr" style="text-align: left;" trbidi="on">Backgroud :<br />
Find out about ReCAPTCHA here :- <a href="http://en.wikipedia.org/wiki/ReCAPTCHA">http://en.wikipedia.org/wiki/ReCAPTCHA</a><br />
CAPTCHA :- <a href="http://en.wikipedia.org/wiki/CAPTCHA">http://en.wikipedia.org/wiki/CAPTCHA</a><br />
<br />
<br />
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDbvf8ISul2_X7dKwN4L3HxuBu3t0-n_QCCcfaQl5PUA2mgyi9Z3VEATrjbxkcFP7cIJMdBQEQg-D3HT9f4GCzzY7AQPmlpZIPjEXRNTNk8qifoTOyWJ_UDXwTiEPXm-QxfEYwI_0kvGA/s1600/smallCaptchaSpaceWithRoughAlpha.png" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" mda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDbvf8ISul2_X7dKwN4L3HxuBu3t0-n_QCCcfaQl5PUA2mgyi9Z3VEATrjbxkcFP7cIJMdBQEQg-D3HT9f4GCzzY7AQPmlpZIPjEXRNTNk8qifoTOyWJ_UDXwTiEPXm-QxfEYwI_0kvGA/s1600/smallCaptchaSpaceWithRoughAlpha.png" /></a></div><br />
You can use this for the forgot password component , carrer login page (applicant login) or any other similar pages strighat way.<br />
<br />
Following are modified steps from the reCAPTCHA website for the PeopleSoft Implementation.<br />
<br />
First, go to <a href="http://recaptcha.net/" target="_blank">the reCAPTCHA web site</a> and create an account. As part of that account creation process you'll have to specify the domain your reCAPTCHA will be protecting. The reCAPTCHA site will will give you a key pair for that domain. The key pair allows you to authenticate your reCAPTCHA requests to the reCAPTCHA servers<br />
<br />
Second, Create the HTML Area in the PeopleSoft page where you want the ReCaptcha to apper<br />
in the HTML Defination add the follwing Java script code, you need to enclose it with form tags.<br />
make sure you replace <your_public_key> - with the public key from the key pair created in reCaptcha website.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFtlCp-7giN2QEP1VW-VIYVjtvomFLmxdkm0KZWzr-wNgyfD1G6nDea-WRMHRvBvZpmcvy6ObBhzcByHatKefVAm38p1IRUQdj_On8XnuN_Wy4W5jkKmBivD5lS55EiAhi3EvlyNBxp6Q/s1600/ReCaptcha+Code.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="168px" kca="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFtlCp-7giN2QEP1VW-VIYVjtvomFLmxdkm0KZWzr-wNgyfD1G6nDea-WRMHRvBvZpmcvy6ObBhzcByHatKefVAm38p1IRUQdj_On8XnuN_Wy4W5jkKmBivD5lS55EiAhi3EvlyNBxp6Q/s640/ReCaptcha+Code.bmp" width="640px" /></a><br />
Download the Java API library in the following location <br />
<br />
<a href="http://code.google.com/p/recaptcha/downloads/list?q=label:java-Latest">http://code.google.com/p/recaptcha/downloads/list?q=label:java-Latest</a> - Place the jar file in the class path/folder for the java in the appserver.<br />
<br />
Add button on the page, similar to submit button for the page, on field change of the button you can write the code as below.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzebtv7sZIBhJrgoMEzrcIbQrlbJsiTNdXe-sQDCaxgLrvyu5cwomhvbjnbuopd11Sp7DLKLyQbmhzfPsuxzZpi8wAiFJLJe0gVZE42sxuahhyphenhypheniWbQ8c7IbBSsOfx5zVev7JQ4MU5iKOw/s1600/ReCaptcha+Code+-+2.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="278px" kca="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzebtv7sZIBhJrgoMEzrcIbQrlbJsiTNdXe-sQDCaxgLrvyu5cwomhvbjnbuopd11Sp7DLKLyQbmhzfPsuxzZpi8wAiFJLJe0gVZE42sxuahhyphenhypheniWbQ8c7IbBSsOfx5zVev7JQ4MU5iKOw/s640/ReCaptcha+Code+-+2.bmp" width="640px" /></a><br />
PS: Make sure you replace the private in code with the private key generated by reCaptcha for your domain.<br />
Hope this will be helpfull.</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-22506475665341405892011-07-27T10:35:00.002-04:002011-09-20T00:08:42.528-04:00Verity Search Engine in PeopleSoft HR applications.<div dir="ltr" style="text-align: left;" trbidi="on"><h3 class="post-title entry-title"><span style="font-size: small;"><span style="font-weight: normal;">VERITY Search Engine, PORTAL_INDEX process, Building a Search Index and Searching the Portal</span> - <span style="font-weight: normal;">very good post from Shyam Sundar. </span></span></h3><br />
<a href="http://peoplesoftwiki.blogspot.com/2010/01/verity-search-engine-portalindex.html">http://peoplesoftwiki.blogspot.com/2010/01/verity-search-engine-portalindex.html</a><br />
<br />
<h3 class="post-title entry-title" style="font-weight: normal;"><span style="font-size: small;">All about PeopleSoft Portal Registry- Shyam Sundar</span></h3><h3 class="post-title entry-title" style="font-weight: normal;"><span style="font-size: small;"><a href="http://peoplesoftwiki.blogspot.com/2010/02/what-is-portal-registry.html">http://peoplesoftwiki.blogspot.com/2010/02/what-is-portal-registry.html</a></span></h3><h3 class="post-title entry-title" style="font-weight: normal;"><span style="font-size: small;"> Verity is needs to installed in 8.50 and HCM 9.1 version. It no long comes as product with</span> <span style="font-size: small;">peoplesoft installation.</span> <span style="font-size: small;">following link has the details to install the verity search engine.</span></h3></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-28841812426752146682011-07-27T10:03:00.002-04:002011-09-20T00:09:16.582-04:00Difference different versions of Peoplesoft HR Application<div dir="ltr" style="text-align: left;" trbidi="on"><div closure_uid_npmwul="116">People HR application has evolved with each version and there was major change in the Personal model. Most of us know what are the major changes in personal model. Some time finding all the detail changes and to understand and back data from old versions during upgrade and re-implementation is a challenge.</div><br />
We do have details in the people books, It has not evolved as much as application find things on people books is not that friendly. I found one of link hosting the details of the changes hope this will be useful for you as well.<br />
<br />
<a href="http://www.acs.utah.edu/acs/systems/ps8/CampusSolns/CS_Docs/appdocs/ucs801_8926.htm">http://www.acs.utah.edu/acs/systems/ps8/CampusSolns/CS_Docs/appdocs/ucs801_8926.htm</a></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7591641845060677730.post-14811605091548407902011-07-19T01:07:00.000-04:002011-07-19T01:07:17.417-04:00Delivered Page to Search Component Navigation.There was several solutions to find the navigation path for component and page. There were several SQL statements for different databases. Finally Oracle as developed page this purpose.<br />
<br />
In the latest Ptools 8.50 and Application 9.1 application search is possible from two navigations.<br />
<br />
1) Main Menu > Enterprise Components > Find Object Navigation<br />
2) Setup HRMS > System Administration > Utilites > Portal Navigation Path<br />
<br />
Search is possible with name of Component,Page,Secondary Page and Content Reference.<br />
<br />
Search works fine with hidden components as well.<br />
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYWJQdljx49u-S4XAojyYw5jYgnJWSpk0yhGCGVSvSD7pYLNrbk82QgyJB25w8RJdcU-QVTTPHYcc27lSIaUKcmWv8JM47Kp3JCNeHELo8a219YutnARvW6cHUNAU0tqddB_hUV60KCZQ/s1600/ComponentNavigationSearch.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" m$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYWJQdljx49u-S4XAojyYw5jYgnJWSpk0yhGCGVSvSD7pYLNrbk82QgyJB25w8RJdcU-QVTTPHYcc27lSIaUKcmWv8JM47Kp3JCNeHELo8a219YutnARvW6cHUNAU0tqddB_hUV60KCZQ/s1600/ComponentNavigationSearch.jpg" /></a></div>Unknownnoreply@blogger.com7tag:blogger.com,1999:blog-7591641845060677730.post-55541298395595189792011-07-13T11:49:00.000-04:002011-07-13T11:49:42.324-04:00PeopleTools 8.52 - Next big tools releaseA lot of changes are expected to happen in the 8.52. RVP - Release value proposition of of 8.52 describe a lot interesting features. Very excited to work on 8.52 applications.<br />
<br />
There are already a lot of blog providing detail information about the 8.52. I have included few of those in this post.<br />
<br />
<a href="http://bloggingaboutoracleapplications.org/">http://bloggingaboutoracleapplications.org/</a><br />
<br />
<a href="http://blogs.oracle.com/peopletools/entry/new_peoplesoft_applications_search">http://blogs.oracle.com/peopletools/entry/new_peoplesoft_applications_search</a><br />
<br />
<a href="http://blogs.oracle.com/peopletools/entry/sneak_peek_of_peopletools_8">http://blogs.oracle.com/peopletools/entry/sneak_peek_of_peopletools_8</a><br />
<br />
<a href="http://blogs.oracle.com/peopletools/entry/peoplesoft_test_framework_enhancements">http://blogs.oracle.com/peopletools/entry/peoplesoft_test_framework_enhancements</a><br />
<br />
<a href="http://blogs.oracle.com/peopletools/entry/peoplesoft_s_browser_story_gets">http://blogs.oracle.com/peopletools/entry/peoplesoft_s_browser_story_gets</a>Unknownnoreply@blogger.com0