MSC_HVGOP_CONFIGURATION
Table contains horizon configuration data.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_HVGOP_CONFIGURATION_PK |
CONFIGURATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| CONFIGURATION_ID | NUMBER | 18 | Yes | Unique identifier of the configuration | ||
| HORIZON_START | TIMESTAMP | Start of horizon for current horizon | ||||
| BUCKETS_PER_HORIZON | NUMBER | 10 | This column indicates the number of buckets per horizon. | |||
| BUCKET_DURATION | NUMBER | 10 | Duration of bucket for current configuration | |||
| TIME_PERIODS_PER_BUCKET | NUMBER | 10 | Time periods per bucket for current horizon | |||
| MAX_TIME_PERIODS_PER_TABLE_ROW | NUMBER | 10 | Maximum time periods per table row for current horizon | |||
| MAX_IN_MEM_DEPENDENCY_GROUPS | NUMBER | 10 | Maximum in memory dependency groups | |||
| MAX_IN_MEM_INVENTORY_PROFILES | NUMBER | 10 | Maximum in memory inventory profiles | |||
| LOCK_CONFLICT_MAX_WAIT | NUMBER | 10 | Lock conflict maximum wait time for inventories | |||
| LOCK_CONFLICT_ITERATION_WAIT | NUMBER | 10 | Lock conflict iteration wait for inventories | |||
| IS_HARD_CONSTRAINED_LOCKING | VARCHAR2 | 1 | Check to validate if hard contrained locking is enabled | |||
| DATA_SOURCE | VARCHAR2 | 20 | Field to determine the type of data soource | |||
| CONFIGURATION_NAME | VARCHAR2 | 80 | Name of the gop re-arch configuration | |||
| CONFIGURATION_DESCRIPTION | VARCHAR2 | 240 | Description of the gop re-arch configuration | |||
| 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. | |||
| DEFAULT_TIMEZONE_CODE | VARCHAR2 | 64 | Default timezone code used for org/customer/supplier if explicit timezone not defined | |||
| GENERATE_REPLAY_DATASET | VARCHAR2 | 1 | Enable the replay functionality to generate one replay dataset per each Promising Request | |||
| REPLAY_DATASET_LIFESPAN | NUMBER | 3 | The duration in hours for keeping previously generated replay datasets | |||
| ZOMBIE_LOCK_LIFESPAN | NUMBER | 3 | If a thread process terminates unexpectedly and if it has already acquired some locks then these locks will be left without an owner. As a result there is no other thread/process that can release these locks. If these leftover locks remain set for a duration longer than the Zombie Lock Lifespan than they get considered as zombie locks and will be cleaned up automatically at first opportunity when the engine try to acquire locks for the same inventory key | |||
| TIME_PERIOD_TOLERANCE | NUMBER | 3 | Used for upstream search time period adjustment | |||
| CACHED_INVKEY_LIFESPAN | NUMBER | 3 | Threshold number of days after which we give up the cache supply demand and consumption events and do recomputation during first promising for the inventory key | |||
| LAST_SUPDEM_TARGET_COLL | DATE | Indicates when last target collection ran for supplies and demands. This column is populated by collection flow. If this date is later than the latest update time of specific value from MSC_HVGOP_IAP table then specific_value cache is stale and needs to be recomputed. Null value indicates that cache needs to be recomputed. | Obsolete | |||
| LAST_ATP_RULE_UPDATE | DATE | Indicates the time when last update was made to ATP rule definition or ATP rule assignments. This column is populated by collection flow and user interface. If this date is later than the latest update time of ATP Rules from MSC_HVGOP_IAP.LATEST_ATP_RULE_UPDATE then ATP Rule cache is stale and needs recomputation. Null value indicates that cache needs to be recomputed | ||||
| LAST_DEPENDENCY_UPDATE | DATE | Indicates the time when last update was made to (1) Sourcing rule definition or (2) Sourcing rule assignments or (3) Bill of Resources. This column is populated by collection flow and user interface. If this date is later than the latest update time of Sourcing Rules or Bill of Resource from MSC_HVGOP_IAP.LATEST_DEPENDENCY_UPDATE then dependency cache is stale and needs recomputation. Null value indicates that cache needs to be recomputed | ||||
| LAST_SUP_TARGET_COLL | DATE | Indicates when last target collection ran for supplies. This column is populated by collection flow. If this date is later than the latest update time of specific value from MSC_HVGOP_IAP table then specific_value cache is stale and needs recomputation. Null value indicates that cache needs to be recomputed. | ||||
| LAST_DEM_TARGET_COLL | DATE | Indicates when last target collection ran for demands. This column is populated by collection flow. If this date is later than the latest update time of specific value from MSC_HVGOP_IAP table then specific_value cache is stale and needs recomputation. Null value indicates that cache needs to be recomputed. | ||||
| ENABLE_SYNC | NUMBER | 1 | This column indicates that synchronization is Enabled / disabled for order. | |||
| SYNC_INTERVAL | NUMBER | This column indicates synchronization interval in minutes which will be used for sync to trigger. | ||||
| DISABLE_SUPPLIER_CAPACITY | NUMBER | 1 | This column indicates if the supplier capacity is enabled or disabled. Value 1 means the GOP does not consider the Supplier Capacity. Value 2/Null means GOP considers the Supplier Capacity. | |||
| ENABLE_SOURCE_SIDE_SOLVER | NUMBER | 1 | This column indicates if the source side solver is enabled or disabled. Value 1 means enable Source Side Solver. Value 2/NULL means disable Source Side Solver. | |||
| PLAN_LIST | VARCHAR2 | 500 | This column holds the comma separated plan_id values used for NewGOP Plan integration. | |||
| PLAN_LIST_LAST_UPDATE_DATE | TIMESTAMP | This column holds the timestamp to capture the time when the MSC_HVGOP_CONFIGURATION.PLAN_LIST is modified | ||||
| LAST_BOR_DEPENDENCY_UPDATE | DATE | Indicates the time when last update was made to Bill of Resources. This column is populated by collection flow and user interface. If this date is later than the latest update time of Bill of Resource from MSC_HVGOP_IAP.LATEST_BOR_DEPENDENCY_UPDATE then dependency cache is stale and needs recomputation. Null value indicates that cache needs to be recomputed. | ||||
| LOG_LEVEL | VARCHAR2 | 10 | Indicates the log level set by NewGOP engine, generally used for development for filtering the log messages. Valid values are: FINE, FINER, FINEST, SEVERE and WARNING. Null value indicates that NewGOP engine doesn't set any explicit log level. Null value should be the default value for Production. | |||
| BOR_SIMULATION_SET_ID | VARCHAR2 | 500 | This column stores the value of Simulation Set ID(s) which will be used by HVGOP while promising MAKE considering BOR. | |||
| LAST_ALLOC_RULE_UPDATE | DATE | Indicates the time when last update was made to Allocation rule definition or Allocation rule assignments. This column is populated by collection flow and user interface. If this date is later than the latest update time of Allocation Rules from MSC_HVGOP_IAP.LATEST_UPDATE then Allocation Rule cache is stale and needs recomputation. Null value indicates that cache needs to be recomputed | ||||
| ALLOC_ATTR_TIER1_ID | NUMBER | Unique Identifier for Allocation attribute at Tier 1 | ||||
| ALLOC_ATTR_TIER2_ID | NUMBER | Unique Identifier for Allocation attribute at Tier 2 | ||||
| ALLOC_ATTR_TIER3_ID | NUMBER | Unique Identifier for Allocation attribute at Tier 3 | ||||
| DEMAND_EXPIRY_DAYS | NUMBER | 3 | Days beyond which abandoned shopping carts will expire and their supply will be made available for new orders. | |||
| DEMAND_SOURCE_TYPE | VARCHAR2 | 30 | The source system from where the quote or shopping cart demand originates. | |||
| ITF_AT_GOP_HORIZON | NUMBER | Indicates whether GOP solver will infer Infinite Time Fence at GOP Horizon. 1 or NULL - Yes 2 - No | ||||
| GENERATE_STATISTICS | NUMBER | Enable generation of statistics data for promising request. 1 - Enabled 2/Null - Disabled. | ||||
| STATISTICS_LIFESPAN | NUMBER | 3 | The duration in hours for keeping previously generated statistics data. If life span is 0 then we will truncate the table(msc_hvgop_statistics). | |||
| PTP_ENABLED | NUMBER | Indicates whether PTP functionality is being used. | ||||
| MFG_ENABLED | NUMBER | Indicates whether manufacturing functionality is being used. | ||||
| ALLOC_ENABLED | NUMBER | Indicates whether allocation functionality is being used. | ||||
| CUTOVER_DATE | DATE | Indicates the date when customer was transitioned to HVGOP. | ||||
| RES_AVAIL_AFTER_COMPONENTS | NUMBER | This column indicates if HVGOP solver need to consider resource availability after all components become available. Valid values : 1 (Yes), 2 (No/Default). | ||||
| LEAD_TIME_FOR_MFG | NUMBER | This column indicates whether lead times need to be considered from BOR or from Item attributes. Valid values : 1 (BOR/Default), 2 (Item). |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_HVGOP_CONFIGURATION_U1 | Unique | FUSION_TS_TX_IDX | CONFIGURATION_ID |