EDR_TRANSACTION_TYPES_B
Base setup table for EDR transaction types. Defines which business transaction types participate in electronic record and electronic signature processing, including transaction type code, BPM task namespace, signature mode, BI report/template generation settings, attachment support, organization enablement behavior, and auto-approval behavior.
Details
-
Schema: FUSION
-
Object owner: EDR
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
EDR_TRANSACTION_TYPES_B_PK |
TRANSACTION_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_TYPE_ID | NUMBER | 18 | Yes | This is the primary key and its value is an application generated unique id. It is used to uniquely identify a transaction type. | |
| 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. | |
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifies the EDR transaction type code. This is the controlled setup business key for the transaction type and is used by EDR records, signature definitions, and related-event mappings to determine electronic record and signature behavior. Values are not free-form text. | |
| TRANSACTION_TYPE_SHORT_CODE | VARCHAR2 | 10 | Stores the short code for the EDR transaction type. Used as an abbreviated transaction type identifier for setup, display, integration, or reporting contexts. | ||
| BPM_TASK_NAMESPACE | VARCHAR2 | 1000 | Yes | Identifies the BPM human task namespace used to create or associate approval and electronic signature workflow tasks for this transaction type. | |
| BPM_COMPOSITE_NAME | VARCHAR2 | 100 | This is the name of the BPM SOA composite used by this transaction. | ||
| BPM_RULE_FILE_NAME | VARCHAR2 | 100 | This is the name of the BPM rule file that users configure for this transaction. | ||
| SIGNATURE_MODE | VARCHAR2 | 30 | Yes | Identifies when electronic signatures are captured for the transaction type. Source: lookup type ORA_EDR_SIGNATURE_MODE. Valid values are defined by ORA_EDR_SIGNATURE_MODE; current modes include INLINE = signatures are captured as part of the transaction flow and DEFERRED = signatures are captured after the transaction through a deferred signing task or workflow. | |
| BI_REPORT_PATH | VARCHAR2 | 1000 | Yes | Identifies the BI Publisher report path used to generate or render the electronic record output for this transaction type. This field supports electronic record output generation and should not be interpreted as a signature outcome or approval decision. | |
| BI_TEMPLATE_NAME | VARCHAR2 | 1000 | Identifies the BI Publisher template used with the configured report to generate or render the electronic record output for this transaction type. | ||
| BI_OUTPUT_FORMAT | VARCHAR2 | 30 | Yes | Identifies the BI Publisher output format used when generating or rendering the electronic record output for this transaction type. Values are controlled by supported BI Publisher output formats for the configured report and template. | |
| ENABLED_FOR_ALL_ORGS_FLAG | VARCHAR2 | 1 | Indicates whether this transaction type can be enabled for all organizations through supported EDR setup. Valid values: Y = the transaction type can be enabled for all organizations; N = the transaction type must be enabled selectively for specific organizations. | ||
| SUPPORTS_TXN_ATTACHMENTS_FLAG | VARCHAR2 | 1 | Flag that indicates if a transaction supports adding transaction attachments to an ERES task. | ||
| AUTO_APPR_DISABLED_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates if transaction supports AUTO_APPROVAL rule or not. | |
| 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. | ||
| 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 |
|---|---|---|
| edr_records | edr_transaction_types_b | TRANSACTION_TYPE_CODE |
| edr_related_event_mapping | edr_transaction_types_b | PARENT_TRANSACTION_TYPE_CODE |
| edr_related_event_mapping | edr_transaction_types_b | CHILD_TRANSACTION_TYPE_CODE |
| edr_signature_definitions | edr_transaction_types_b | TRANSACTION_TYPE_CODE |
| edr_transaction_types_tl | edr_transaction_types_b | TRANSACTION_TYPE_ID |
| edr_transaction_variables | edr_transaction_types_b | TRANSACTION_TYPE_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EDR_TRANSACTION_TYPES_B_N01 | Non Unique | Default | ENABLED_FOR_ALL_ORGS_FLAG |
| EDR_TRANSACTION_TYPES_B_U01 | Unique | Default | TRANSACTION_TYPE_ID, ORA_SEED_SET1 |
| EDR_TRANSACTION_TYPES_B_U011 | Unique | Default | TRANSACTION_TYPE_ID, ORA_SEED_SET2 |
| EDR_TRANSACTION_TYPES_B_U02 | Unique | Default | TRANSACTION_TYPE_CODE, ORA_SEED_SET1 |
| EDR_TRANSACTION_TYPES_B_U021 | Unique | Default | TRANSACTION_TYPE_CODE, ORA_SEED_SET2 |