Elasticsearch for PeopleSoft Now Available! - Reference links

Elasticsearch for PeopleSoft Now Available - Tools 8.55.11

Important resource links and KM docs.

PeopleTools 8.55.11 Elasticsearch Documentation Home Page (Doc ID 2189508.1): https://support.oracle.com/epmos/faces/DocumentDisplay?id=2189508.1

PeopleSoft Key Concept page for SEARCH: http://docs.oracle.com/cd/E52319_01/infoportal/search.html

https://support.oracle.com/epmos/faces/DocumentDisplay?id=2205540.2

Current Date/timestamp with Milliseconds for Mass Assign - Service Indicators

There was a need to run Mass Assign simultaneously/concurrently for different institutions.

This code change will insert Milliseconds in Record.SRVC_IND_DATA.SRVC_IND_DTTM

&SrvIndRec.SRVC_IND_DTTM.Value = DateTimeValue(Substring(String(%Datetime), 1, Len(String(%Datetime)) - 6) | Substring(String(%PerfTime), Len(String(%PerfTime)) - 5, Len(String(%PerfTime))));
               
Within App class: SCC_SRVC_IND.Model.BatchCreateServiceIndicators.OnExecute

Testing REST web service - SCC_GET_CHECKLIST_R_GET Basic Auth and PS_TOKEN (testing as logged in user)

Testing REST web service - SCC_GET_CHECKLIST_R_GET

Basic Auth and PS_TOKEN (testing as logged in user)

Testing done with POSTMAN and soapUI

Notice that the AA0002 EMPLID is attached to the PS user for testing and has a Gen Checklist attached.

PS_TOKEN via Header

Need to invoke SCC_USERREG_AUTH_GET – Make sure routings are active.

Getting the PS_TOKEN

Update authentication with the following:

Invoke SCC_GET_CHECKLIST_R with the PS_TOKEN Cookie received. 

Alliance 2015

Looking forward to another Alliance!  Here are the details for 2015. 



Here is the session that I will be presenting this year.

Governors C => Tue, Mar 17, 2015 (09:15 AM - 10:15 AM)

Session Title:	Troubleshooting Integrations and Syncing Data from Campus to HCM, and HCM to CS
Session Number:	34181
Track:	Technical
Session Type:	Oracle
Sub-Categorization:	System Administrator
Room Assignment:	Governors C => Tue, Mar 17, 2015 (09:15 AM - 10:15 AM)
Initial Submission:	Oct 03, 2014 04:01 PM America/Arizona
Status:	Approved and Accepted
Session Submitter:	Jeromy McMahon

Short Description:

Need help troubleshooting integrations for CS-HCM? Want to see how to resolve some basic IB errors and syncing issues that may come up. Troubleshooting web services and data syncing issues.

Description:

Web services are increasingly being utilized to integrate data between and into PeopleSoft environments.   Troubleshooting web services requires a technical understanding of integration broker, as well as time and patience.  As the need for integrations continues to grow - especially with the CS-HCM split, resources and tools to help with resolving issues is expanding.  This session will cover methods for determining the source of the problem, common configuration oversights, and provide an overview for using monitors and utilities.  How can I search for errors within My Oracle Support and what are some common errors that may come up?

Learning Objectives :

Attendees will gain an insight as to 1) ways to configure various settings to provide useful logs, 2) how to view error logs and monitors (along with examples), and 3) how the Integrity Utility can help monitor data to provide assurance that data is being synchronized properly between PeopleSoft Campus Solutions and PeopleSoft HCM databases. Common errors and searching within My Oracle Support effectively.

Peoplesoft Online Help - "PeopleBooks" updated - Campus Solutions

The updated Campus Solutions 9.0 Online Help and PDFs, up to and including Bundle 34 (July 2014) are now available.

Previously the HTML was known as “PeopleBooks” – it is now “Online Help”.  The new format (same as other PeopleSoft documentation) looks and functions more like a website than the previous book format structure.

(The PDFs are still called “PeopleBooks”).

Online Help: http://docs.oracle.com/cd/E17566_01/epm91pbr0/eng/psbooks/psft_homepage.htm

PDFs: http://docs.oracle.com/cd/E56918_01/psft/html/docset.html

CS Bundle #34 is now posted

CS Bundles 34 and 41 are now posted within My Oracle Support


The relevant MOS IDs are:
(Doc ID 1905797.1) CS 9.0 Bundle #34 Functional Documentation and Additional Features July 2014
(Doc ID 1905800.1) CS Bundle #41 Functional Documentation for Financial Aid 8.9


(Doc ID 1523915.1) Most Recent Version of Campus Solutions 9.0 Chapters as of Bundle #34 

PS Utilities for Chrome Extension! - Nice without having to customize the tools code.

What a great tool for the Chrome browser.  Download this extension!  No more manual Cntl +J.

Check out "PS Utilities": 

https://chrome.google.com/webstore/detail/ps-utilities/jajoopnifcliapcngocgiidifkmboemc?utm_source=gmail

Need the ability to Sync PSPSWDHISTORY record within CS and HR?

Here are some steps you can use to accomplish this.


1. Create a new custom message for the PSPSWDHISTORY record.  (Message will be created in both environments given Subscriber Only model)

2. Create Service and Service Operation – Both Environments
Using VERSION_1 for the Default Message.

3. Create routings in both directions

4. Create handler in both environments.

5. Handler code

class genericSyncSubscription implements PS_PT:Integration:INotificationHandler
method OnNotify(&_MSG As Message);
end-class;

method OnNotify
/+ &_MSG as Message +/
/+ Extends/implements PS_PT:Integration:INotificationHandler.OnNotify +/

