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

Why are my Request Messages in Latin? Using SOAPUI

I have been scratching my head on this one for days and it was a simple setting.  I did change the value many times but didn't realize that I needed to reload the WSDL definition for the changes to take effect.  :-)

The sample values (in Latin) are created because of the soapUI Preferences.
If you dislike having these sample values or having to adjust them by hand, you can turn them off by ticking off WSDL Settings->Sample Values checkbox. When you add the WSDL again, the new sample requests will have no sample values and just a question mark. "? "

Settings:  Make sure this is unchecked.

 

When you uncheck the setting, you will have just the ? mark.

PeopleTools Table Reference

Here is a great Peopletools reference for delivered tools tables.

http://www.go-faster.co.uk/peopletools/#PT

AAWS - Admissions Application Web Services - Info

My Oracle Support KM docs to review: 

CS 9.0 Bundle #21 Functional Documentation and Additional Features April 2011 (Doc ID 1314754.1)

Specific files to download:
1. CS_Bundle_21_Manage_Admission_Transactions.pdf (1.85 MB)
2. AAWS Users Guide.pdf (541 KB)
3. AAWS Developers Guide.pdf (1.11 MB)
 
Within Oracle/Peoplesoft there are 9 different web services provided with AAWS and 2 for Payment Processing.

There are six services for Application Processing:

• Create Application - SAD_CREATEAPPL
• Get Application - SAD_GETAPPL
• Get Application(s) - SAD_GETAPPLS
• Get Attachment - SAD_GETATTACH
• Save Application - SAD_SAVEAPPL
• Submit Application - SAD_SUBMITAPPL

There are three for User Registration:

• User Authentication - SCC_USERREG_AUTHENTICATE
• User Registration - SCC_USERREG_CREATEACCT
• Get a List of Values - SCC_GET_LOV