Thursday, July 24, 2014

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 

Thursday, March 13, 2014

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


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





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