Actions Category
The Actions category enables you to add assign, B2B, data stitch, healthcare, logger, map, note, notification, stage file, and wait actions to an integration.
Topics:
- Translate an EDI Document with the B2B Action
- Build Complex Assignment Statements with a Data Stitch Action
- Convert HL7 Messages with a Healthcare Action
-
Send Notification Emails During Stages of the Integration with a Notification Action
-
Process Files in Schedule Integrations with a Stage File Action
-
Delay Integration Processing for a Specified Time Period with a Wait Action
Assign Values to Scalar Variables in an Assign Action
You can assign values to scalar variables in integrations with an assign action.
Note:
-
Variables created inside a scope action or a looping action (for example, a for-each or while action) are not directly accessible outside the scope/looping action. To access the variables (local) outside a scope/looping action, create a global variable using an assign action above the scope/looping action. Assign the local variable to this global variable and then use it outside the scope/loop action.
-
Values cannot be assigned to other variable types, such as complex types.
-
Add an assign action to an integration in either of the following ways:
- On the side of the canvas, click
Actions
and drag the Assign action to the appropriate location.
- Click
at the location where you want to add the assign action, then select Assign.
The Configure Assign panel opens.
- On the side of the canvas, click
Actions
-
Click Edit
under Configure Assign to enter a name and optional description for the assign action.
-
Click the + sign, then select a data type:
- String: Create a string data type.
- Fault: Catch and aggregate faults in parallel processing actions in schedule integrations. This operation is only supported in schedule integrations.
- If you select String:
- Enter a string variable name or select an existing variable
from the list.
The Operations field defaults to an equal sign (=) and cannot be changed.
- Enter a value between the single quotes.
- Add more string variables, when needed.
- Enter a string variable name or select an existing variable
from the list.
- If you select Fault:
- Enter a fault variable name or select an existing fault from the list.
- Select an operation from the
Operation list.
- Append: Adds a new fault to the end of the fault list.
- Clear: Removes all entries in the fault list.
- If you selected Append, click
Edit
to select a fault from the mapper in the Value column. This option is not available with the Clear operation.
- Add more fault variables, as needed.
-
Click Save.
Variable assignments can be of great complexity. You can use assignments in switch actions and maps. For example, the upper branch of a switch action is taken (if $FetchContactAssign = "failed"), which processes a contactCreateProcessing scope. Otherwise, a contactUpdateSkip scope is processed.
You can also configure the primary tracking variable and both custom field tracking variables (update and access values). You can map tracking variables to output variables or create complex expressions for an assign or switch activity.
-
All tracking variables are of type string (all that assignments support).
-
All three tracking variable entries are present even if you choose not to model them. The name and XPath can be empty for tracking.
-
Editing or deleting the tracking variables only updates the name and XPath nodes in that particular tracking variable element.
-
The tracking variables have static names. Therefore, it is possible to set a tracking variable somewhere in the flow, but not initialize it with a value and a name in the Tracking dialog.
-
The primary tracking variable cannot be assigned any value in between the flow.
-
You cannot create a new variable with the same names as any of the statically name tracking variables.
- Retrieve the Name and IDs from Account Records with the queryMore Operation in Using the Salesforce Adapter with Oracle Integration 3
- Design a Basic Asynchronous CRUD Operation in Using the Oracle NetSuite Adapter with Oracle Integration 3
- Use the Extract API in a Schedule Integration in Using the SAP Concur Adapter with Oracle Integration 3
- Use the Pagination Concept in an Integration in Using the Jira Adapter with Oracle Integration 3
Translate an EDI Document with the B2B Action
You can translate a message to or from the Electronic Data Interchange (EDI) format in an integration with the B2B action.
The B2B action translates an incoming EDI document into an Oracle Integration XML message and an outgoing Oracle Integration XML message into an EDI X12 document.
Build Complex Assignment Statements with a Data Stitch Action
You can incrementally build a message payload from one or more existing payloads with the data stitch action. The data stitch action provides a Configure Stitch panel that enables you to assign values to variables.
The data stitch action supports scalar and complex type variables, arrays, and partial and full message payloads. Complex variables are not limited to message payloads.
The data stitch action differs from the mapper and assign action in the following ways:
Mapper and Assign Action Capabilities | Data Stitch Action Capabilities |
---|---|
Mapper: Only generates full message payloads. If you attempt to map into an existing message payload, a full replacement of that payload occurs. | Supports both partial and full replacement of the message payload. |
Assign action: Limited to scalar type variables. Complex objects or full payloads are not supported. | Supports both scalar and complex type variables. |
- Append: Appends at the end of the repeating/unbounded target element, the selected element, or the value. For example, you have an existing purchase order payload containing five lines and want to add a sixth line. The data stitch action enables you to append a sixth line to the existing array of lines in the purchase order.
- Assign: Places the selected value/element/attribute into the target element/attribute, overriding any existing data in the target element/attribute. For example, you want to change the current address in an existing purchase order. The data stitch action enables you to change the address. You can either map fields individually or copy the address object itself.
- Remove: Removes the target element/attribute from the variable. For example, you have an existing purchase order payload and want to remove the price to enable the end point application to calculate a new price. The data stitch action enables you to remove the price. For repeating/unbounded elements, all instances are removed unless a specific instance is selected by index or predicates.
- Add a data stitch action to an integration in either of the
following ways:
- On the side of the canvas, click Actions
and drag the Data stitch action to the appropriate location.
- Click
at the location where you want to add the data stitch action, then select Data stitch.
- On the side of the canvas, click Actions
-
Click Edit
under Configure Stitch to enter a name and optional description for the data stitch action.
- Click the Variable field and manually enter
a variable name, select a variable from the drop-down list, or click
Switch to Developer View
to open the Sources tree for dragging a variable name.
Global variables and business identifier tracking variables are displayed for selection. A data element is a subcomponent of a variable. A complex variable conforms to a series of data elements.
- From the Operation list, select the operation
to perform on the variable:
- Append
- Assign
- Remove
-
Click the Value field and specify a value in any of the following ways:If you selected the Remove operation, the Value field is not displayed.
- Entering manually.
- Selecting from the list.
- Clicking Switch to Developer
View
to open the Sources tree.
- Click + if you want to create additional complex assignment statements.
- When complete, click Save to save your
statements and close the Configure Stitch panel.
For this example, the following statement was created.
You can also define the sequence of variables to update. For example, if you want to copy an address, and then override a child element such as street, place these statements in the correct order of processing.
Convert HL7 Messages with a Healthcare Action
You can convert a message to or from HL7 format with a healthcare action in an integration. The healthcare action converts native inbound HL7 messages into Oracle Integration XML payloads for use in your integrations and generates native HL7 messages from Oracle Integration XML payloads to send to external applications that support HL7.
Note:
If your Oracle Integration instance does not include the Healthcare edition, you cannot drag the healthcare action into an integration. See Create an Oracle Integration Instance in Provisioning and Administering Oracle Integration 3.Log Messages with a Logger Action
You can log messages to the activity stream and diagnostic logs by adding the logger action at any point in the integration. You create a log message in the logger action that is a static message or variable-populated message.
Create a Logger Action
To create a logger action:
-
Add a logger action to an integration in either of the following ways:
- On the side of the canvas, click
Actions
and drag the Log action to the appropriate location.
- Click
at the location where you want to add the log action, then select Log.
The Configure Logger panel opens.
- On the side of the canvas, click
Actions
-
Click Edit
under Configure Logger to enter a name and optional description for the log action.
-
Select whether to always log this message or log it only when tracing is set to audit. You can enable tracing when you activate an integration. See Activate an Integration.
-
Specify a static or variable-populated message to be displayed in the activity stream and diagnostic logs. Drag elements from the Sources tree to create a message.
-
When complete, click Save. For this example, a log action is included in the integration.
Track the Status of a Logger Action During Runtime
During runtime, the messages in the loggers are written to the activity stream and diagnostic logs.
- In the navigation pane, click Observability, then Instances.
- Click the integration instance.
- Scroll through the activity stream.
-
Select Download
to download the logs.
-
Open the zip file and view the log messages you created.
Add Placeholder Notes with a Note Action
You can add placeholder notes similar to sticky notes to an integration. For example, you have not yet defined an invoke connection and want to add a placeholder note in the integration indicating that you plan to define the invoke connection later. Another integration developer reads that note and may add the invoke connection or the note reminds you to add the invoke connection at a later time when you again work on the integration.
Send Notification Emails During Stages of the Integration with a Notification Action
You can send a notification email to relevant users at specific points in the processing of an integration. You can set the to, from, and subject parts of an email. You can create the body part of an email using parameters defined in the Expression Builder. You can also add attachments to the email if your integration includes them. The total size limit on a notification email is 1 MB for Oracle Integration and 2 MB for Oracle Integration Generation 2. Both the email body and attachment are considered in calculating the total size.
When the email notification is received during integration runtime, the parameter
name
is replaced with a dynamic value.
Note:
-
Deleting the notification action does not impact downstream activities because a notification does not have any output. Changes in the upstream activities impact the notification when they are used either in the From, To, or Subject fields or in the body parameters. For example, if the
name
example used in this section is modified, the parameter assignment become invalid. -
Notification actions are treated as asynchronous actions with no failure. For example, assume you include a notification action in an integration and disable the sendmail service on your host, which prevents you from receiving an email notification. The integration instance appears as completed on the Instances page and there is no error message in the instance. This is the expected behavior. You can only see an issue with the instance if you open the integration instance and view the notification action.
Delay Integration Processing for a Specified Time Period with a Wait Action
The wait action enables you to delay the processing of an integration for a specified period of time. Use this action in schedule integrations, asynchronous integrations, synchronous integrations, and fire-and-forget integrations. A typical use for this action is to invoke a specific operation at a certain time. You can specify literal values or build XPath expressions that you can configure with property values during runtime.
Create a Wait Action
-
Add a wait action to an integration in either of the following ways:
- On the side of the canvas, click
Actions
and drag the Wait action to the appropriate location.
- Click
at the location where you want to add the wait action, then select Wait.
The Configure wait panel opens.
- On the side of the canvas, click
Actions
-
Click Edit
under Configure wait to enter a name and optional description for the wait action.
Configure the time to wait before processing the integration in either of two ways:
- If you want to use literal (hard coded) values:
-
Enter the number of seconds to wait before processing the integration. Literal values can only be in seconds, with no upper limit. The wait time cannot exceed the total running time of the integration.
-
- If you want to enter an XPath expression:
This option enables you to update a wait action parameter with an integration property value after the integration is activated. This update does not require a re-activation of the integration.
- Drag an element from the Input sources
section.
- Complete design of your integration and exit the integration canvas.
- Activate the integration.
- Hover your cursor over the integration, and select
Actions
, then select Update property values.
- Enter a value to use at runtime in the New value
field (for this example,
9
is entered). This value overrides the value provided in the Default value field.
- Run the integration and view the activity stream.
- Click View
for the action in front of the wait action (for this example, a logger action) and note that the integration property value is 9 and the wait action was initiated at 02:36:32 and the next action (for this example, a second logger action) was initiated at 02:36:41 (nine seconds later).
- Drag an element from the Input sources
section.
Track the Status of a Wait Action During Runtime
During runtime, you can track the status of the wait action on the Tracking page through the tracking diagram and activity stream for an activated integration.
- In the navigation pane, click Observability, then Instances.
-
Click the business identifier value of the integration to track.
The integration flow (including any wait actions) is displayed.
- Use the Extract API in a Schedule Integration in Using the SAP Concur Adapter with Oracle Integration 3
- Process RaaS Reports that Support the Delivery of Data in CSV Format in Using the Workday Adapter with Oracle Integration 3
- Export Candidate Data from Oracle Talent Acquisition Cloud (Taleo EE) in Using the Oracle Taleo Enterprise Edition Adapter with Oracle Integration 3