1. Tables and Views for SCM
  2. EGO_VERSIONS_BATCH_THREADS

EGO_VERSIONS_BATCH_THREADS

EGO_VERSIONS_BATCH_THREADS stores information about the threads and their statuses which are populated by the Change Order Implementation ESS, New Item request Completion ESS and Version Effectivation ESS programs. This data is used to schedule the Change order lines, Complete the new item request lines (Approve the items) and activate the versions in a given commit cycle.

Details

  • Schema: FUSION

  • Object owner: EGO

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

EGO_VERSIONS_BATCH_TH_PK

THREAD_ID

Columns

Name Datatype Length Precision Not-null Comments
THREAD_ID NUMBER 18 Yes Unique identifier used to store the thread id of the version batch
VERSION_BATCH_ID NUMBER 18 Yes Version batch id of the thread to which it belongs to. This is a foreign key to the EGO_VERSIONS_BATCH table's primary key column
THREAD_NUMBER NUMBER 18 Yes Thread Number that will be used to group lines/versions
THREAD_STATUS NUMBER 3 Yes Status of the Thread. It can have values 0(Not Started),1(Started), 2(Completed),3 (Known Error), 4(Unknown error)
JOB_NUMBER NUMBER 9 Job Number associated with this thread
DEPENDENCY_FLAG VARCHAR2 5 Flag that tells if this thread has any dependents if 'Y'. If 'F' it tells if the thread is to be failed since the dependency thread had failed.
DEPENDENT_IDS VARCHAR2 2000 Comma separated list of thread numbers(NIR)/Change Line Ids(CO) on which current thread is dependent
SUB_REQUEST_ID NUMBER 18 ESS request id of the job that is going to process this thread.
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.
SERVER_NAME VARCHAR2 255 This field holds the name of the server in which the thread is processed.
ECID VARCHAR2 255 This field holds the unique identifier for the thread.

Foreign Keys

Table Foreign Table Foreign Key Column
EGO_VERSIONS_BATCH_THREADS ego_versions_batch VERSION_BATCH_ID

Indexes

Index Uniqueness Tablespace Columns
EGO_VERSIONS_BATCH_TH_PK Unique FUSION_TS_TX_DATA THREAD_ID
EGO_VERSIONS_BATCH_TH_U1 Unique FUSION_TS_TX_DATA VERSION_BATCH_ID, THREAD_NUMBER