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:
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](img/i-1de106ban-7ff3.png)
Three elements are defined: UniqueGUID, SETID, and PYMNT_TERMS_CD.
This page shows the domains that are defined for the domain value map:
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](img/i-1de106ban-7ff9.png)
Two domains are defined for this map:
UniqueGUID is the domain used by the third party; it contains the UniqueGUID element.
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>