Configure Oracle E-Business Suite Adapter Operations Properties

Enter the Oracle E-Business Suite Adapter invoke operations property values for your integration.

Topics:

• What You Can Do from the Oracle E-Business Suite Adapter Operations Page

• What You See on the Oracle E-Business Suite Adapter Operations Page

• What You Can Do from Oracle E-Business Suite Adapter Operations - Add Filter Conditions Page

• What You See on the Oracle E-Business Suite Adapter Operations — Add Filter Conditions Page

What You Can Do from the Oracle E-Business Suite Adapter Operations Page

You can perform the following task on the Oracle E-Business Suite Adapter Operations page.

• Select a desired method name from the API you specified in the Web Services page.

What You See on the Oracle E-Business Suite Adapter Operations Page

The following table describes the key information on the Oracle E-Business Suite Adapter Operations page:

Element	Description
API	It displays the API name (such as OE_INBOUND_INT), you selected earlier in the Web Services page.
Methods	Select a desired method contained in the selected API. For example, PROCESS_ORDER 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. Please note that 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	This field appears 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. If the selected method is SUBMIT_CP_<internal name of the associated concurrent program>, this field and CRUD Operation (described in the next row) are not shown in this page.
CRUD Operation	If the selected method is an open interface table with Inbound direction, the available operations for your selection are: Create - This value is selected by default. It creates or adds new entries for the selected method in the open interface table. Read - It reads, retrieves, searches, or views existing data for the selected method in the open interface table. Update - It updates or edits existing entries for the selected method in the open interface table. Delete - It 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: What You See on the 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.
Service Status	This field 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, Administering Native Integration Interfaces and Services chapter, Oracle E-Business Suite Integrated SOA Gateway Implementation Guide.
Description	When a method is selected, it displays the selected method description information.

Configure Oracle E-Business Suite Adapter Operations — Add Filter Conditions Properties

You can optionally create the Oracle E-Business Suite Adapter filter conditions for the selected open interface in your integration if the selected CRUD Operation value for a method is ‘Read', 'Update', or 'Delete'.

Topics:

• What You Can Do from Oracle E-Business Suite Adapter Operations - Add Filter Conditions Page

• What You See on the Oracle E-Business Suite Adapter Operations — Add Filter Conditions Page

See: What You See on the Oracle E-Business Suite Adapter Operations Page.

What You Can Do from Oracle E-Business Suite Adapter Operations - Add Filter Conditions Page

You can perform the following task on the Oracle E-Business Suite Adapter Operations - Add Filter Conditions page.

• Create one or more filter conditions for the selected open interface method if desired. These conditions filter the endpoint data before it is passed to the associated REST service for your integration at runtime.

What You See on the Oracle E-Business Suite Adapter Operations — Add Filter Conditions Page

The following table describes the key information on the Oracle E-Business Suite Adapter Operations — Add Filter Conditions page:

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, Not Equals, Less Than, Less or Equal To, Greater Than, Greater or Equal To, In, and Not In. By default, “Equals” (=) should be selected. 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 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: What You See on the Oracle E-Business Suite Adapter Operations Page.