Using the Oracle E-Business Suite Retrieve Objects activity

Use the Retrieve Objects activity to retrieve rows from the Oracle table. You can retrieve rows from flat tables/views that have a primary key defined.

About this task

Use this task to retrieve objects in the Oracle E-Business Suite application. The call to this activity is a synchronous call where the input data is sent to the activity for processing and the response is sent back to the orchestration.

Procedure

  1. In an active orchestration, open the Activities tab and expand the Oracle E-Business Suite folder contents.
  2. Drag the Retrieve Objects activity from the Oracle E-Business Suite folder onto the orchestration. The graphical representation of the orchestration, including the checklist is displayed.
  3. In the Checklist, click Summary.
  4. Review the contents of the Activity Name field, and make the required changes.
  5. In the Checklist, click Pick Endpoint.
  6. Click Browse and use the Project Explorer dialog box to select the relevant Oracle E-Business Suite endpoint.
  7. Optional: You can create the endpoint by clicking New and specifying the required connection details. Click OK to save and use the endpoint for this configuration.
  8. To make the required changes to the selected endpoint configuration, click Edit to access the options in a separate window. Any changes you make globally affects all uses of the endpoint in active orchestrations.
  9. In the Checklist, click Configure.
  10. Browse for the Oracle table/view name in the Oracle Table/View field.
  11. In Browse Oracle Database Tables/Views dialog:
    • Select a user schema from the Filter by user schema drop-down list.
    • Select either Tables or Views from Database object type.
    • Use Filter tables/views by name to filter the tables/views during selection.
    • Select a table/view.
  12. Click OK.
  13. In the Checklist, click Retry. Review the default settings and make the required changes. For more information, see Specifying Retry and Delivery options for Oracle E-Business Suite activities.
  14. Select the Map Inputs in the Checklist. The XML Schemas generated from the selected object of the Retrieve Objects activity are displayed as nodes under the request input parameter in the To Activity panel.
  15. Create a map between the orchestration variables and the input parameter of the activity.
    Note: Values must be provided at run time for any mandatory elements of the input structure. A value can be provided by specifying a default value for element or by linking the element with an input node. During run time if no value is provided for a mandatory element, the activity throws an exception, which is reported by the Web Management Console (WMC). If a value is not provided at run time for an optional input parameter, no exception is thrown during run time.
  16. Select the Map Outputs in the Checklist. The XML Schema generated to hold the response of the activity is displayed as nodes under the response output parameter in the From Activity panel. Create a map between the output parameters and orchestration variables.

Results

You have configured the Oracle E-Business Suite Retrieve Objects activity.



Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


https://www.ibm.com/support/knowledgecenter/en/SS3LC4_7.5.3/com.ibm.wci.doc/OracleEBS_retrieveobjects.html