Cross-Reference Lookup Web Service Example

The service operation EOTF_XREF_LOOKUP.v1 is used by external systems to look up a cross-reference value. For the external system to have access to the web service, it must be published on the PeopleSoft application.

See PeopleTools: PeopleSoft Integration Broker, Providing Services.

Example: Cross-Reference Map Definition

In this example, the third-party system requests a cross-reference lookup for payment terms. This page shows elements in the value map PaymentTermsGUID:

Image: Domain value map used in example

This example illustrates the fields and controls on the Domain value map used in example. You can find definitions for the fields and controls later on this page.

Domain value map used in example

Three elements are defined: UniqueGUID, SETID, and PYMNT_TERMS_CD.

This page shows the domains that are defined for the domain value map:

Image: Value Map - Domains page used in this example

This example illustrates the fields and controls on the Value Map - Domains page used in this example. You can find definitions for the fields and controls later on this page.

Value Map - Domains page used in this example

Two domains are defined for this map:

  1. UinqueGUID is the domain used by the third party; it contains the UniqueGUID element.

  2. PSFT represents the PeopleSoft application which contains the elements SETID and PYMNT_TERMS_CD.

Example: Web Service Request and Response

This is a sample request to obtain the PeopleSoft values for a common GUID value:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xref="http://xmlns.oracle.com/Enterprise/tools/schema/xrefLookupValue.v1">
   <soapenv:Header/>
   <soapenv:Body>
      <xref:xrefLookupValue needFault="true">
         <xref:mapname>PaymentTermGUID</xref:mapname>
         <xref:Values>
            <xref:domain>UniqueGUID</xref:domain>
            <!--1 or more repetitions:-->
            <xref:element name="UniqueGUID">9d266732-90e2-11dd-a062-96c8921a7858</xref:element>
         </xref:Values>
         <xref:targetDomain>PSFT</xref:targetDomain>
      </xref:xrefLookupValue>
   </soapenv:Body>
</soapenv:Envelope>

This is the response:

<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>
      <xrefResponse xmlns="http://xmlns.oracle.com/Enterprise/tools/schema/xrefResponse.v1">
         <status>Success</status>
         <responseValues>
            <domain>PSFT</domain>
            <element name="SETID">SHARE</element>
            <element name="PYMNT_TERMS_CD">CD01</element>
         </responseValues>
      </xrefResponse>
   </soapenv:Body>
</soapenv:Envelope>