PowerExchange for Oracle E-Business Suite User Guide for PowerCenter

10.4.0
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5

Back Next

Custom Open Interfaces

You can import the custom open interface table as an Oracle E-Business Suite target definition. Before you import a custom open interface table, add the custom open interface to the InterfaceList.xml file.

InterfaceList.xml contains the open interfaces provided with Oracle E-Business Suite. The PowerExchange for Oracle E-Business Suite installer adds InterfaceList.xml to the <PowerCenter Installation Directory>\clients\powerCenterClient\client\bin directory.

The following table describes the elements required to add the custom open interface to InterfaceList.xml:

Element	Description
APPLICATION	Oracle E-Business Suite application that the open interface belongs to. An application can contain more than one open interface. The APPLICATION element contains APPLICATION_SHORT_NAME to represent the application name.
INTERFACE	Open interface in the application. The interface name appears in the list of open interfaces when you import an Oracle E-Business Suite target definition. INTERFACE contains the INTERNALNAME element, which is the name of the concurrent request.
TABLE	Interface tables in the open interface. TABLE contains the NAME element, which is the name of an interface table.

When you import a custom open interface to create a target definition, the Designer validates the open interface against ebizinterface.dtd. When you install PowerExchange for Oracle E-Business Suite, the installer adds ebizinterface.dtd to the <PowerCenter Installation Directory>\clients\PowerCenterClient\client\bin directory.

The following example shows the syntax for adding the AR TelecomInvoice custom open interface to InterfaceList.xml:

<APPLICATION NAME="AR">
<INTERFACE NAME="AR TelecomInvoice" INTERNALNAME="RATEL">
<TABLE NAME="AR_INTERFACE_LINES_ALL" />
<TABLE NAME="AR_INTERFACE_DISTRIBUTIONS_ALL" />
<TABLE NAME="AR_INTERFACE_SALESCREDITS_ALL" />
</INTERFACE>
</APPLICATION>

In this example, the open interface TI TelecomInvoice belongs to the Receivable application in Oracle E-Business Suite. The Receivable application is represented by the application name AR. The internal name of the open interface, RATEL, is the name of the concurrent request for the open interface. TI TelecomInvoice contains three tables defined under the TABLE element.

After you add the custom open interface to InterfaceList.xml, you can import the open interface as an Oracle E-Business Suite target definition.

Rename Saved Search

Table of Contents

PowerExchange for Oracle E-Business Suite User Guide for PowerCenter

PowerExchange for Oracle E-Business Suite User Guide for PowerCenter

Custom Open Interfaces

Custom Open Interfaces