Use the Delete Objects activity to delete rows from the
Oracle table. You can delete rows from flat tables/views that have
a primary key defined.
About this task
Use this task to delete rows from 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
- In an active orchestration, open the Activities tab and expand the Oracle E-Business Suite folder contents.
- Drag the Delete Objects activity from the Oracle E-Business Suite folder onto the orchestration.
The graphical representation of the orchestration, including the checklist
is displayed.
- In the Checklist, click Summary.
- Review the contents of the Activity Name field, and make the required changes.
- In the Checklist, click Pick Endpoint.
- Click Browse and use the Project
Explorer dialog box to select the relevant Oracle E-Business Suite
endpoint.
- 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.
- 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.
- In the Checklist, click Configure.
- Browse for the Oracle table/view name in the Oracle Table/View field.
- 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.
- Click OK.
- 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.
- Select the Map Inputs in the Checklist. The XML Schemas generated from the selected
object of the Delete Objects activity are displayed
as nodes under the request input parameter in the To Activity panel.
- 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.
- 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 Delete Objects
activity.