FOS_FLOW_INSTANCES
This table stores task information which includes the status of the task, the initiating event for which this task is waiting, and the target document number and corresponding agreement ftr task information. One row of this table will exactly map to one target document creation task.
Details
-
Schema: FUSION
-
Object owner: FOS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FOS_FLOW_INSTANCES_PK |
FLOW_INSTANCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FLOW_INSTANCE_ID | NUMBER | 18 | Yes | This is the primary key and its value is an application generated unique id. | |
| GROUP_ID | VARCHAR2 | 30 | Represents the identifier for a group of tasks that needs to be processed together during task reprocessing. | ||
| 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. | |
| EVENT_DATA_ID | VARCHAR2 | 100 | Yes | Represents the identifier of the event document that initiated the particular task. | |
| SYSTEM_ID | NUMBER | 18 | Yes | Identifies the source system of the event that triggers this task. | |
| TA_DOCUMENT_ID | NUMBER | 18 | Represents the document that is to be created as part of orchestration of this flow instance. | ||
| FLOW_TYPE | VARCHAR2 | 30 | Yes | Represents the type of the flow. Valid values are contained within the FOS_FLOW_TYPE_FOR_TASK lookup type. | |
| STATUS | VARCHAR2 | 30 | Yes | A status indicating the state of the task. Valid values are contained within the FOS_TASK_STATUS lookup type. | |
| DOCUMENT_FLOW_ASSIGNMENT_ID | NUMBER | 18 | Yes | This is a foreign key to the FOS_DOC_FLOW_ASSIGNMENT table. | |
| AGREEMENT_FTR_ID | NUMBER | 18 | Yes | This is a foreign key to the FOS_AGREEMENT_FTR_F table. | |
| AGREEMENT_PTR_ID | NUMBER | 18 | Yes | This is a foreign key to the FOS_AGREEMENT_PTR_F table. | |
| EVENT_DEFINITION_ID | NUMBER | 18 | Yes | This is a foreign key to the FOS_EVENT_DEFINITIONS_B table. | |
| PROCESS_BATCH_ID | NUMBER | 18 | A unique batch identifier used to represent a group of orchestration tasks that have been submitted for processing. | ||
| TAX_CALCULATION_STATUS | VARCHAR2 | 30 | Specifies the tax calculation status for the Financial Orchestration Task. Valid values are 'NEEDED', 'NOT_NEEDED', 'CALCULATED', 'ERROR'. | ||
| TASK_GROUP | VARCHAR2 | 200 | Used in the mediator which logically groups the tasks. | ||
| TASK_SEQUENCE | NUMBER | 6 | Used in the mediator for which the sequences will be generated for each group. | ||
| TASK_TYPE | VARCHAR2 | 100 | Identifies the task type. Task types are defined in the FOS_TASK_TYPE_B table. | ||
| TRANSACTION_TYPE | VARCHAR2 | 30 | Yes | Represents the transaction type of the task type. (E.g. AP invoice credit memo, trade in-transit issue) | |
| TARGET_SYSTEM_ID | NUMBER | 18 | The target system where this document was created. | ||
| TARGET_DOCUMENT_HEADER | VARCHAR2 | 100 | Contains the header number of the target document that was created by this task. | ||
| TARGET_DOCUMENT_LINE | VARCHAR2 | 100 | Contains the line number of the target document that was created by this task. | ||
| TARGET_DOCUMENT_DETAIL | VARCHAR2 | 100 | Contains the line detail information of the target document that was created by this task. | ||
| TARGET_DOCUMENT_HEADER_ID | NUMBER | 18 | Contains the header id of the target document that was created by this task. | ||
| TARGET_DOCUMENT_LINE_ID | NUMBER | 18 | Contains the line id of the target document that was created by this task. | ||
| TARGET_DOCUMENT_DETAIL_ID | NUMBER | 18 | Contains the detail id of the target document that was created by this task. | ||
| IMPORT_DATE | DATE | Stores the date at which the interface record was populated into transaction table. | |||
| ENTERPRISE_ID | NUMBER | 18 | Yes | Identifier of Enterprise, used for multi-tenancy partitioning. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FOS_FLOW_INSTANCES | fos_doc_flow_assignment | DOCUMENT_FLOW_ASSIGNMENT_ID |
| FOS_FLOW_INSTANCES | fos_event_definitions_b | EVENT_DEFINITION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FOS_FLOW_INSTANCES_N1 | Non Unique | Default | EVENT_DATA_ID, SYSTEM_ID, TA_DOCUMENT_ID, EVENT_DEFINITION_ID |
| FOS_FLOW_INSTANCES_N2 | Non Unique | Default | DOCUMENT_FLOW_ASSIGNMENT_ID |
| FOS_FLOW_INSTANCES_N3 | Non Unique | Default | EVENT_DEFINITION_ID |
| FOS_FLOW_INSTANCES_N4 | Non Unique | Default | TARGET_DOCUMENT_HEADER_ID |
| FOS_FLOW_INSTANCES_N5 | Non Unique | Default | PROCESS_BATCH_ID, GROUP_ID |
| FOS_FLOW_INSTANCES_N6 | Non Unique | Default | STATUS |
| FOS_FLOW_INSTANCES_N7 | Non Unique | Default | REQUEST_ID, PROCESS_BATCH_ID |
| FOS_FLOW_INSTANCES_N8 | Non Unique | Default | REQUEST_ID, TRANSACTION_TYPE |
| FOS_FLOW_INSTANCES_PK | Unique | Default | FLOW_INSTANCE_ID |