DOO_PROCESS_STEPS_B
This table stroes the information about process step definition
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
DOO_PROCESS_STEPS_B_PK |
STEP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| STEP_ID | NUMBER | 18 | Yes | Unique identifier of the step in the process definition. | ||
| DOO_PROCESS_ID | NUMBER | 18 | Yes | Reference to the unique identifier of an orchestration process | ||
| DOO_PROCESS_VERSION | NUMBER | 18 | Yes | Version of the orchestration process. | ||
| SPLIT_UNIT_NAME | VARCHAR2 | 30 | Identifier for collection of steps that must be processed together when a split occurs. | |||
| PREVIOUS_VERSION_STEP_ID | NUMBER | 18 | Not used. | |||
| STEP_NUMBER | NUMBER | 9 | Yes | An identifier of an activity to be carried out in a fulfillment process. | ||
| SERVICE_ID | NUMBER | 18 | Reference to the Unique identifier of the task layer service | |||
| TASK_ID | NUMBER | 18 | Reference to the unique identifier of the task | |||
| DOO_SUB_PROCESS_ID | NUMBER | 18 | Reference to the unique identifier for a sub process | |||
| SUB_PROCESS_VERSION | NUMBER | 18 | Version of a process that is used as a sub process | |||
| STEP_TYPE | VARCHAR2 | 30 | Identifier that determines whether the step in an orchestration process definition will invoke a service, associate a sub process, or provide branching. | |||
| PARENT_STEP_NUMBER | NUMBER | 9 | Step number that current step depends upon in execution sequence. | |||
| REUSE_LABEL | VARCHAR2 | 80 | Not used. | |||
| STEP_FILTER_RLS_ID | VARCHAR2 | 128 | Unique identifier for rules or conditions defined to narrow down fulfillment lines that are processed by a specific step of the process. | |||
| STEP_FILTER_RLS_NAME | VARCHAR2 | 256 | Rules or conditions defined to narrow down fulfillment lines that are processed by a specific step of the process. | |||
| MANUAL_STEP_FLAG | VARCHAR2 | 1 | Indicates that this step needs to be executed manually by user. | |||
| COMP_PATTERN_RLS_ID | VARCHAR2 | 128 | Rule name that specifies how to compensate a process when the change order is received. | |||
| COMP_PATTERN_RLS_NAME | VARCHAR2 | 256 | Rule name that specifies how to compensate a process when the change order is received. | |||
| CHECK_WITH_FS_BEFORE_CHANGE | VARCHAR2 | 1 | Signals the system to send a message to the fulfillment system before change processing | |||
| LEAD_TIME_RLS_ID | VARCHAR2 | 128 | Unique identifier for expression that can be evaluated to calculate the duration of the step. | |||
| LEAD_TIME_RLS_NAME | VARCHAR2 | 128 | Expression that can be evaluated to calculate the duration of the step. | |||
| DEFAULT_LEAD_TIME | NUMBER | Duration of the step. | ||||
| DEFAULT_LEAD_TIME_UOM | VARCHAR2 | 30 | Unit of measure for the lead time. | |||
| CUSTOMER_LAST_STEP_FLAG | VARCHAR2 | 1 | Identifies that completion of this step can denote fulfillment of the lines has been carried out. | |||
| SPLITABLE_FLAG | VARCHAR2 | 1 | Task Split Flag provides the configuration capability during the process definition to specify whether the step/task can split or not | |||
| SWITCH_RLS_ID | VARCHAR2 | 128 | Reference to a unique identifier for a condition used to branch the execution of steps. | |||
| SWITCH_RLS_NAME | VARCHAR2 | 128 | Condition used to branch the execution of steps. | |||
| SWITCH_CONDITION_EVAL_SEQ | NUMBER | 9 | Defines the sequence that is used in determining order of condition evaluation. | |||
| DEFAULT_BRANCH_FLAG | VARCHAR2 | 1 | In the case of a conditional branch, this is the default path that the system considers for planning purposes. | |||
| DEFAULT_EXIT_STATUS_CODE | VARCHAR2 | 30 | Identifies the status that the task will achieve when the given step is completed. | |||
| EXIT_CRITERIA_STATUS_CODE | VARCHAR2 | 256 | Identified status of the task that completed the wait. For example, if the system is waiting for shipping to be completed, then the status specified in this field is used to decide when to end the wait for shipping. | |||
| USE_DYNAMIC_ATTR_IN_DELTA_COMP | VARCHAR2 | 1 | Indicates that all dynamic (item-specific) attributes of original version of order will be compared with all attributes of new version while processing change order request. | |||
| USE_FLEX_ATTR_IN_DELTA_COMP | VARCHAR2 | 1 | Indicates that all flexfield attributes of original version of order will be compared with all attributes of new version while processing change order request. | |||
| HOLD_ON_WAIT | VARCHAR2 | 1 | Indicates that this step should be held while waiting for the response from fulfillment system. | |||
| 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_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. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| OTHERWISE_FLAG | VARCHAR2 | 1 | Identifies the branch that should be executed if all branching conditions are false | |||
| START_AFTER_COND_RLS_ID | VARCHAR2 | 128 | Surrogate key that identifies a row in this table | |||
| START_AFTER_COND_RLS_NAME | VARCHAR2 | 256 | Start After Condition User Defined name | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| START_DATE_ACTIVE | DATE | Indicates lower end of the active date range for this row. | ||||
| END_DATE_ACTIVE | DATE | Indicates upper end of the active date range for this row. | ||||
| SUB_PROCESS_IDENTIFIER | NUMBER | 18 | Reference to the identifier of a sub process. The effective version of this process will be used at runtime. | |||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Orchestration Process Step Information (DOO_PROCESS_STEPS_ADD_INFO) | |||
| ORCHESTRATION_APP_ATTRIBUTE1 | NUMBER | 18 | This is the Custom column to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE2 | NUMBER | 18 | This is the Custom column to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE3 | VARCHAR2 | 256 | This is the Custom column to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE4 | VARCHAR2 | 256 | This is the Custom column to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE5 | VARCHAR2 | 256 | This is the Custom column to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE6 | VARCHAR2 | 256 | This is the Custom column to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE7 | VARCHAR2 | 256 | This is the Custom column to store product specific information. | |||
| ORCHESTRATION_APP_ATTRIBUTE8 | DATE | This is the Custom column to store product specific information. | ||||
| ORCHESTRATION_APP_ATTRIBUTE9 | DATE | This is the Custom column to store product specific information. | ||||
| ORCHESTRATION_APP_ATTRIBUTE10 | DATE | This is the Custom column to store product specific information. | ||||
| ORCHESTRATION_APP_ATTRIBUTE11 | DATE | This is the Custom column to store product specific information. | ||||
| UPDATE_SERVICE_ID | NUMBER | 18 | This is the column to store service id for operation mode (UPDATE/CANCEL) from DOO_SERVICE_DEFINITIONS_B table. | |||
| CANCEL_SERVICE_ID | NUMBER | 18 | This is the column to store service id for operation mode (UPDATE/CANCEL) from DOO_SERVICE_DEFINITIONS_B table. | |||
| HOLD_SERVICE_ID | NUMBER | 18 | This is the column to store service id for operation mode (UPDATE/CANCEL) from DOO_SERVICE_DEFINITIONS_B table. | |||
| ORCHESTRATION_APPLICATION_ID | NUMBER | 18 | Reference to the unique identifier of the Orchestration Application. | |||
| 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 |
|---|---|---|
| DOO_PROCESS_STEPS_B | doo_task_definitions_b | TASK_ID, ORCHESTRATION_APPLICATION_ID |
| DOO_PROCESS_STEPS_B | doo_service_definitions_b | SERVICE_ID, ORCHESTRATION_APPLICATION_ID |
| DOO_PROCESS_STEPS_B | doo_process_definitions_b | DOO_PROCESS_ID |
| DOO_PROCESS_STEPS_B | doo_process_definitions_b | DOO_SUB_PROCESS_ID |
| doo_activity_definitions_b | doo_process_steps_b | STEP_ID |
| doo_process_step_instances | doo_process_steps_b | STEP_ID |
| doo_aggregation_headers | doo_process_steps_b | STEP_ID |
| doo_process_steps_tl | doo_process_steps_b | STEP_ID |
| doo_step_dependencies | doo_process_steps_b | STEP_ID |
| doo_step_dependencies | doo_process_steps_b | PREVIOUS_STEP_ID |
| doo_step_dependencies | doo_process_steps_b | NEXT_STEP_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOO_PROCESS_STEPS_B_FK1 | Non Unique | Default | DOO_PROCESS_ID |
| DOO_PROCESS_STEPS_B_FK2 | Non Unique | Default | DOO_SUB_PROCESS_ID |
| DOO_PROCESS_STEPS_B_PK | Unique | Default | STEP_ID, ORA_SEED_SET1 |
| DOO_PROCESS_STEPS_B_PK1 | Unique | Default | STEP_ID, ORA_SEED_SET2 |