This discussion is archived
1 2 3 Previous Next 43 Replies Latest reply: Oct 27, 2012 9:56 AM by Nicolas.Gasparotto Go to original post RSS
  • 15. Re: Generate SOAP Template
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    >
    <DefaultMessage>No rows exist for the specified keys. {MI_PERSONAL_CI} (91,50)</DefaultMessage>
    <MessageParameters>
    <keyinformation>
    <EMPLID>?</EMPLID>
    >

    As the message says, there a no rows for the specified keys.
    It looks like you have used the default request message generate by SoapUI, which fills all elements with a ?.
    You should replace this with actual PeopleSoft values.

    Before invoking the CI based service, first logon to PeopleSoft, navigate to your component and go to the search page by supplying keyvalue.
    If you can go past the search page (so data is found for this component), use the same keyvalues eg EMPLID in your service operation request.

    Something like:
    <EMPLID>KU0007</EMPLID>
  • 16. Re: Generate SOAP Template
    857877 Newbie
    Currently Being Moderated
    yes... for the GET function i supplied KEY Value ( EMP-ID )

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:m65="http://xmlns.oracle.com/Enterprise/Tools/schemas/M650797.V1">
    <soapenv:Header/>
    <soapenv:Body>
    <m65:Get__CompIntfc__MI_PERSONAL_CI>
    <m65:EMPLID>0117/m65:EMPLID>
    </m65:Get__CompIntfc__MI_PERSONAL_CI>
    </soapenv:Body>
    </soapenv:Envelope>


    and i got the below output. But DATA is not getting displayed.

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Body>
    <m65:Get__CompIntfc__MI_PERSONAL_CIResponse xmlns:m65="http://xmlns.oracle.com/Enterprise/Tools/schemas/M408969.V1">
    <m65:EMPLID>0117</m65:EMPLID>
    <m65:NAME/>
    <m65:PHONE/>
    <m65:ADDRESS1/>
    <m65:EMAILID/>
    <m65:CITY/>
    <m65:STATE/>
    <m65:ZIP/>
    <m65:MAR_STATUS/>
    <m65:CONTACT_NAME/>
    </m65:Get__CompIntfc__MI_PERSONAL_CIResponse>
    </soapenv:Body>
    </soapenv:Envelope>


    ===============================================================================================================

    And, for find operation, i am not geeting anything, I am getting errro


    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
    <SOAP-ENV:Body>
    <SOAP-ENV:Fault>
    <faultcode>SOAP-ENV:Server</faultcode>
    <faultstring>Component Interface API.</faultstring>
    <detail>
    <CIFault xmlns="http://xmlns.oracle.com/Enterprise/Tools/schemas/M116479.V1">
    <IBResponse type="Error">
    <DefaultTitle>Integration Broker Response</DefaultTitle>
    <StatusCode>20</StatusCode>
    <MessageSetID>91</MessageSetID>
    <MessageID>2</MessageID>
    <DefaultMessage>Cannot find Component Interface {CI_FPMSALSTEP_PNLResponse} (91,2)</DefaultMessage>
    <MessageParameters/>
    </IBResponse>
    <IBResponse type="Error">
    <DefaultTitle>Integration Broker Response</DefaultTitle>
    <StatusCode>20</StatusCode>
    <MessageSetID>90</MessageSetID>
    <MessageID>7</MessageID>
    <DefaultMessage>Initialization Failed (90,7)</DefaultMessage>
    <MessageParameters/>
    </IBResponse>
    <IBResponse type="Error">
    <DefaultTitle>Integration Broker Response</DefaultTitle>
    <StatusCode>20</StatusCode>
    <MessageSetID>90</MessageSetID>
    <MessageID>6</MessageID>
    <DefaultMessage>Not Authorized (90,6)</DefaultMessage>
    <MessageParameters/>
    </IBResponse>
    <IBResponse type="Error">
    <DefaultTitle>Integration Broker Response</DefaultTitle>
    <StatusCode>20</StatusCode>
    <MessageSetID>91</MessageSetID>
    <MessageID>20</MessageID>
    <DefaultMessage>Error initializing Component Interface {CI_FPMSALSTEP_PNLResponse}</DefaultMessage>
    <MessageParameters/>
    </IBResponse>
    </CIFault>
    </detail>
    </SOAP-ENV:Fault>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>
  • 17. Re: Generate SOAP Template
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    Are you able to see data in the PeopleSoft component, after supplying emplid=0117?

    What I do not understand is that you have two different responses that look like to different CI Based Services:
    CI_FPMSALSTEP_PNL
    MI_PERSONAL_CI

    Are we talking about two CI based services on two different components?
    If so, lets start of by trying to fix one, because I am getting confused.

    Hakan
  • 18. Re: Generate SOAP Template
    857877 Newbie
    Currently Being Moderated
    Hello Hakan,

    I created WSDL file by using the compoent MI_PERSONAL_CI. I am not aware from where CI_FPMSALSTEP_PNL is coming up.

    I am using WSDL ( http://184.73.174.36:9080/PSIGW/PeopleSoftServiceListeningConnector/CI_MI_PERSONAL_CI.1.wsdl ) by SOAP UI.
  • 19. Re: Generate SOAP Template
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    Delete the WSDL and redeploy the CI based Service, because it does not look correct. It has definitions of messages that do no have any relation to you CI.

    How to delete a WSDL?
    http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tibr/book.htm?File=tibr/htm/tibr21.htm#H4045
  • 20. Re: Generate SOAP Template
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    By the way,

    I see that your PeopleSoft Environment is actually running in the internet.
    If I can logon to your Weblogic console, everyone else can too, with all possible consequences!!!!!

    You might want to change some passwords or even take it off the net.

    Regards,

    Hakan
  • 21. Re: Generate SOAP Template
    857877 Newbie
    Currently Being Moderated
    redeploy the CI based Service means do i have to create new WSDL file by following below documents link

    http://peoplesoft.wikidot.com/component-interface-based-web-services
  • 22. Re: Generate SOAP Template
    857877 Newbie
    Currently Being Moderated
    Also, do i have to clear

         
    Clear WSDL Export Status by clicking on the link (      
    Clear WSDL Export Status )
  • 23. Re: Generate SOAP Template
    857877 Newbie
    Currently Being Moderated
    i m in process of creating new WSDL file

    but getting below error ..... kindly suggest




    PSAPPSRV.1540 (4340) [10/23/12 16:28:27 PS@116.202.184.205 (CHROME 22.0.1229.94; WIN7) ICPanel](0) SQL error. Function: SQLExec

    Error Position: 0

    Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSAUTHWS) violated

    Statement: INSERT INTO PSAUTHWS (CLASSID, IB_OPERATIONNAME, AUTHORIZEDACTIONS) SELECT A.CLASSID,'CI_MI_PERSONAL_CI_G', A.AUTHORIZEDACTIONS FROM PSAUTHBUSCOMP A WHERE A.BCNAME=:1 AND A.BCMETHOD=:2

    Original Statement: INSERT INTO PSAUTHWS (CLASSID, IB_OPERATIONNAME, AUTHORIZEDACTIONS) SELECT A.CLASSID,'CI_MI_PERSONAL_CI_G', A.AUTHORIZEDACTIONS from PSAUTHBUSCOMP A where A.BCNAME=:1 and A.BCMETHOD=:2
    PSAPPSRV.1540 (4340) [10/23/12 16:28:27 PS@116.202.184.205 (CHROME 22.0.1229.94; WIN7) ICPanel](0) SQL error in Exec. (2,280) PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Name:InheritCIPermissions PCPC:1279 Statement:17

    Called from:PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Name:processoperations Statement:247

    Called from:PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Statement:288
    PSAPPSRV.1540 (4350) [10/23/12 16:37:29 PS@116.202.184.205 (CHROME 22.0.1229.94; WIN7) ICPanel](0) SQL error. Function: SQLExec

    Error Position: 0

    Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSAUTHWS) violated

    Statement: INSERT INTO PSAUTHWS (CLASSID, IB_OPERATIONNAME, AUTHORIZEDACTIONS) SELECT A.CLASSID,'CI_MI_PERSONAL_CI_G', A.AUTHORIZEDACTIONS FROM PSAUTHBUSCOMP A WHERE A.BCNAME=:1 AND A.BCMETHOD=:2

    Original Statement: INSERT INTO PSAUTHWS (CLASSID, IB_OPERATIONNAME, AUTHORIZEDACTIONS) SELECT A.CLASSID,'CI_MI_PERSONAL_CI_G', A.AUTHORIZEDACTIONS from PSAUTHBUSCOMP A where A.BCNAME=:1 and A.BCMETHOD=:2
    PSAPPSRV.1540 (4350) [10/23/12 16:37:29 PS@116.202.184.205 (CHROME 22.0.1229.94; WIN7) ICPanel](0) SQL error in Exec. (2,280) PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Name:InheritCIPermissions PCPC:1279 Statement:17

    Called from:PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Name:processoperations Statement:247

    Called from:PSSERVICESWRK3.IB_CIPERFORMACT.FieldChange Statement:288
  • 24. Re: Generate SOAP Template
    857877 Newbie
    Currently Being Moderated
    but still data is not reflecting .......................Hakan .............kindly suggest ............what i need to do now .................



    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Body>
    <m24:Get__CompIntfc__MI_PERSONAL_CIResponse xmlns:m24="http://xmlns.oracle.com/Enterprise/Tools/schemas/M1021871.V1">
    <m24:EMPLID>KU0090</m24:EMPLID>
    <m24:NAME/>
    <m24:PHONE/>
    <m24:ADDRESS1/>
    <m24:EMAILID/>
    <m24:CITY/>
    <m24:STATE/>
    <m24:ZIP/>
    <m24:MAR_STATUS/>
    <m24:CONTACT_NAME/>
    </m24:Get__CompIntfc__MI_PERSONAL_CIResponse>
    </soapenv:Body>
    </soapenv:Envelope>
  • 25. Re: Generate SOAP Template
    857877 Newbie
    Currently Being Moderated
    Dear Hakan,

    I am waiting for your feedback. Data is not reflecting .
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Body>
    <m24:Get__CompIntfc__MI_PERSONAL_CIResponse xmlns:m24="http://xmlns.oracle.com/Enterprise/Tools/schemas/M1021871.V1">
    <m24:EMPLID>KU0090</m24:EMPLID>
    <m24:NAME/>
    <m24:PHONE/>
    <m24:ADDRESS1/>
    <m24:EMAILID/>
    <m24:CITY/>
    <m24:STATE/>
    <m24:ZIP/>
    <m24:MAR_STATUS/>
    <m24:CONTACT_NAME/>
    </m24:Get__CompIntfc__MI_PERSONAL_CIResponse>
    </soapenv:Body>
    </soapenv:Envelope>
  • 26. Re: Generate SOAP Template
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    Do you provide a userid, password in your request? Please post you request message.

    Can you access the component with the userid, password you supply in your request? Does it return data in the component with the keys you supply in your search page eg. request?
    Which component are you using by the way?

    Could be that your are hitting row level security?
    If the component resides in several menu's, each menu can override the searchrecord.
    Could be that your CI is set to a menu with row level security and you are accessing it online through a menu without row level security.

    Please answer the questions above, so we can move forwards.

    Regards,

    Hakan
  • 27. Re: Generate SOAP Template
    857877 Newbie
    Currently Being Moderated
    Question :- Do you provide a userid, password in your request? Please post you request message

    Answer :- No. In My component there is no provision of giving user-id and Password.


    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:m24="http://xmlns.oracle.com/Enterprise/Tools/schemas/M243680.V1">
    <soapenv:Header/>
    <soapenv:Body>
    <m24:Get__CompIntfc__MI_PERSONAL_CI>
    <m24:EMPLID>?</m24:EMPLID>
    </m24:Get__CompIntfc__MI_PERSONAL_CI>
    </soapenv:Body>
    </soapenv:Envelope>


    Question :- Can you access the component with the userid, password you supply in your request? Does it return data in the component with the keys you supply in your search page eg. request? Which component are you using by the way?

    Answer :- In PIA, my user-id ( PS ) has an assign an ID. the data is getting displayed by picking that ID. Yes, it return the data. My compoent name MI_PERSONAL_CI.


    Question :- Could be that your are hitting row level security?

    Answer :- I am not sure on it.


    Question :- If the component resides in several menu's, each menu can override the searchrecord.

    Answer :- all are custom component . in other component several menu's are present. But, MI_PERSONAL_CI do not have several menu's


    Question :- Could be that your CI is set to a menu with row level security and you are accessing it online through a menu without row level security.

    Answer :- I am not sure of it. How would i check it
  • 28. Re: Generate SOAP Template
    857877 Newbie
    Currently Being Moderated
    In other components like Payroll, I am not giving any user-id and Password. It is directly taking from ID assign to user-id ( PS )




    the body


    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:m96="http://xmlns.oracle.com/Enterprise/Tools/schemas/M961811.V1">
    <soapenv:Header/>
    <soapenv:Body>
    <m96:Get__CompIntfc__MS_EMP_PAY_INFO_PG/>
    </soapenv:Body>
    </soapenv:Envelope>


    and the o/p

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Body>
    <m96:Get__CompIntfc__MS_EMP_PAY_INFO_PGResponse xmlns:m96="http://xmlns.oracle.com/Enterprise/Tools/schemas/M989918.V1">
    <m96:NAME>Ray Sun</m96:NAME>
    <m96:DESCR>24/10/2012</m96:DESCR>
    <m96:AMT1>38423.077</m96:AMT1>
    <m96:AMT2>9605.769</m96:AMT2>
    <m96:AMT3>1613.769</m96:AMT3>
    <m96:AMT4>557.135</m96:AMT4>
    <m96:AMT5>0</m96:AMT5>
    <m96:AMT6>26646.4</m96:AMT6>
    </m96:Get__CompIntfc__MS_EMP_PAY_INFO_PGResponse>
    </soapenv:Body>
    </soapenv:Envelope>
  • 29. Re: Generate SOAP Template
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    First lets see if your component interface is working properly.
    Start Application Designer and open your component interface.
    Right click on the component interface and select Test.

    A second screen will start where you can run your CI in UI mode.
    Supply key values and click on Get.
    Do you get data?

Legend

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