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>

9 comments:

Anonymous said...

Hii can we please explain how to implement AAWS in people soft with document screen shots in demo.about online application records,peoplesoft records all..that would be helpful a lot for us.

Thanks for ur blogging.these are most valuble lessons.

jia khalid said...

While testing it via "Test Service Operation" in Peoplesoft, i get the following exception:

ICPanel](o) Integration Broker Sync Handler: OnRequest for message SCC_GET_LOV could not run to completion on node PSFT_HR.
(158,974) IBTREE_WRK.IB_INVOKEOPER.FieldChange PCPC:4883 Statement:104

Any idea?

Jeromy McMahon said...

Make sure you are current with maintenance and objects. Check CS Bundles and HR core bundles. You can also verify your IB settings, check the node, gateway...etc Make sure they are pingable. Are you testing via soapUI or service operation tester? Check service operation security. Those are a few suggestions you can try.

jia khalid said...

Thanks for quick response.
The gateway and node are pingable.
I have tested it via soapUI and it works fine. The exception posted in my previous post comes when i test via service operation tester. Also, when i try to consume the service via my custom online admission application it gives:

SEVERE: Exception
javax.xml.ws.WebServiceException: {http://xmlns.oracle.com/Enterprise/HCM/services/SCC_LOV.1}SCC_LOV is not a valid service. Valid services are: {http://xmlns.oracle.com/Enterprise /HCM/services}SCC_LOV

M Asim said...

Hi Jia Khalid
I am getting the same the problem if you have find it,s solution then please share.
Thanks.

Jeromy McMahon said...

Can you test via the Generic Service Tester? SetUp>SACR>Utilities>Generic Service Tester?

M Asim said...

from where i can get setup of genric service tester??

Anonymous said...

hi Jeromy:
I am usig PS 8.52 and in SetUp>SACR>Utilities>Generic Service Tester
but in my case I have no delivered Generic Service Tester icon in my utilities or System Administration folder.
Thanks

Jeromy McMahon said...

You need to be current with CS Bundles. Please review this within Oracle support - Campus Solutions 9.0 Generic Service Tester Tool (Doc ID 1478817.1)