Non-Interactive Process Items

Process Flow Designer provides the following non-interactive process items:

Sequence. Fetches the value of a sequence to insert into an object.

Action. Executes an action on a data object.

CO Action. Executes an action on a conceptual object.

Mapping. Maps attributes from multiple items for an action on an object.

Custom Data. Provides users an option to execute a custom SQL query for retrieving data.

Custom Java. Provides users an option to execute a custom Java code as part of the process flow.

The following sections describe the properties for each of the non-interactive process items.

Sequence Process Item Properties

Sequence process items fetch the value of a sequence to insert into an object. Only database sequences are supported. This process item is within the process component.

Property	Description
Name	Name of the sequence item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters.
Sequence Logic	Logic or query for evaluating the next value of the sequence, for example, SELECT group_seq.NEXTVAL FROM DUAL.
Sequence Type	Type of Sequence. Only available for an SQL sequence.
Comments	Comments or description to be attached to the process item. Informational purposes only.

Action Process Item Properties

Action process items execute an action on a data object. This process item is within the process component

Property	Description
Name	Name of the action item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters.
Process Component	Process component from which data must be retrieved for the action.
Data Source Item	Form or DataGrid from which data is received for the action.
Data Object	Required. Data object on which to execute the action.
Action	Action to execute: Insert: Inserts the row into the data object. Update: Updates the corresponding row in the data object. Delete: Deletes the corresponding row in the data object.
Comments	Comments or description to be attached to the process item. Informational purposes only.

CO Action Process Item Properties

CO Action process items execute an action on a conceptual object. The CO Action process item is within the process component.

Property	Description
Name	General tab. Name of the CO action item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters.
Conceptual Object	Required. General tab. The conceptual object name on which to execute the action.
Comments	General tab. Comments or description to be attached to the process item. Informational purposes only.
Attribute	Mapping tab. List of all the objects constituting the conceptual object selected.
Components	Mapping tab. Component(s) to which these objects need to be mapped.
Item	Mapping tab. Items present in the selected component(s) to which these objects need to be mapped.

Mapping Process Item Properties

Mapping process items map attributes from multiple items for an action on an object. This process item is within the process component.

Property	Description
Name	General tab. Name of the mapping item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters.
Data Object	General tab. Data object from which the attributes are inherited. Required attribute.
Comments	General tab. Comments or description to be attached to the process item. Informational purposes only.
Attribute	Mapping tab. Attributes of the selected data object. Populated when the data object is selected.
Components	Mapping tab. Component to which Mapping Item attributes need to be mapped.
Item	Mapping tab. Items present in the selected component to which Mapping Item attributes need to be mapped.
Values	Mapping tab. Attributes present in the selected item to which Mapping Item attributes need to be mapped.
Auto Populate	Mapping tab. Once the component and item are selected, Auto Populate completes where the attribute item selected on the first row matches the data object attribute.

CustomData Process Item Properties

CustomData process items provide users with an option to execute a custom SQL query for retrieving data. This process item is within the process component.

Note: Process Flow Designer does not validate Java code defined in the SQL query when saving or updating the process flow. These validations are performed during the run-time of process flow hooks.

Property	Description
Name	General tab. Name of the custom data item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters.
Custom Data Type	General tab. Select Display Grid to display the resulting query. To use the resulting query as an input for subsequent steps, select Custom Dataset.
Selection Type	General tab. User selection option for the records displayed. Single: Provides radio button. Multi: Provides check boxes for multiple rows selection. This is only valid if Custom Data Type is Display Grid.
Comments	General tab. Comments or description to be attached to the process item. Informational purposes only. Optional.
SQL	SQL tab. SQL query for fetching the data from the table. The attributes in the SQL must be mapped to an alias that is defined in the Attribute tab. For example, Select name as NAME from city. In this SQL, you can also refer to dynamic values acquired in previous process components. The syntax is the same, for example, xyz = {ProcessComponentName#ProcessItemName#AttribueName}
Attribute	Attribute tab. Attributes that store the result of the SQL query that is passed to subsequent steps.
Delete	Attribute tab. To delete an attribute, if required. Click Add Attribute to add the attribute to delete.

CustomJava Process Item Properties

The CustomJava process item provides user an option to execute custom Java code as part of the process flow.

Process Flow Designer does not validate Java code when saving or updating the process flow. These validations are performed during the run-time of process flow hooks.

Property	Description
Name	General tab. Name of the custom java item. The name must be unique; the name can contain spaces or blanks, but cannot contain special characters.
Type	General tab. Select Execution if there is no branching involved after the Java source code is executed. Select Decision if the process flow has to be branched after the code is executed.
Comments	General tab. Comments or description to be attached to the process item. Informational purposes only. Optional.
Java Source Code	Java Source Code tab. Custom Java Code to be executed. For examples of Java code, see Process Flow Java Code Samples.
Attribute	Mapping tab. Attributes used in the Java source code for inputting and outputting data. For examples of Java code, see Process Flow Java Code Samples.
Components	Mapping tab. Components to which the custom Java item attributes are mapped.
Item	Mapping tab. Items present in the selected Component to which custom Java item attributes are mapped.
Values	Mapping tab. Attributes present in the selected item to which custom Java item attributes are mapped.