Using the Oracle E-Business Suite Get Deleted Objects activity
Use the Get Deleted Objects activity to get the deleted
records from the Oracle table.
About this task
Use this task to get deleted records 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 Get Deleted 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.
Specify the Event Store name configured
in the Oracle database. The activity polls this Event Store for new
events.
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.
Create a map between the orchestration variables and the
input parameter of the activity.
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 Get Deleted
Objects activity.