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

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]

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> 

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

1. Navigate to Set Up SACR > System Administration > Entity > Entity Registry.  Retrieve the General Materials Attachment, check Embed, then save.
2. Select Return to Search and retrieve Work Experience Attachment.  Check Embed, then save.
3. 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.

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>

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 )

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).

Find Navigation Path or BreadCrumbs for a Component in Peoplesoft / Oracle

There have been some great blog posts for this type of query.  Here are a few that I like

From CompShack - http://www.compshack.com/breadcrumb/breadcrumb-sql-to-find-navigation-path-for-component-pia

From Peoplesoft Tipster - http://peoplesofttipster.com/2007/12/09/portal-navigation/


/* Provide navigation location for component */
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
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'
       -- Parameter to set:  (In this case I used the component - ADM_APPL_MAINTNCE)
       AND a.portal_uri_seg2 = 'ADM_APPL_MAINTNCE' 

Alliance 2012

Looking forward to attending and presenting at the HEUG Alliance Conference 2012 in Nashville!

Here is the technical track session I will be presenting with a great colleague Andrew Cesario.

Wed, Mar 21, 2012 (09:15 AM - 10:15 AM)

     Technical

30009:Campus Solutions AAWS: A Technical Overview