7 Replies Latest reply: Nov 16, 2012 6:23 AM by 876464 RSS

    PeopleSoft WSDL cannot display data in ADF

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