Peoplesoft / Oracle tips

Wednesday, March 12, 2014

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]

)

Tuesday, December 31, 2013

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)

Monday, September 9, 2013

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.

Friday, July 19, 2013

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	MSGNAME	DEFAULTVER
ADDRESSES	PERSON_BASIC_SYNC	INTERNAL
EMAIL_ADDRESSES	PERSON_BASIC_SYNC	INTERNAL
NAMES	PERSON_BASIC_SYNC	INTERNAL
NATIONALITY_GER	PERSON_BASIC_SYNC	INTERNAL
PERSON	PERSON_BASIC_SYNC	INTERNAL
PERSONAL_PHONE	PERSON_BASIC_SYNC	INTERNAL
PERSON_BRA	PERSON_BASIC_SYNC	INTERNAL
PERSON_FRA	PERSON_BASIC_SYNC	INTERNAL
PERSON_SA	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_BRA	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_CAN	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_CHE	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_DEU	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_EFFDT	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_ESP	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_FPS	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_FRA	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_IND	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_ITA	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_JPN	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_MEX	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_USA	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_USF	PERSON_BASIC_SYNC	INTERNAL
PERS_HUKOU_CHN	PERSON_BASIC_SYNC	INTERNAL
PERS_NID	PERSON_BASIC_SYNC	INTERNAL
PERS_SMOKER	PERSON_BASIC_SYNC	INTERNAL
PERS_WRKLIF_CHN	PERSON_BASIC_SYNC	INTERNAL
PERS_WRKLV_CHN	PERSON_BASIC_SYNC	INTERNAL
PLACE_ORIG_CHE	PERSON_BASIC_SYNC	INTERNAL

Thursday, May 2, 2013

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.

Thursday, October 11, 2012

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

HCM Registry cache - Navigation

Question: What is the navigation for the HCM Registry cache?

Answer: HCM Registry cache. To refresh the HCM Registry cache, navigate to the Main Menu > Set Up HRMS > System Administration > HCM Registry > Service Registry and select the Refresh Cache button.

How do I tell which CS bundles are included in a Maintenance Pack? MOS

Here is a great location within Oracle Support to find these patches.

First navigate to MOS (MyOracleSupport)
http://support.oracle.com

How do I tell which Campus Solutions (CS) bundles are included in a Maintenance Pack?

KM Doc ID: 1294337.1

Based on the recent information about finding bundles/patchsets in ARU and My Oracle Support. Here are some valuable Knowledge Documents:

1. PeopleSoft Sample Service Request Templates for Use in Communicating to Customers
KM Doc ID 1453732.1
2. Listing of Old Update IDs and New Patchsets for Use in Finding Campus Solutions 9.0 and 8.9 Bundles KM Doc ID 1469896.1

Alliance 2013

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

http://www.alliance-conference.com/p/cm/ld/fid=581

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

Session Title:	Integration Tips, Tricks, & Troubleshooting - AAWS and HCM/CS Split Discussion
Session Number:	31267
Track:	Mini Sessions
Crosslisted Track:	Technical
Session Type:	Tips and Tricks
Sub-Categorization:	Technical
Room Assignment:	Sagamore 4 => Mon, Mar 18, 2013 (12:45 PM - 01:15 PM)

Co-Presenter with this session.

Session Title:	Testing and Troubleshooting Tips for Admission Applications Web Services (AAWS) and CTM
Session Number:	31609
Track:	Admissions
Session Type:	Oracle Application
Sub-Categorization:	Technical
Room Assignment:	232 => Mon, Mar 18, 2013 (08:00 AM - 09:00 AM)
Initial Submission:	Oct 05, 2012 01:35 PM America/Arizona
Status:	Approved and Accepted
Session Submitter:	Daune Oliveira
Primary Presenter:	Daune Oliveira [Principle Technical Support Engineer - Oracle]
Co-Presenter:	Jeromy McMahon [Principle Engineer - Oracle]

Monday, May 7, 2012

AAWS (Admissions Application Web Services) - soapUI sample XML request message - SCC_UR_CREATEACCT_REQ

Here is a sample request message for SCC_USERREG.

Service Operation: SCC_UR_CREATEACCT_REQ

This would be the minimum amount of fields needed for this request to process successfully. You must have the template defined for the SCC_GUEST user for the roles to be added.

CONSTITUENT information may be added as well, but for this example, I have kept a blank tag.

