Oracle E-Business Suite Adapter Operations Page

Enter REST service operation or method information that you plan to use as an invoke in your integration.

Element Description

API

Displays the API name (such as “OE_INBOUND_INT”) that you selected earlier in the Web Services page.

Methods

Select a desired method contained in the selected API. For example, select “PROCESS_ORDER” as the method from the “OE_INBOUND_INT” API.

If the selected interface is an open interface (such as RAXMTR), a list of open interface tables contained in the selected open interface is displayed as the methods, along with the associated concurrent program submission method SUBMIT_CP_<internal name of the associated concurrent program> (such as “SUBMIT_CP_RAXMTR”) shown as the last entry in the table.

Note:

SUBMIT_CP_<internal name of the associated concurrent program> is only displayed for an open interface. This method will not be shown if the selected interface is an open interface view.

Direction (for Open Interfaces only)

Appears only if the selected interface is an open interface table or open interface view. It displays a read-only value (Inbound or Outbound) for the selected method of an open interface table or view.

Note:

If the selected method is SUBMIT_CP_<internal name of the associated concurrent program>, Direction and CRUD Operation (described in the next row) are not shown in this page.

CRUD Operation (for Open Interfaces only)

Appears only if the selected interface is an open interface table or open interface view.
  • If the selected method is an open interface table with Inbound direction, the available operations for your selection are:

    • Create (default): Creates or adds new entries for the selected method in the open interface table.

    • Read: Reads, retrieves, searches, or views existing data for the selected method in the open interface table.

    • Update: Updates or edits existing entries for the selected method in the open interface table.

    • Delete: Deletes or removes existing entries for the selected method in the open interface table.

    Note:

    If the selected operation value is Read, Update, or Delete, the Add Filter Conditions link appears. Clicking this link allows you to optionally create filter conditions for the selected method if desired in the Add Filter Conditions page. See: Oracle E-Business Suite Adapter Operations — Add Filter Conditions Page.
  • If the selected method is an open interface table or view with Outbound direction, Read is the only available operation and is automatically selected by default.

  • If the selected method is SUBMIT_CP_<internal name of the associated concurrent program>, this field is not shown.

Operation (for Java APIs only)

Appears only if the selected interface is a Java API. The available options for your selection are:

  • Create (default): Performs the HTTP “POST” action to the selected method in the Java API.
  • Read: Performs the HTTP “GET” action to the selected method in the Java API.
By default, you cannot perform Read operation on all Java methods. Only if HTTP “GET” is enabled for a desired method first, you can deploy that method with GET option in Oracle E-Business Suite and then can use Read operation from the Oracle E-Business Suite Adapter for an integration. Otherwise, you can use the Create operation for the same method if it is deployed as a REST operation in Oracle E-Business Suite. For information on deploying a Java API as a REST service with desired HTTP verbs, see:
  • Deploying REST Web Services, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide

  • "Annotations for Application Module Services" and "Annotations for Java Bean Services" in Java Annotations, Oracle E-Business Suite Integrated SOA Gateway Developer's Guide

Service Status

Displays the corresponding REST service status for the selected method.

  • Ready to Use

    This indicates that the selected method is deployed as a REST service and it is ready to use for your integration.

  • Not Deployed

    If the selected method is not deployed as a REST service, then Not Deployed is shown as the service status instead. Additionally a warning message appears, indicating that you must deploy the method as a REST service first before using it for your integration.

    To deploy the selected method as a REST service, you need to log in to Oracle E-Business Suite as a user who has the Integration Administrator role. Select the Integrated SOA Gateway responsibility and the Integration Repository link from the navigation menu. Search and locate the selected interface from the Integration Repository, and then deploy it as a REST service. Only when the REST service is available in Oracle E-Business Suite, you can then proceed to the process of adding Oracle E-Business Suite as a target connection.

    For information on deploying REST services, see Deploying REST Web Services, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide.

Description

Displays the selected method description information.

Oracle E-Business Suite Adapter Operations — Add Filter Conditions Page

You can optionally create filter conditions for a selected open interface in your integration if the selected CRUD Operation value for a method is Read, Update, or Delete. Use this feature to add conditions to only allow certain data to be passed in your integration.

Element Description

Element

Select a desired open interface table or view column from the drop-down menu. This returns the elements filtered by the text you selected. For example, select “QUANTITY_ORDER” as the filter text. Then only the column names with “QUANTITY_ORDER” will be retrieved.

Operator

Select an appropriate operator for your filter condition.

The available operation options are:

  • Equals (default)

  • Not Equals

  • Less Than

  • Less or Equal To

  • Greater Than

  • Greater or Equal To

  • In

  • Not In

For example, select “Greater Than” for the filter element “QUANTITY_ORDER”.

Value

Enter a literal value or a parameter in this field. For example, enter 1 for the filter element “QUANTITY_ORDER”.

If the value is a parameter or variable, add : (colon) before the parameter name as a prefix. For example, :BATCH_NUM would be a parameter whose value is determined at runtime.

Please note that the :BATCH_NUM parameter specified here will be available for mapping later at the design time and will be part of the input parameters in the schema (xsd) file generated for this integration.

AND/OR

If there are more than one filter conditions listed in the table, specify desired logical operator values (AND and OR) to associate with these conditions in the table.

To update an existing condition, select a desired condition that you want to edit first. The entered values become editable. To remove a filter condition entered earlier in the table, click the X icon next to the condition you want to remove. Click Detach to manage the filter conditions in a separate Detached Table page. Click Clear All to remove all the filter conditions listed in the table.

Click OK to save the filter conditions and return back to the Operations page. See: Oracle E-Business Suite Adapter Operations Page.