Local HR_INTEGRATION:HR_Subscription &Async_Subscription;
&Async_Subscription = create HR_INTEGRATION:HR_Subscription();
&Async_Subscription.SetExecuteEdits( False);
&Async_Subscription.HR_Incr_Async();
end-method;

6. Invoke using Full Data Publish

Where can I get information for PUM (Peoplesoft Update Manager)?

Here is an outstanding presentation to review from Oracle concerning PUM.

PeopleSoft 9.2 Update Manager [PUM] New Resources and Documentation [1464619.1]

)

Alliance 2014

Looking forward to another Alliance!  Here are the details for 2014. 

http://www.alliance-conference.com/e/in/eid=248&s=8467&print=1&req=info

Here are the sessions that I will be presenting this year.

Session Title:	Best practices for applying Campus Solutions Maintenance
Session Number:	33081
Track:	Technical
Crosslisted Track:	Oracle
Session Type:	Vendor
Sub-Categorization:	Select A Value
Room Assignment:	Section 313 + 316 => Mon, Mar 10, 2014 (01:45 PM - 02:45 PM)
Initial Submission:	Sep 23, 2013 10:54 AM America/Arizona

Co-Presenting

Troubleshooting CS-HCM and Other Campus Solutions Web Services

---

Session Number: 33107
Track: Technical
Sub-Categorization: Select A Value
Session Type: Oracle Application
Tags: AAWS, Integration, Peoplesoft 9.0, Split
Primary Presenter: Daune' Oliveira [Principle Technical Support Engineer - Oracle]
Co-Presenter: Jeromy McMahon [Principle Technical Support Engineer - Oracle]
Co-Presenter 2: Andrew Cesario [Senior Principle Technical Support Engineer - Oracle]
Time: Mar 12, 2014 (10:30 AM - 11:30 AM)

How to TEST? Using Generic Service Tester - Service: SCC_USERREG - Service Operation: SCC_USERREG_AUTHENTICATE

In the next few weeks, I am going to post some good samples and How To's for testing AAWS (Admission Application Web Services) and NUR (New User Registration).

How do I test?

Service Name:  SCC_USERREG

Service Operation: SCC_USERREG_AUTHENTICATE

Navigate to:  

Set Up SACR -> System Administration ->Utilities -> Generic Service Tester -> Service Tester

Enter in a valid user to test.  In this sample, I am using the same PS user.

AAWS - Admissions Application Web Services - Listing of great KM docs from Oracle

Here is a listing of KM docs regarding AAWS.

AAWS - CS 9.0 Bundle #23 Functional Documentation and Additional Features October 2011 (Doc ID 1371376.1)

Campus Solutions 9.0 Generic Service Tester Tool (Doc ID 1478817.1)

1323959.1 - AAWS - Data Mapping and Entity Catalog
1373575.1 - AAWS - Sample XML Files for SAD_GETAPPL_REQ and SAD_CREATEAPPL_REQ

Find Records/Tables within a Default Message - PERSON_BASIC_SYNC - Sample SQL

Provide a listing of records for a particular message.  This example is PERSON_BASIC_SYNC.



SELECT DISTINCT C.recname,
                D.rectype "Tables Only",
                C.msgname,
                A.defaultver
FROM   psmsgdefn A,
       psmsgver B,
       psmsgrec C,
       psrecdefn D
WHERE  A.msgname = B.msgname
       AND A.defaultver = B.apmsgver
       AND C.msgname = B.msgname
       AND C.apmsgver = B.apmsgver
       AND D.recname = C.recname
       AND D.rectype = 0
       AND A.msgname = 'PERSON_BASIC_SYNC'
ORDER  BY C.recname ASC 

RECNAME	Tables Only	MSGNAME	DEFAULTVER
ADDRESSES	0	PERSON_BASIC_SYNC	INTERNAL
EMAIL_ADDRESSES	0	PERSON_BASIC_SYNC	INTERNAL
NAMES	0	PERSON_BASIC_SYNC	INTERNAL
NATIONALITY_GER	0	PERSON_BASIC_SYNC	INTERNAL
PERSON	0	PERSON_BASIC_SYNC	INTERNAL
PERSONAL_PHONE	0	PERSON_BASIC_SYNC	INTERNAL
PERSON_BRA	0	PERSON_BASIC_SYNC	INTERNAL
PERSON_FRA	0	PERSON_BASIC_SYNC	INTERNAL
PERSON_SA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_BRA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_CAN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_CHE	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_DEU	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_EFFDT	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_ESP	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_FPS	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_FRA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_IND	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_ITA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_JPN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_MEX	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_USA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_USF	0	PERSON_BASIC_SYNC	INTERNAL
PERS_HUKOU_CHN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_NID	0	PERSON_BASIC_SYNC	INTERNAL
PERS_SMOKER	0	PERSON_BASIC_SYNC	INTERNAL
PERS_WRKLIF_CHN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_WRKLV_CHN	0	PERSON_BASIC_SYNC	INTERNAL
PLACE_ORIG_CHE	0	PERSON_BASIC_SYNC	INTERNAL

Entity Property Sync

Where is the Entity Sync within Campus Solutions?

Set Up SACR > System Administration > Entity >Entity Property Sync

Once you are on the page/component, click the "Sync All Entity Properties" button.

SOA error log - Navigation

Integrations - AAWS / HCM Split
Question:  Where can I set the SOA error log for reviewing integrations?



The SOA error log Navigation

Answer:  The path for the log is set in Set Up SACR > System Administration > Integration > Logging