Security can be added within the request message shown below, or this Header section can be removed and it can be manged within soapUI "Request Properties"

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://xmlns.oracle.com/Enterprise/HCM/services"> 
   <soapenv:Header xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <wsse:Security soap:mustUnderstand="1" 
     xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" 
     xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
     <wsse:UsernameToken>
                 <wsse:Username>PS</wsse:Username>
                 <wsse:Password>PS</wsse:Password>
     </wsse:UsernameToken>
   </wsse:Security>
   </soapenv:Header> 
   <soapenv:Body>
      <ser:SCC_UR_CREATEACCT_REQ>
         <ser:SCC_USERNAME>JMTEST_USER_2</ser:SCC_USERNAME>
         <ser:SCC_PASSWORD>password</ser:SCC_PASSWORD>
         <ser:SCC_CONFIRMPWD>password</ser:SCC_CONFIRMPWD>
         <ser:CONSTITUENT>
         </ser:CONSTITUENT>
      </ser:SCC_UR_CREATEACCT_REQ>
   </soapenv:Body>
</soapenv:Envelope>

Sample for SCC_UR_AUTHENTICATE_REQ

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"  xmlns:ser="http://xmlns.oracle.com/Enterprise/HCM/services">
  <soapenv:Header xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
  <wsse:Security soap:mustUnderstand="1"
    xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
    xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
    <wsse:UsernameToken>
    <wsse:Username>PS</wsse:Username>
    <wsse:Password>PS</wsse:Password>
    </wsse:UsernameToken>
  </wsse:Security>
  </soapenv:Header>
  <soapenv:Body>
     <ser:SCC_UR_AUTHENTICATE_REQ>
        <!--Optional:-->
        <ser:SCC_ENTITY_INST_ID></ser:SCC_ENTITY_INST_ID>
        <ser:SCC_USERNAME>JMTEST_USER</ser:SCC_USERNAME>
        <ser:SCC_PASSWORD>password</ser:SCC_PASSWORD>
     </ser:SCC_UR_AUTHENTICATE_REQ>
  </soapenv:Body>
</soapenv:Envelope>

Another sample when I generate from Tools.

<?xml version="1.0"?>
<soapenv:Envelope xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://schemas.xmlsoap.org/ws/2003/03/addressing/" xmlns:xsd="http://www.w3.org/2001/XMLSchema/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance/">
  <soapenv:Header xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <wsse:Security soap:mustUnderstand="1" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
      <wsse:UsernameToken wsu:Id="UsernameToken-1" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
        <wsse:Username>PS</wsse:Username>
        <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">PS</wsse:Password>
      </wsse:UsernameToken>
    </wsse:Security>
  </soapenv:Header>
  <soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <SCC_UR_AUTHENTICATE_REQ xmlns="http://xmlns.oracle.com/Enterprise/HCM/services">
      <SCC_ENTITY_INST_ID>XYZ</SCC_ENTITY_INST_ID>
      <SCC_USERNAME>XYZ</SCC_USERNAME>
      <SCC_PASSWORD>XYZ</SCC_PASSWORD>
    </SCC_UR_AUTHENTICATE_REQ>
  </soapenv:Body>
</soapenv:Envelope>

Thursday, May 3, 2012

soapUI Error when loading WSDL - SAD_ADMISSIONS.1.wsdl or SCC_USERREG.1.wsdl - The value '' is an invalid name

Please reference My Oracle Support KM doc for workaround:
AAWS - After Applying CS 9 Bundle 24, soapUI 4.0.1 Generates Error - The value '' is an invalid name (Doc ID 1419303.1)

This issue has been reported in Bug 13739421.

Workaround

Navigate to Set Up SACR > System Administration > Entity > Entity Registry. Retrieve the General Materials Attachment, check Embed, then save.
Select Return to Search and retrieve Work Experience Attachment. Check Embed, then save.
Select Return to Search and retrieve Constituent. Click Generate XSD, make a copy of the XSD or save to your desktop for reference.

Review the schema for SCC_ENTITY_CONSTITUENT, as it will not be updated until a save. Test the new XSD using soapUI via the XSD downloaded. This should work as one option for testing. Do the same test using the WSDL URL from Provide Web Service. Edit schema for SCC_ENTITY_CONSTITUENT, delete the schema and copy the new schema (XSD) in. Re-test and the URL should now work for soapUI 4.0.1.

