This discussion is archived
7 Replies Latest reply: Nov 16, 2012 4:23 AM by 876464 RSS

PeopleSoft WSDL cannot display data in ADF

876464 Newbie
Currently Being Moderated
Hello all,
I hardly have any knowledge of PeopleSoft .I have a PeopleSoft WSDL. The XML SOAP request is as follows.
<?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>ABC</wsse:Username>
<wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">ABC</wsse:Password>
</wsse:UsernameToken>
</wsse:Security>
</soapenv:Header>
<soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<WorklistWorkflowRequest xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/TCS_FIND_WL.1">
<OPRID>ABC</OPRID>
</WorklistWorkflowRequest>
</soapenv:Body>
</soapenv:Envelope>




I used the WSDL to create a Web Service data control in ADF. While doing the same in the step Provide HTTP basic authentication details for endpoint URL , i passed the username : ABC and password : ABC as in the XML request to help the data control connect to Peoplesoft. I then drag and dropped the RETURN(LIST OF VALUES) to a jspx page and provided the binding value as ABC (OPRID VALUE) .Every time I run the page , I get the error <SOAPProvider> <createComplexPart> Value for parameter 'OPRID' cannot be null
Where must I specify OPRID value so i dont get the error.

Thanks in advance.
  • 1. Re: PeopleSoft WSDL cannot display data in ADF
    Frank Nimphius Employee ACE
    Currently Being Moderated
    Hi,

    by experience with the complexity of Peoplesoft WS I recommend using a JAX-WS proxy client and access its method from a wrapper bean that then you expose to ADF in a POJO Data Control

    Frank
  • 2. Re: PeopleSoft WSDL cannot display data in ADF
    876464 Newbie
    Currently Being Moderated
    Hello,
    Thanks for your quick reply. Could you explain the same in a bit more details.??

    Thanks
  • 3. Re: PeopleSoft WSDL cannot display data in ADF
    Shay Shmeltzer Employee ACE
    Currently Being Moderated
    I would suggest you run with the HTTP Analyzer to see what exact SOAP messages are being sent to the Web service and whether your value is being passed as a parameter to the service.
  • 4. Re: PeopleSoft WSDL cannot display data in ADF
    876464 Newbie
    Currently Being Moderated
    Hello Shay,
    I did the same as you directed. The HTTP ANALYZER is asking for the OPRID value , I passed the OPRID value but in the Response HTTP Headers, the List : Array is empty. The service is not returning any values. What could be the possible problem??

    Thanks
  • 5. Re: PeopleSoft WSDL cannot display data in ADF
    Shay Shmeltzer Employee ACE
    Currently Being Moderated
    Seems like a problem on the PSFT side - talk to your PSFT guys and see if they can figure out what parameter needs to be passed to get data back.
  • 6. Re: PeopleSoft WSDL cannot display data in ADF
    876464 Newbie
    Currently Being Moderated
    Hello Shay,
    This is the Request HTTP header generated in the HTTP ANALYZER is as follows:

    <env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:ns2="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:ns3="http://xmlns.oracle.com/Enterprise/Tools/schemas/TCS_FIND_WL.1">
    <env:Header>
    <ns1:Security>
    <ns1:UsernameToken>
    <ns1:Username>ABC</ns1:Username>
    <ns1:Password>ABC</ns1:Password>
    <ns1:Nonce/>
    <ns2:Created/>
    <ns2:Expires/>
    </ns1:UsernameToken>
    </ns1:Security>
    </env:Header>
    <env:Body>
    <ns3:WorklistWorkflowRequest>
    <ns3:OPRID>ABC</ns3:OPRID>
    </ns3:WorklistWorkflowRequest>
    </env:Body>
    </env:Envelope>

    This http request header exactly matches with the XML request as in my first post on this thread. This xml request was given by the PeopleSoft guys. Since , both the requests match, why is it so that the data is generated on the PeopleSoft and not on the ADF side???


    Requesting help.
    Thanks
  • 7. Re: PeopleSoft WSDL cannot display data in ADF
    876464 Newbie
    Currently Being Moderated
    Hello,
    I replicated the steps as done in the following article.
    http://www.oracle.com/technetwork/middleware/fmw4apps/peoplesoft/oow2009-adf-psft-182158.pdf


    Here OPRID is drag and dropped as a trinidad form, GET_WL(object) as button with bindings as ${bindings.parameterIterator.currentRow.dataProvider} , and the return type(a list of values) as a table.
    However , when I run the 1.jspx page , I get the error in the jdev log as follows:


    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
         at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
         at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
         at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
         at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
         at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
         at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
    Caused by: oracle.security.jps.JpsRuntimeException: java.lang.reflect.InvocationTargetException
         at oracle.security.jps.az.internal.runtime.service.PDPServiceImpl.getOPSSMicroSMBridge(PDPServiceImpl.java:974)
         at oracle.security.jps.az.internal.runtime.service.PDPServiceImpl.getPermissions(PDPServiceImpl.java:654)
         at oracle.security.jps.internal.policystore.PolicyDelegationController.getPermissions(PolicyDelegationController.java:364)
         at oracle.security.jps.internal.policystore.JavaPolicyProvider.getPermissions(JavaPolicyProvider.java:323)
         at oracle.security.jps.internal.policystore.JavaPolicyProvider.impliesCSDomain(JavaPolicyProvider.java:468)
         at oracle.security.jps.internal.policystore.JavaPolicyProvider.implies_NotPrivileged(JavaPolicyProvider.java:426)
         at oracle.security.jps.internal.policystore.JavaPolicyProvider.implies(JavaPolicyProvider.java:412)
         at java.security.ProtectionDomain.implies(ProtectionDomain.java:224)
         at java.security.AccessControlContext.checkPermission(AccessControlContext.java:352)
         at java.security.AccessController.checkPermission(AccessController.java:546)
         at oracle.security.jps.util.JpsAuth$AuthorizationMechanism$3.checkPermission(JpsAuth.java:436)
         at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:496)
         at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:519)
         at oracle.security.jps.internal.jaas.AbstractSubjectSecurity.checkPermission(AbstractSubjectSecurity.java:144)
         at oracle.security.jps.internal.jaas.AbstractSubjectSecurity.getActionExecutor(AbstractSubjectSecurity.java:82)
         at oracle.wsm.policyaccess.ConfigurationFramework$ExecutorGetter.run(ConfigurationFramework.java:847)
         at oracle.wsm.policyaccess.ConfigurationFramework$ExecutorGetter.run(ConfigurationFramework.java:820)
         at java.security.AccessController.doPrivileged(Native Method)
         at oracle.wsm.policyaccess.ConfigurationFramework.getBean(ConfigurationFramework.java:1613)
         at oracle.wsm.policyaccess.ConfigurationFramework.access$500(ConfigurationFramework.java:133)
         at oracle.wsm.policyaccess.ConfigurationFramework$ContextualAccessor.configure(ConfigurationFramework.java:490)
         at oracle.wsm.policyaccess.ConfigurationFramework$ContextualAccessor.<init>(ConfigurationFramework.java:412)
         at oracle.wsm.policyaccess.ConfigurationFramework$ContextualAccessor.<init>(ConfigurationFramework.java:299)
         at oracle.wsm.policyaccess.ConfigurationFramework.initializeAccessors(ConfigurationFramework.java:1910)
         at oracle.wsm.policyaccess.ConfigurationFramework.reset(ConfigurationFramework.java:1982)
         at oracle.wsm.policyaccess.ConfigurationFramework.getPolicyAccessPoint(ConfigurationFramework.java:1702)
         at oracle.wsm.policyaccess.impl.PolicyAccessorImpl.<init>(PolicyAccessorImpl.java:153)
         at oracle.integration.platform.common.mgmt.PolicyCacheImpl.<init>(PolicyCacheImpl.java:217)
         at oracle.integration.platform.common.mgmt.PolicyCacheImpl.getInstance(PolicyCacheImpl.java:75)
         at oracle.integration.platform.common.mgmt.InterceptorChainManager.<init>(InterceptorChainManager.java:56)
         at oracle.integration.platform.common.mgmt.InterceptorChainManager.<init>(InterceptorChainManager.java:95)
         at oracle.j2ee.ws.client.mgmt.runtime.SuperClientInterceptorPipeline.createSOAPBindingInterceptorChain(SuperClientInterceptorPipeline.java:200)
         at oracle.j2ee.ws.client.mgmt.runtime.SuperClientInterceptorPipeline.getPolicyPipeline(SuperClientInterceptorPipeline.java:231)
         at oracle.j2ee.ws.client.mgmt.runtime.SuperClientInterceptorPipeline.getPolicyPipeline(SuperClientInterceptorPipeline.java:222)
         at oracle.j2ee.ws.client.mgmt.runtime.SuperClientInterceptorPipeline.handleRequest(SuperClientInterceptorPipeline.java:74)
         at oracle.j2ee.ws.client.jaxws.DispatchImpl.handleRequest(DispatchImpl.java:614)
         at oracle.j2ee.ws.client.jaxws.DispatchImpl.handleRequest(DispatchImpl.java:592)
         at oracle.j2ee.ws.client.jaxws.DispatchImpl.invoke(DispatchImpl.java:788)
         ... 80 more
    Caused by: java.lang.reflect.InvocationTargetException
         at sun.reflect.GeneratedConstructorAccessor579.newInstance(Unknown Source)
         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
         at oracle.security.jps.az.internal.runtime.service.PDPServiceImpl$1.run(PDPServiceImpl.java:970)
         at oracle.security.jps.az.internal.runtime.service.PDPServiceImpl$1.run(PDPServiceImpl.java:965)
         at java.security.AccessController.doPrivileged(Native Method)
         at oracle.security.jps.az.internal.runtime.service.PDPServiceImpl.getOPSSMicroSMBridge(PDPServiceImpl.java:964)
         ... 117 more
    Caused by: java.lang.RuntimeException: java.lang.ClassNotFoundException: com.bea.security.impl.MicroSMImpl
         at com.bea.security.MicroSM.getInstance(MicroSM.java:83)
         at com.bea.security.impl.OPSSMicroSMBridgeImpl.<init>(OPSSMicroSMBridgeImpl.java:191)
         ... 124 more
    Caused by: java.lang.ClassNotFoundException: com.bea.security.impl.MicroSMImpl
         at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
         at java.lang.ClassLoader.loadClass(ClassLoader.java:305)
         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
         at java.lang.ClassLoader.loadClass(ClassLoader.java:246)
         at com.bea.security.MicroSM.getInstance(MicroSM.java:72)
         ... 125 more
    <Utils> <buildFacesMessage> ADF: Adding the following JSF error message: java.lang.reflect.InvocationTargetException
    javax.xml.ws.WebServiceException: oracle.security.jps.JpsRuntimeException: java.lang.reflect.InvocationTargetException

    Help please.Why is the error generated???

    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points