FUN_DOCIO_FLOWS_B_
This table provides information about the seeded input and output flows of the document. The input and output flows of the document are seeded by the respective products for all flows they intend to enable in the input and output of the document. This table serves as a persistent table that includes the seeded flows, detailed flow information, and associated default configuration values. Flow code must be specified for each document to be proceseed by the input and output of the document to determine the appropriate flow for execution.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FUN_DOCIO_FLOWS_B_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, FLOW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FLOW_ID | NUMBER | 18 | Yes | Identifies the unique identifier for the input and output flow of the document IO. | |
| FLOW_CODE | VARCHAR2 | 240 | Indicates the code of the input and output flow of the document. | ||
| PRODUCT_FAMILY | VARCHAR2 | 32 | Product family for the Document IO flow. | ||
| PRODUCT_CODE | VARCHAR2 | 32 | Product code for the Document IO flow. | ||
| BUSINESS_OBJECT | VARCHAR2 | 512 | Business object for the Document IO flow. | ||
| INTEGRATION_PATTERN_CODE | VARCHAR2 | 30 | Identifies integration pattern code. Valid values are from the lookup type ORA_FUN_DOCIO_INTEG_PATTERNS. | ||
| ADMIN_SUBMISSION_FLAG | VARCHAR2 | 1 | Indicates whether input and output flow of this document can be submitted by an administrator. | ||
| ON_DEMAND_PURGE_FLAG | VARCHAR2 | 1 | Indicates whether on demand purge is enabled. | ||
| AUTOMATIC_PURGE_FLAG | VARCHAR2 | 1 | Indicates whether automatic purge is enabled. | ||
| LOADER_DOCUMENT_STORE | VARCHAR2 | 250 | Document store for the Document IO flow. | ||
| RESOURCE_PLAN | BLOB | Resource plan for the Document IO flow. | |||
| ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether input and output flow of this document is active. | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | ||
| 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. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | 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. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_DOCIO_FLOWS_B_N1_ | Non Unique | Default | FLOW_ID |
| FUN_DOCIO_FLOWS_B_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, FLOW_ID |