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.

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>