FUN_WF_ACTIONS
This table contains data related to action(s) on rule.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FUN_WF_ACTIONS_PK |
ACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACTION_ID | NUMBER | 18 | Yes | Action identifier and primary key. | |
| RULE_ID | NUMBER | 18 | Yes | Foreign key reference identifier to the FUN_WF_RULES table. | |
| LIST_BUILDER_TYPE_CODE | VARCHAR2 | 128 | Yes | Type of list builder to route the approval task. | |
| RESPONSE_TYPE_CODE | VARCHAR2 | 128 | Yes | Represents whether the response type is required. Possible values are: Required and FYI. | |
| CALLABLE_FUNCTION | VARCHAR2 | 512 | Function name when assignment type is call operation. | ||
| CALLABLE_FUNCTION_ARGUMENTS | VARCHAR2 | 1000 | Comma separated list of arguments passed to a function that can be called. | ||
| APPROVAL_GROUP_NAME | VARCHAR2 | 512 | Name of the approval group used in the approval rule. | ||
| ALLOW_EMPTY_GROUP_FLAG | VARCHAR2 | 1 | Indicates whether empty approval group is allowed. | ||
| AT_LEAST_LEVELS | NUMBER | 18 | Least number of job levels required for an approval notification to flow through the job or position hierarchy. | ||
| AT_MOST_LEVELS | NUMBER | 18 | Highest job level required for an approval notification to flow through the job or position hierarchy. | ||
| AT_LEAST_RELATIVE_TO_CODE | VARCHAR2 | 64 | Least number of levels required for an approval notification to flow through the job or position hierarchy. These least number of levels are relative to job or position levels of the Creator, Absolute, and Starting point. | ||
| AT_MOST_RELATIVE_TO_CODE | VARCHAR2 | 64 | Highest level required for an approval notification to flow through the job or position hierarchy. This highest level is relative to job or position levels of the Creator, Absolute, and Starting point. | ||
| START_PARTICIPANT_FUNCTION | VARCHAR2 | 256 | Hierarchy provider function to build the hierarchy chain. | ||
| START_PARTICIPANT_USER | VARCHAR2 | 512 | The first participant in the hierarchy of approval chain. | ||
| START_PARTICIPANT_LB | VARCHAR2 | 64 | Type of list builder specified to build the hierarchy for approval chain. | ||
| START_PARTICIPANT_HIER_TYPE | VARCHAR2 | 128 | Type of hierarchy used to find the next level approver. | ||
| START_PARTICIPANT_START_DATE | TIMESTAMP | Start date as per the user time zone to find the first approver for an approval rule. | |||
| TOP_PARTICIPANT_FUNCTION | VARCHAR2 | 256 | Hierarchy provider function to build the hierarchy chain. | ||
| TOP_PARTICIPANT_USER | VARCHAR2 | 512 | Last user in the hierarchy list builder. | ||
| TOP_PARTICIPANT_LB | VARCHAR2 | 64 | Type of list builder specified to build the hierarchy for approval chain. | ||
| TOP_PARTICIPANT_HIER_TYPE | VARCHAR2 | 128 | Type of hierarchy used to find the top approver. | ||
| TOP_PARTICIPANT_START_DATE | TIMESTAMP | Start date as per the user time zone to find the first approver for an approval rule. | |||
| UTILIZED_PARTICIPANTS | VARCHAR2 | 128 | Determines how notification must flow in the job or position hierarchy. | ||
| RESOURCE_LB_USERS | VARCHAR2 | 1000 | Single user name or list of comma separated multiple users in the resource list builder. | ||
| RESOURCE_LB_APPLICATION_ROLE | VARCHAR2 | 1000 | Name of the application role in the resource list builder. | ||
| AUTO_ACTION_FLAG | VARCHAR2 | 1 | Indicates whether auto action is enabled. | ||
| AUTO_ACTION_CODE | VARCHAR2 | 64 | Action to be performed when auto action is enabled. | ||
| INCLUDE_MGR_AT_LAST_LEVEL_FLAG | VARCHAR2 | 1 | Indicator to specify if task should be routed to all the managers at the last level of approval cycle. | ||
| DIMENSION_ID | VARCHAR2 | 512 | Dimension identifier that denotes the functional object for which the approval rules is begin evaluated. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ACTION_TYPE_CODE | VARCHAR2 | 30 | Represents the type of action to be performed. | ||
| ACTION_ORDER | NUMBER | 9 | The order in which actions are stored for a rule. | ||
| ACTION_PARAMETERS | BLOB | Used for capturing additional details of an action. | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FUN_WF_ACTIONS | fun_wf_rules | RULE_ID |
| fun_wf_dataset_assignees | fun_wf_actions | ACTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_WF_ACTIONS_N1 | Non Unique | Default | RULE_ID, ACTION_ORDER, ORA_SEED_SET1 |
| FUN_WF_ACTIONS_N11 | Non Unique | Default | RULE_ID, ACTION_ORDER, ORA_SEED_SET2 |
| FUN_WF_ACTIONS_U1 | Unique | Default | ACTION_ID, ORA_SEED_SET1 |
| FUN_WF_ACTIONS_U11 | Unique | Default | ACTION_ID, ORA_SEED_SET2 |