Wednesday, May 2, 2012

AAWS (Admissions Application Web Service) Sample XML - SCC_LOV / SCC_GET_LOV

Here is a great soapUI sample request message for SCC_LOV.

NOTE: You may need to enter in a different Username and Password for your environment.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://xmlns.oracle.com/Enterprise/HCM/services"> 
   <soapenv:Header xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <wsse:Security soap:mustUnderstand="1" 
     xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" 
     xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
     <wsse:UsernameToken>
                 <wsse:Username>PS</wsse:Username>
                 <wsse:Password>PS</wsse:Password>
     </wsse:UsernameToken>
   </wsse:Security>
   </soapenv:Header>  
   <soapenv:Body>
      <ser:SCC_LOV_REQ>
         <ser:LOVS>
            <ser:LOV name="?">
               <ser:FIELDNAME>INSTITUTION</ser:FIELDNAME>
               <ser:RECORDNAME>ACAD_PROG_TBL</ser:RECORDNAME>
               <ser:LOVCONTEXT></ser:LOVCONTEXT>
               <ser:KEYS>
                  <!--1 or more repetitions:-->
                  <ser:KEY>
                     <ser:FIELDNAME></ser:FIELDNAME>
                     <ser:FIELDVALUE></ser:FIELDVALUE>
                  </ser:KEY>
               </ser:KEYS>
            </ser:LOV>
         </ser:LOVS>
      </ser:SCC_LOV_REQ>
   </soapenv:Body>
</soapenv:Envelope>

Tuesday, March 27, 2012

SQL to find duplicates - Sample PS_PERS_NID

Here is a sample SQL of how one could find multiple rows.

Example: Using HAVING count(*) > 1

SELECT A.EMPLID,
COUNT(A.EMPLID) AS NumOccurrences
FROM PS_PERS_NID A
GROUP BY A.EMPLID
HAVING ( COUNT(A.EMPLID) > 1 )

All rows within PS_PERS_NID should have a primary row.
Adding primary

SELECT A.EMPLID,
COUNT(A.EMPLID) AS NumOccurrences
FROM PS_PERS_NID A
WHERE A.PRIMARY_NID = 'Y'
GROUP BY A.EMPLID
HAVING ( COUNT(A.EMPLID) > 1 )

Thursday, January 19, 2012

Campus Solutions - Row level Security Components

Here is a sample SQL that will provide the components for CS Row Level security. You can then reference the records within App Desginer and create *.dms scripts for exporting the user security.

SELECT a.portal_name,
       e.portal_label    AS parent4_folder,
       d.portal_label    AS parent3_folder,
       c.portal_label    AS parent2_folder,
       b.portal_label    AS parent_folder,
       a.portal_label    AS component,
       a.portal_uri_seg2 AS component_dbname
FROM   psprsmdefn a
       left join psprsmdefn b
         ON b.portal_name = a.portal_name
            AND b.portal_objname = a.portal_prntobjname
       left join psprsmdefn c
         ON c.portal_name = b.portal_name
            AND c.portal_objname = b.portal_prntobjname
       left join psprsmdefn d
         ON d.portal_name = c.portal_name
            AND d.portal_objname = c.portal_prntobjname
       left join psprsmdefn e
         ON e.portal_name = d.portal_name
            AND e.portal_objname = d.portal_prntobjname
WHERE  a.portal_reftype = 'C'
       AND e.portal_label LIKE 'Set Up SACR'
       AND d.portal_label LIKE 'Security';

Please also review this posting from PeoplesoftTipster.com

http://peoplesofttipster.com/2007/04/12/moving-peoplesoft-config-between-environments/#more-15

There are a number of tools you could use to achieve this, be it data mover, raw SQL or even an SQR or App Engine. All of these would need to be custom written. An alternative solution is to use the Manage Configuration Set functionality. It’s a delivered component (at least on more recent versions of the Application) that lets you choose the modules you wish to export config for, and it builds the DMS files (Data Mover Scripts) for you.

Sample Navigation:

http://<name:port>/psp/<environment>/EMPLOYEE/HRMS/c/EOLT_IMPLEMENTATION.EOLT_CONFIG_OPT.GBL

or go to PeopleTools > Portal > Structure and Content, drill down into Enterprise Components and edit Manage Implementations to not hide it from portal navigation (checkbox on first page).