MSC_APPS_INSTANCES
This tables stores the information of each connected Application instance.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
MSC_APPS_INSTANCES_PK |
INSTANCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INSTANCE_CODE | VARCHAR2 | 30 | Yes | Unique code assigned to each application instance | |
| DB_CONNECTIONS | NUMBER | Number of Database Connections. | |||
| PARALLEL_WORKERS | NUMBER | This value indicates the number of parallel workers that would collect the data during planning collections. | |||
| PROCESS_BATCH_SIZE | NUMBER | Number of Rows per Processing Batch | |||
| CACHED_ENTRIES | NUMBER | Cached Data Entries in Thousands | |||
| SHORT_INSTANCE_ID | NUMBER | 3 | Short instance identifier for the instance used for Planning collections. | ||
| CAL_DATES_GENERATION_FLAG | NUMBER | This flag is to determine whether this instance is enabled to generate calendar dates | |||
| PUBLISH_WEB_SERVICE | VARCHAR2 | 256 | Publish web service name that is used to publish the data. | ||
| NET_RES_AVAIL_CALC_FLAG | NUMBER | This flag is to determine whether this instane is enabled to generate net resource availability | |||
| DESCRIPTION | VARCHAR2 | 240 | Description of the oracle instance | ||
| SUBSCRIBE_WEB_SERVICE | VARCHAR2 | 256 | This value indicates the web service definition that needs to be subscribed. | ||
| ORDER_ORCH_TYPE | NUMBER | This flag indicates whether source system is enabled for order orchestration. | |||
| APPS_VER | NUMBER | Yes | Oracle Application version number | ||
| INSTANCE_TYPE | NUMBER | Type of the oracle application instance | |||
| DBS_VER | NUMBER | Yes | Version number of the associated DB | ||
| A2M_DBLINK | VARCHAR2 | 128 | Application to MSC's database link | ||
| M2A_DBLINK | VARCHAR2 | 128 | MSC to Application's database link | ||
| ENABLE_FLAG | NUMBER | Yes | Y/N Flag to indicate whether the site is currently active or inactive | ||
| LRID | NUMBER | Last refresh identifier of the collection program. | |||
| LRTYPE | VARCHAR2 | 1 | Last refresh type: C = for complete refresh, I = for incremental,P=Partial | ||
| APPS_LRN | NUMBER | Yes | Application instance's last refresh number | ||
| INSTANCE_ID | NUMBER | 18 | Yes | Applications' Instance Identifier | |
| 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. | |
| LCID | NUMBER | Last executed collection program number | |||
| ST_STATUS | NUMBER | Yes | The status of instance data in staging table | ||
| CLEANSED_FLAG | NUMBER | Yes | The data cleansing flag of the instance data | ||
| SOURCE_TIME_ZONE | VARCHAR2 | 64 | Yes | Time zone of the source system from where the data is collected. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| CURRENCY | VARCHAR2 | 3 | Currency associated with amounts | ||
| ASSIGNMENT_SET_ID | NUMBER | 18 | Unique Identifier of the assignment set | ||
| REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program. | |||
| SO_LRTYPE | VARCHAR2 | 1 | Refresh type performed for Sales order entity. | ||
| SO_TBL_STATUS | NUMBER | Flag indicates whether sales order is being collected currently. | |||
| LR_SOURCING_FLAG | NUMBER | refresh type of sourcing flag in last collections | |||
| COMPANY_ID | NUMBER | 18 | Unique id assigned to the company | ||
| SUMMARY_FLAG | NUMBER | Summary flag for the source instance used for planning collection. | |||
| SUMMARY_REFRESH_NUMBER | NUMBER | Summary refresh flag for the source instance used for planning collection. | |||
| COLLECTIONS_START_TIME | DATE | Stores the Collections Start time (when the snapshots are refreshed) | |||
| LAST_TGT_CONT_COLL_TIME | DATE | Last Collection time of Entities with Snapshot | |||
| SUPPLIES_LOAD_FLAG | NUMBER | Flag to indicate the status of ODS Load of Supplies | |||
| ALLOW_ATP_FLAG | NUMBER | Yes | Identifier for ATP able destination. | ||
| ALLOW_RELEASE_FLAG | NUMBER | Yes | Identifier for release enabled destination. | ||
| LBJ_DETAILS | NUMBER | Use osfm job details for scheduling | |||
| VALIDATION_ORG_ID | NUMBER | 18 | Validation organization ID specified while defining the instance. | ||
| RESOURCE_MASS_UOM | VARCHAR2 | 3 | This value indicates the UOM for Resource Mass. | ||
| RESOURCE_VOLUME_UOM | VARCHAR2 | 3 | This value indicates the UOM for Resource Volume. | ||
| PJM_ENABLED | VARCHAR2 | 1 | Flag to indicate whether or not Oracle Projects is implemented on the source | ||
| XREF_ENABLED | NUMBER | Flag indicating whether cross reference enabled for the business object collected from source system. | |||
| INSTANCE_NAME | VARCHAR2 | 80 | Name of the oracle application instance | ||
| PLANNING_ENABLED | NUMBER | Flag to indicate whether the instance is used by planning or not. 1 - Enabled; 2 - not Enabled; | |||
| PROD_DATA_HUB_ENABLED | NUMBER | Flag to indicate whether the instance acts as Product Data Hub or not. 1 - Enabled; 2 - not Enabled; | |||
| CUST_DATA_HUB_ENABLED | NUMBER | Flag to indicate whether the instance acts as Customer Data Hub or not. 1 - Enabled; 2 - not Enabled; | |||
| COLL_ITEMS_FROM_PROD_HUB | NUMBER | Flag to indicate whether Items and BOMs to be collected from Product Data Hub or not. 1 - Enabled; 2 - not Enabled; | |||
| COLL_FFL_FROM_OO_ENABLED | NUMBER | Flag to indicate whether Fulfillment Lines to be collected from Order Orchestration or not. 1 - Enabled; 2 - not Enabled; | |||
| COLL_CUST_REG_FROM_CUST_HUB | VARCHAR2 | 20 | Flag indicates whether TCA entities need to be collected. | ||
| RELEASE_TO_SCO_ENABLED | NUMBER | Flag to indicate whether the planning recomendations to be released to Supply Chain Orchestration or not. 1 - Enabled; 2 - not Enabled; | |||
| CENTRALIZED_FLAG | NUMBER | Flag to indicate whether the instance is centralized or decentralized Valid Values: 1 - Centralized; 2 - Decentralized | |||
| ACTIVATION_DATE | DATE | Date when changes to publish data process was applied | |||
| FREQUENCY | NUMBER | Time interval for running continuous collection. Frequency in minutes. | |||
| PROD_TCA_ENABLED | NUMBER | This flag indicates whether the source system is enabled for PIM and TCA. | |||
| ENABLE_EXT_DATA_SOURCE | NUMBER | Flag that indicates if External source data (CSV) is allowed for fusion source system. Not relevant for other types of instances. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| msc_tp_site_id_lid | msc_apps_instances | SR_INSTANCE_ID |
| msc_coll_parameters | msc_apps_instances | INSTANCE_ID |
| msc_tp_id_lid | msc_apps_instances | SR_INSTANCE_ID |
| msc_cc_collected_bo | msc_apps_instances | INSTANCE_ID |
| msc_apps_instance_nodes | msc_apps_instances | INSTANCE_ID |
| msc_coll_template_b | msc_apps_instances | INSTANCE_ID |
| msc_coll_cycle_status | msc_apps_instances | INSTANCE_ID |
| msc_xref_mapping | msc_apps_instances | SR_INSTANCE_ID |
| msc_instance_orgs | msc_apps_instances | SR_INSTANCE_ID |
| msc_mrgd_pl_b | msc_apps_instances | INSTANCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_APPS_INSTANCES_U1 | Unique | Default | INSTANCE_ID |
| MSC_APPS_INSTANCES_U2 | Unique | Default | SHORT_INSTANCE_ID |