1. Tables and Views for Financials
  2. FUN_STREAM_TYPES_B

FUN_STREAM_TYPES_B

This table contains mapping of functional processes with the specific business flow context.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FUN_STREAM_TYPES_PK

STREAM_TYPE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
STREAM_TYPE_ID NUMBER 18 Yes Functional process stream types unique identifier.
APPLICATION_ID NUMBER 18 Yes Reference identifier for the business application.
FLOW_NAME VARCHAR2 240 Purchase or sales transaction flow. Obsolete
PROCESS_NAME VARCHAR2 240 Yes Name of an automated business process.
STREAM_TYPE_CODE VARCHAR2 30 Yes The code for a business job stream.
MASTER_STREAM_FLAG VARCHAR2 1 Yes Identifies if a job represents a thematic collection of interrelated jobs.
PREPROCESS_TYPE_CODE VARCHAR2 30 Yes Process type executed before the stream (Java or PL/SQL).
PREPROCESS_PACKAGE VARCHAR2 240 Full path of the Java or PL/SQL package.
PREPROCESS_API VARCHAR2 240 Java method or PL/SQL procedure details.
NOTIFICATION_ROLE_CODE VARCHAR2 240 Role code for which a notification will be issued for a successful process.
NOTIFICATION_TYPE_CODE VARCHAR2 30 The type of process success notification, such as bell or bell and e-mail, provided to inform users.
NOTIFICATION_PROCESS_URL VARCHAR2 240 Notification task flow used to support bell notifications for a successful process.
ERROR_NOTIFICATION_ROLE_CODE VARCHAR2 240 Role code for which a notification will be issued for a failed process.
ERROR_NOTIFICATION_TYPE_CODE VARCHAR2 30 The type of process error notification, such as bell or bell and e-mail, provided to inform users.
ERROR_NOTIFICATION_PROCESS_URL VARCHAR2 240 Notification task flow used to support bell notifications for a failed process.
NOTIFICATION_FLAG VARCHAR2 1 The designation for the notification sent on the success or the failure of a business process.
INITIATION_EVENT VARCHAR2 30 The event which triggers this business process. Obsolete
COMPLETION_EVENT VARCHAR2 30 The event which is triggered when this business process completes successfully. Obsolete
ENABLED_FLAG VARCHAR2 1 Yes Indicates whether automation processing is enabled.
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.
RECORD_TYPE_CODE VARCHAR2 30 Code to indicate whether the record is migrated, seeded, or defined by the user.
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.

Indexes

Index Uniqueness Tablespace Columns
FUN_STREAM_TYPES_B_U1 Unique Default STREAM_TYPE_ID, ORA_SEED_SET1
FUN_STREAM_TYPES_B_U11 Unique Default STREAM_TYPE_ID, ORA_SEED_SET2
FUN_STREAM_TYPES_B_U2 Unique FUSION_TS_TX_DATA STREAM_TYPE_CODE, ORA_SEED_SET1
FUN_STREAM_TYPES_B_U21 Unique FUSION_TS_TX_DATA STREAM_TYPE_CODE, ORA_SEED_SET2