1. Tables and Views for SCM
  2. MSC_COLL_CYCLE_STATUS

MSC_COLL_CYCLE_STATUS

This table tracks the status of executing processes transactions on the destination server. The user interface and other user programs can determine the status of processes of interest by querying this table.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MSC_COLL_CYCLE_STATUS_PK

INSTANCE_ID, REFRESH_NUMBER

Columns

Name Datatype Length Precision Not-null Comments
INSTANCE_ID NUMBER 18 Yes This is the source instance for which the process was run .
ENTITY_LIST VARCHAR2 4000 This column holds the list if entities that are being collected for the corresponding collection cycle.
ESS_COLL_JOB_SET_REQ_ID NUMBER 18 Ess request id for the corresponding collection job set
ESS_CREATE_TREES_REQ_ID NUMBER 18 Ess request id for the corresponding create trees for dimension
ESS_AGGR_COLL_PLAN_REQ_ID NUMBER Request ID of the Aggregate Collected Planning Data job.
INSTANCE_CODE VARCHAR2 120 Unique code assigned to each application instance
REFRESH_NUMBER NUMBER 18 Yes This identifies the user transaction. Users would search on this to get status information on their transaction.
PROC_PHASE VARCHAR2 32 Yes This is the execution status. It could be Waiting, Processing, or Done.
STATUS VARCHAR2 32 Yes This is the status of the transaction. It will have the value NORMAL, if there is no error.
COLLECTION_CHANNEL VARCHAR2 32 Yes This identifies how the data was provided to the destination. Possible Values: PublicWS, FusionWS, Staged, RecoveryFile
COLLECTION_MODE VARCHAR2 32 Yes This identifies the mode of data update. It could be Incremental or Complete.
ORG_ID_LIST VARCHAR2 4000 Comma delimited list of transaction organization ids associated with the collection.
PIM_ORG_ID_LIST VARCHAR2 4000 Comma delimited list of pim organization ids associated with the collection.
CATEGORY_SET_NAME_LIST VARCHAR2 1000 Comma delimited list of Category Set Names associated with collection.
CONVERSION_RATE_TYPE_LIST VARCHAR2 1000 Comma delimited list of Conversion Rate types associated with collection.
PRICE_LIST VARCHAR2 1000 Comma delimited list of Price Lists associated with collection.
ORDER_TYPE_LIST VARCHAR2 1000 Comma delimited list of Order Types associated with collection.
CUSTOMER_CLASS_CODE_LIST VARCHAR2 1000 Comma delimited list of Customer Class Codes associated with collection.
COUNTRY_CODE_LIST VARCHAR2 1000 Comma delimited list of Country Codes associated with collection.
START_TIME TIMESTAMP Start time of the process. This is used in calculating the total time consumed by the process.
START_SCN NUMBER 18 The SCN for the time the process started. Used for rollback and consistent read.
LOAD_START_SCN NUMBER 18 This column stores the scn at which load process is started.
END_TIME TIMESTAMP Time when the collection process has finished
INPUT_GROUP_ID NUMBER Unique group id of the input records.
END_SCN NUMBER 18 The SCN for the time the process ended.
ENTITIES_EXPECTED NUMBER The number of entities that were expected to be sent by the source.
ENTITIES_PROCESSED NUMBER The current number of entities that have been processed.
RECORDS_PROCESSED NUMBER The total number of records processed.
DELAYED_RECORDS NUMBER These records could not be inserted immediately and will be retried later.
ERROR_RECORDS NUMBER The number of data error records. These records can be fixed up and retried.
SKIPPED_RECORDS NUMBER These records where skipped because the data contained was no longer relevant. (e.g. duplicate)
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.
CYCLE_SUMMARY CLOB Stores summary of records processed for each entity.
TIME_SUMMARY CLOB Stores summary of duration for processing each entity.
SALES_ORG_HIERARCHY VARCHAR2 1000 This column specifies Sales Organization hierarchy.
ESS_FLATFILE_LOAD_REQ_ID NUMBER 18 Ess request id of the Flat File load Program.
ORG_GROUP VARCHAR2 30 Name of the organization group selected for Concurrent Collection.
ESS_SCC_FLATFILE_REQ_IDS VARCHAR2 4000 This column holds the ESS Job IDs of CSV Upload submitted by SCC.
CSV_ORG_SPECIFIC_COLL NUMBER This columns specifies whether Organization Filter will be applied or not during CSV Target Collection. Valid values are 1(Yes), 2(No) and Null (same as No).
SHIP_CATEGORY_NAME_LIST VARCHAR2 1000 Comma delimited list of Category Set and Category Names associated with Shipment and Receiving history collection.
RETAIN_FCST_BY_DESIGNATOR NUMBER This column indicates whether target collection of demand forecasts will retain other designator data or not.
MULTIPLE_CSV_UPLOADS_FLAG NUMBER This column indicates whether current collection run is for Multiple CSV Uploads with Single Collection Job Set or not.

Foreign Keys

Table Foreign Table Foreign Key Column
MSC_COLL_CYCLE_STATUS msc_apps_instances INSTANCE_ID

Indexes

Index Uniqueness Tablespace Columns
MSC_COLL_CYCLE_STATUS_N1 Non Unique Default PROC_PHASE, STATUS, END_SCN, START_SCN, START_TIME
MSC_COLL_CYCLE_STATUS_U1 Unique Default REFRESH_NUMBER
MSC_COLL_CYCLE_STATUS_U2 Unique Default INSTANCE_ID, REFRESH_NUMBER