This discussion is archived
1 Reply Latest reply: Jun 6, 2012 8:47 AM by 934622 RSS

Integration with Peoplesoft - Create Requisition in EBS through webservice

934622 Newbie
Currently Being Moderated
We have the following requirement - We have a VMS (Vendor Management System) built using Peoplesoft. We have customers who are using Oracle EBS, who login to our system in several ways. we are now trying to implement Oracle EBS and our customers integrating the data into their system. One way is iProc which is straight forward.

The second method is the customers are going to login to our system and they want to integrate the data into their system.

I would like to know if we have a webservice in EBS, which can consume data from Peoplesoft and create requisitions in EBS.


Thanks,
Asokan
  • 1. Re: Integration with Peoplesoft - Create Requisition in EBS through webservice
    934622 Newbie
    Currently Being Moderated
    1) Once searching on the integrations repository, click on Requisition Service (Internal Name: oracle.apps.po.services.poxrqerq.POXRQERQServices_DocStyle)
    2) This will open Java Details : Requisition Service
    3) Under the "Web Service - SOA Provider" check if the Web Service Status is set to "Generated" (else click on the Regenerate WSDL on the top right of the page). Click on View WSDL
    4) Navigate to the following XSD documents which have comprehensive comments under the relevant tags.

    http://<server>:<port>/webservices/SOAProvider/java/oracle/apps/po/services/poxrqerq/POXRQERQServices_DocStyle/?wsdl - WSDL link

    http://<server>:<port>/webservices/SOAProvider/java/oracle/apps/po/services/poxrqerq/POXRQERQServices_DocStyle/POXRQERQServices_DocStyle.xsd

    http://<server>:<port>/webservices/SOAProvider/java/oracle/apps/po/services/poxrqerq/POXRQERQServices_DocStyle/POXRQERQ_ABM.xsd

    http://<server>:<port>/webservices/SOAProvider/java/oracle/apps/po/services/poxrqerq/POXRQERQServices_DocStyle/POXRQERQ_ABO.xsd (Has the documentation)

    Please replace <server>:<port> to reflect each customer installation.

    Can be created a WSDL client proxy to invoke the WebService passing in the right XML confirming to the XSD or call it via other popular tools like SOAPUI.

Legend

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