MSC Tables (700)

MSC - Advanced Supply Chain Planning — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
MSC_ABC_CLASSES 11 This table describes the classification of inventory goods into class A, B, C class types.
MSC_ALLOCATIONS 35 This table describes the allocations
MSC_ALLOCATION_ASSIGNMENTS 32 This table describes the allocation assignments
MSC_ALLOCATION_RULES 23 This table describes the allocation rules
MSC_ALLOC_DEMANDS 30
MSC_ALLOC_RULE_TIME_PHASES 9 This table describes the time-phased allocation rules
MSC_ALLOC_SUPPLIES 29
MSC_AMONG_VALUES 12 User selected criteria for 10SC Planner Workbench
MSC_ANALYSIS_AGGREGATE 46
MSC_ANALYSIS_QUERY 25
MSC_ANSWERS 10 Stores the Answers for Ask Oracle Questions
MSC_APCC_ITEM_D 48
MSC_APPS_INSTANCES 64 This tables stores the information of each connected Application instance.
MSC_ASSIGNMENT_SETS 34 This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level.
MSC_ATP_DETAIL_PEG_TEMP 41
MSC_ATP_PARAMETERS 20 ATP related parameters storage
MSC_ATP_PEGGING 42
MSC_ATP_PEG_TEMP 43
MSC_ATP_PLAN_SN 7
MSC_ATP_RULES 65 This table stores rules and options that are used in Available To Promise computation.
MSC_ATP_SUMMARY_RES 15
MSC_ATP_SUMMARY_SD 17
MSC_ATP_SUMMARY_SO 17
MSC_ATP_SUMMARY_SUP 15
MSC_AVAILABLE_TO_PROMISE 18 Available to promise information for master scheduled parts
MSC_BILL_OF_RESOURCES 34 This table stores the set of resources required in an organization.
MSC_BIS_BUSINESS_PLANS 17 A business plan in this context is one of possibly many scenarios which set performance targets to particular values anticipated under that
MSC_BIS_INV_CAT_MV_TAB 19 KPI Summary Table
MSC_BIS_INV_DATE_MV_TAB 18 KPI Summary Table
MSC_BIS_INV_DETAIL 54 MSC_BIS_INV_DETAIL contains Inventory balance details collected from source applications.
MSC_BIS_PERFORMANCE_MEASURES 23 MSC_BIS_PERFORMANCE_MEASURES contains business performance measures collected from source applications.
MSC_BIS_PERIODS 29 MSC_BIS_PERIODS stores periods between the calendar start date and end dates.
MSC_BIS_RES_DATE_MV_TAB 12 KPI Summary Table
MSC_BIS_RES_SUMMARY 27 MSC_BIS_RES_SUMMARY stores resource required hours and available hours for BIS reports.
MSC_BIS_SUPPLIER_SUMMARY 18 MSC_BIS_SUPPLIER_SUMMARY Stores BIS Supplier Summaruy Entries
MSC_BIS_TARGETS 34 MSC_BIS_TARGETS stores the target values for the BIS reports.
MSC_BIS_TARGET_LEVELS 31 MSC_BIS_TARGET_LEVELS contains different combinations of dimension levels to be applied simultaneously to get a performance indicator releva
MSC_BOMS 45 This table represents the Bills Of Material of an item created at source applications.
MSC_BOM_BOD_INTERFACE 25 Interface table that contains the BOM/BOD data before validation
MSC_BOM_COMPONENTS 65 This table stores Bill of material data for plans in Oracle Advanced Planning and Oracle Supply Chain Hub products.
MSC_BOM_TEMP 16 BOM Temp Table
MSC_BOR_REQUIREMENTS 45 This table stores the set of resources required in an organization for an item.
MSC_BUDGETS_F 19
MSC_CALENDARS 24 MSC_CALENDARS stores the definition of your workday calendar.You can follow any of the four following type of quarters for your yearly calen
MSC_CALENDAR_DATES 39 MSC_CALENDAR_DATES stores every date between the calendar start date and calendar end date for the given calendar using a specified exceptio
MSC_CALENDAR_EXCEPTIONS 15 MSC_CALENDAR_EXCEPTIONS stores exception dates for a calendar. You can define these exception dates to be working or non-working days. The w
MSC_CALENDAR_SHIFTS 33 Workday calendar shifts
MSC_CAL_WEEK_START_DATES 17 This table stores the workday calendar weekly start dates
MSC_CAL_YEAR_START_DATES 14 Workday calendar yearly start dates
MSC_CAPACITY_PLANS 59 MSC_CAPACITY_PLANS is a generic table used by forms for querying data. This table is used to display capacity horizontal plan information in
MSC_CATEGORY_SETS 33 This tables stores different category sets for an item.
MSC_CATEGORY_SET_ID_LID 3 This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identi
MSC_COLL_PARAMETERS 83 Table to Store Collection Session Parameter Information
MSC_COMPANIES 25 Contains list of companies involved in collaboration
MSC_COMPANY_ID_LID 4 Table which contains the link between the company identifier in the source ERP system and the company identifier generated in APS.
MSC_COMPANY_RELATIONSHIPS 10 Table to hold relationship between companies for interenterprise collaboration and planning.
MSC_COMPANY_SITES 45 This table contains the list of company site used in interenterprise collaboration and planning.
MSC_COMPANY_SITE_ID_LID 5 This table contains the link between the company site identifier in the source and thecompany site identifier generated in APS.
MSC_COMPANY_USERS 3 This table contains the user company association for Oracle Collaborative planning functionality.
MSC_COMPONENT_SUBSTITUTES 39 This table represents possible substitutes component in a bill of material.
MSC_COSTS_F 57
MSC_CRITERIA 20 Seeded criteria for Planner Workbench
MSC_CRITICAL_PATHS 17 Table created for Improved Exceptions
MSC_CURRENCY_CONV_MV 4
MSC_DELIVERY_DETAILS 33
MSC_DEMANDS 190 This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent dema
MSC_DEMANDS_CUM_F 36
MSC_DEMANDS_F 72
MSC_DEMAND_CLASSES 32 This table stores the demand classes.
MSC_DEMAND_MV_TAB 9 KPI Summary Table
MSC_DEMANTRA_F 70
MSC_DEPARTMENT_RESOURCES 89 This table stores the resources available for planning.
MSC_DESIGNATORS 57 This table stores MPS and MDS schedule names defined at source applications and planning server. MPS_RELIEF indicates whether or not the Pla
MSC_DMD_SCN_METRICS 14
MSC_DOC_ATTACHMENTS 22 This table Stores the Attachment information
MSC_EAM_ACT_ASSOCIATIONS 14 This table Stores the association relationship between an EAM Activty and the corresponding Asset/rebuildable item
MSC_EAM_ASSET_EQUIP_DTLS 18
MSC_ERRORS 20 Stores the Errors that have occured during the pre-processing. ERROR_ID is a unique identifier for each record. TABLE_NAME stores the stagin
MSC_EXCEPTIONS_F 40
MSC_EXCEPTION_DETAILS 54 This table stores the details of exceptions generated by Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products.
MSC_EXCEPTION_PREFERENCES 8 This table stores the order in which a user chooses to see the exception types.
MSC_EXCEPTION_THRESHOLDS 25 This table is for storing the effective date of threshold defined for seeded and custom exceptions. This table is not used presently
MSC_EXCEPTION_THRESHOLD_VALUES 32 This table stores threshold values for each exception type. For supplier facing exceptions, the threshold values are obtained in the follo
MSC_EXC_DETAILS_ALL 39 This is an Exception Details table to be populated for Plan Comparison Reports.
MSC_FCTI_HEADERS_INTERFACE 14
MSC_FCTI_LINES_INTERFACE 27
MSC_FILES 17 File names used by the planner
MSC_FORECAST_UPDATES 28 This table describes the relationship between consumed forecast entries and sales order demands
MSC_FORM_QUERY 53 Temporaray table used in computation of results in Oracle Advanced planning and Oracle Supply Chain Hub products.
MSC_FULL_PEGGING 50 This table represents the pegging from supply to demands.
MSC_GANTT_QUERY 31
MSC_GROUPS 30 This table stores information about groups of trading partners.
MSC_GROUP_COMPANIES 26 This table stores membership information of various companies in different groups.
MSC_HUB_QUERY 49
MSC_IB_CONTRACTS_TEMP 23
MSC_INSTANCE_ORGS 57 This stores the information of the association links between each organization and MSC.
MSC_INST_PARTITIONS 11 This table stores the available and used instance partition information. Instance partitions are used to store the ODS data of specific inst
MSC_INTERORG_SHIP_METHODS 59 This table stores the different shipment methods and their availability.
MSC_INT_10_E_SNO 12
MSC_INT_10_TV 8
MSC_INT_10_TV_SNO 13
MSC_INT_11_E_SNO 15
MSC_INT_11_TV 13
MSC_INT_11_TV_SNO 8
MSC_INT_12_E 12
MSC_INT_12_E_SNO 6
MSC_INT_12_TV_SNO 10
MSC_INT_13_E 11
MSC_INT_13_E_SNO 16
MSC_INT_13_TV_SNO 8
MSC_INT_14_E_SNO 7
MSC_INT_14_TV_SNO 8
MSC_INT_15_E_SNO 7
MSC_INT_15_TV_SNO 8
MSC_INT_16_E_SNO 7
MSC_INT_16_TV_SNO 5
MSC_INT_17_E_SNO 4
MSC_INT_18_E_SNO 7
MSC_INT_18_TV_SNO 7
MSC_INT_19_E_SNO 4
MSC_INT_19_TV_SNO 7
MSC_INT_1_E 1
MSC_INT_20_E_SNO 4
MSC_INT_20_TV_SNO 11
MSC_INT_21_TV_SNO 9
MSC_INT_22_E_SNO 4
MSC_INT_22_TV_SNO 11
MSC_INT_23_TV_SNO 6
MSC_INT_24_E_SNO 4
MSC_INT_24_MEM_SNO 2
MSC_INT_25_E_SNO 11
MSC_INT_25_TV_SNO 6
MSC_INT_26_E_SNO 4
MSC_INT_26_MEM_SNO 2
MSC_INT_26_TV_SNO 14
MSC_INT_27_E_PLAN 3
MSC_INT_27_E_SNO 11
MSC_INT_27_TV_SNO 6
MSC_INT_28_MEM_SNO 2
MSC_INT_28_TV_PLAN 6
MSC_INT_28_TV_SNO 14
MSC_INT_29_E_PLAN 6
MSC_INT_29_E_SNO 11
MSC_INT_29_TV_SNO 6
MSC_INT_2_E 5
MSC_INT_30_E_PLAN 11
MSC_INT_30_TV_PLAN 6
MSC_INT_30_TV_SNO 14
MSC_INT_31_E_PLAN 6
MSC_INT_31_E_SNO 5
MSC_INT_32_E_PLAN 11
MSC_INT_32_TV_PLAN 11
MSC_INT_32_TV_SNO 9
MSC_INT_33_E_PLAN 8
MSC_INT_33_E_SNO 4
MSC_INT_34_E_PLAN 5
MSC_INT_34_TV_PLAN 11
MSC_INT_34_TV_SNO 6
MSC_INT_35_E_PLAN 8
MSC_INT_35_MEM_SNO 2
MSC_INT_36_E_PLAN 15
MSC_INT_36_E_SNO 11
MSC_INT_36_TV_PLAN 11
MSC_INT_37_E_PLAN 12
MSC_INT_37_TV_SNO 14
MSC_INT_38_E_PLAN 9
MSC_INT_39_E_PLAN 10
MSC_INT_39_TV_PLAN 6
MSC_INT_3_TV 6
MSC_INT_40_E_PLAN 9
MSC_INT_41_E_PLAN 10
MSC_INT_42_E_PLAN 9
MSC_INT_43_E_PLAN 10
MSC_INT_43_TV_PLAN 11
MSC_INT_44_E_PLAN 8
MSC_INT_45_E_PLAN 5
MSC_INT_46_E_PLAN 8
MSC_INT_47_E_PLAN 10
MSC_INT_48_E_PLAN 12
MSC_INT_49_E_PLAN 9
MSC_INT_4_E 6
MSC_INT_50_E_PLAN 9
MSC_INT_5_E 9
MSC_INT_5_TV 7
MSC_INT_6_E 6
MSC_INT_6_TV 13
MSC_INT_7_TV 7
MSC_INT_7_TV_SNO 10
MSC_INT_8_E 12
MSC_INT_8_E_SNO 5
MSC_INT_8_TV 13
MSC_INT_9_E 11
MSC_INT_9_TV 7
MSC_INT_9_TV_SNO 7
MSC_INT_ACTUAL_RESOURCE_PLAN 10
MSC_INT_ACTUAL_RES_HRS 12
MSC_INT_ALL_DEMAND_ITEM 1
MSC_INT_ALL_ITEM 1
MSC_INT_ALL_SUPPLY_ITEM 1
MSC_INT_ALT_RES 27
MSC_INT_APCC_ITEM_SOURCE 6
MSC_INT_APCC_ORG_DETAIL 6
MSC_INT_ASCP_DEMANDS 9
MSC_INT_ASCP_DEPENDENT_DEMAND 8
MSC_INT_ASCP_END_ITEM 1
MSC_INT_ASCP_EXCEPTION_DETAILS 12
MSC_INT_ASCP_EXPORT_BUCKETS 6
MSC_INT_ASCP_INVENTORY 10
MSC_INT_ASCP_KPI 22
MSC_INT_ASCP_LABOUR_UTIL 11
MSC_INT_ASCP_MACHINE_UTIL 11
MSC_INT_ASCP_MFG_PLAN_LABOUR 11
MSC_INT_ASCP_MFG_PLAN_MACHINE 11
MSC_INT_ASCP_PRODCOST_KPI 6
MSC_INT_ASCP_SUPPLY 11
MSC_INT_ASCP_SUPPLY_ITEM 1
MSC_INT_ASCP_TOTALPRODCOST 6
MSC_INT_ASCP_TRANSPCOST_KPI 6
MSC_INT_ASCP_TRANSPORTATION 13
MSC_INT_ASSET 10
MSC_INT_ASSIGNED_ATTRIBUTE 4
MSC_INT_ATTRIBUTE_VALUE 3
MSC_INT_BEGINNING_INVENTORY 11
MSC_INT_BOR_RES_NAME 6
MSC_INT_BRANCH 14
MSC_INT_BRANCH_GROUP 3
MSC_INT_BRANCH_GROUP_MEM 3
MSC_INT_BRANCH_OPERATION 2
MSC_INT_BRANCH_OPERATION_SET 4
MSC_INT_BRANCH_OPERATION_SNO 2
MSC_INT_BRANCH_OPERATION_TV 5
MSC_INT_BRANCH_ROUTING 3
MSC_INT_BRANCH_ROUTING_SNO 3
MSC_INT_BRANCH_ROUTING_TV 5
MSC_INT_BRANCH_ROUTING_TV_SNO 6
MSC_INT_BRANCH_SNO 14
MSC_INT_CALENDAR 4
MSC_INT_CALENDAR_SNO 3
MSC_INT_CALENDAR_TV 5
MSC_INT_CALENDAR_TV_SNO 7
MSC_INT_CFC_SCENARIO_DETAILS 10
MSC_INT_CHANGEOVER_PATTERN 12
MSC_INT_CHANGEOVER_PATTERN_SNO 10
MSC_INT_CMRO_OP_REL 12
MSC_INT_CMRO_RES_REQS 9
MSC_INT_COMPONENT_ITEM 2
MSC_INT_CONSUMED_ITEM_BOM 5
MSC_INT_CONSUMED_ITEM_BOM_SNO 5
MSC_INT_CONSUMED_ITEM_BOM_TV 10
MSC_INT_CONSUMED_ITEM_SET 3
MSC_INT_CONSUMED_ITEM_SET_SNO 3
MSC_INT_CREW 13
MSC_INT_CREW_SNO 10
MSC_INT_CREW_TV 9
MSC_INT_CREW_TV_SNO 11
MSC_INT_CUSTOMER 12
MSC_INT_CUSTOMER_GROUP 3
MSC_INT_CUSTOMER_GROUP_MEM 3
MSC_INT_CUSTOMER_GROUP_MEM_SNO 3
MSC_INT_CUSTOMER_GROUP_SNO 3
MSC_INT_CUSTOMER_SNO 12
MSC_INT_CUST_ITEM_TR_MODE 6
MSC_INT_CUST_ITEM_TR_MODE_SNO 6
MSC_INT_CUST_ITEM_TR_MODE_TV 7
MSC_INT_CUST_TR_MODE 7
MSC_INT_CUST_TR_MODE_SNO 7
MSC_INT_CUST_TR_MODE_TV 10
MSC_INT_CUST_TR_MODE_TV_SNO 11
MSC_INT_END_ITEM 1
MSC_INT_ENTERPRISE_FORECAST 9
MSC_INT_ENT_FCST_DETAIL 6
MSC_INT_ENT_FCST_DETAIL_SNO 5
MSC_INT_ENT_FCST_DETAIL_TV 11
MSC_INT_ENT_FCST_DETAIL_TV_SNO 8
MSC_INT_EQUIPMENT 5
MSC_INT_FIXED_PRODUCTION_SNO 2
MSC_INT_IMPLEMENTING_RES 5
MSC_INT_IMPLEMENTING_RESOURCE 5
MSC_INT_IMPLEMENTING_RES_SNO 5
MSC_INT_IMPLEMENTING_RES_TV 8
MSC_INT_IMPL_RES 5
MSC_INT_INVENTORY_POLICY 6
MSC_INT_INVENTORY_POLICY_SNO 6
MSC_INT_INVENTORY_POLICY_TV 9
MSC_INT_INV_SAFE_TAR 8
MSC_INT_INV_SAFE_TAR_DETAIL 5
MSC_INT_INV_SAFE_TAR_DETAIL_TV 7
MSC_INT_INV_SAFE_TAR_SNO 7
MSC_INT_ITEM 12
MSC_INT_ITEM_BRANCH 17
MSC_INT_ITEM_BRANCH_SNO 15
MSC_INT_ITEM_BRANCH_TV 5
MSC_INT_ITEM_BRANCH_TV_SNO 6
MSC_INT_ITEM_GROUP 4
MSC_INT_ITEM_GROUP_MEM 3
MSC_INT_ITEM_GROUP_MEM_SNO 3
MSC_INT_ITEM_GROUP_SNO 4
MSC_INT_ITEM_PRICE 3
MSC_INT_ITEM_PRICE_SNO 3
MSC_INT_ITEM_PRICE_TV 5
MSC_INT_ITEM_PRICE_TV_SNO 6
MSC_INT_ITEM_SNO 12
MSC_INT_ITEM_STORAGE 5
MSC_INT_ITEM_STORAGE_SNO 5
MSC_INT_ITEM_STORAGE_TV 6
MSC_INT_ITEM_STORAGE_TV_SNO 7
MSC_INT_ITEM_TRANSPORT_MODE 7
MSC_INT_ITEM_TRAVEL_DISTANCE 7
MSC_INT_ITEM_UOM 4
MSC_INT_ITEM_UOM_SNO 4
MSC_INT_JOB_ALT_RES 25
MSC_INT_LANE 4
MSC_INT_LANE_SNO 4
MSC_INT_MACHINE 27
MSC_INT_MACHINE_SNO 11
MSC_INT_MACHINE_TV 9
MSC_INT_MACHINE_TV_SNO 11
MSC_INT_MACH_ATTRIBUTE 3
MSC_INT_NEXT_WORK_ORDER 8
MSC_INT_OPERATION 19
MSC_INT_OPERATION_BOR 13
MSC_INT_OPERATION_BOR_SNO 13
MSC_INT_OPERATION_BOR_TV 10
MSC_INT_OPERATION_BOR_TV_SNO 11
MSC_INT_OPERATION_GROUP 3
MSC_INT_OPERATION_GROUP_MEM 2
MSC_INT_OPERATION_GROUP_SNO 3
MSC_INT_OPERATION_SET 8
MSC_INT_OPERATION_SET_MEM 3
MSC_INT_OPERATION_SET_MEM_SNO 3
MSC_INT_OPERATION_SET_SNO 3
MSC_INT_OPERATION_SNO 13
MSC_INT_OSFM_PATH 4
MSC_INT_PEGGED_WORK_ORDER_PLAN 17
MSC_INT_PRODUCED_ITEM 2
MSC_INT_PRODUCED_ITEM_BOM 6
MSC_INT_PRODUCED_ITEM_BOM_SNO 6
MSC_INT_PRODUCED_ITEM_BOM_TV 6
MSC_INT_PRODUCED_ITEM_SNO 2
MSC_INT_PS_ALL_ITEM 1
MSC_INT_PS_DEMAND_ITEM 1
MSC_INT_PS_END_ITEM 1
MSC_INT_PS_SUPPLY_ITEM 1
MSC_INT_PURCHASE_ORDER 6
MSC_INT_PURCHASE_ORDER_DETAIL 12
MSC_INT_PURCHASE_ORDER_SNO 9
MSC_INT_RESERVATION 12
MSC_INT_RESOURCE_ATTRIBUTE 2
MSC_INT_RESOURCE_GROUP 3
MSC_INT_RESOURCE_GROUP_MEM 2
MSC_INT_RESOURCE_GROUP_MEM_SNO 2
MSC_INT_RESOURCE_GROUP_SNO 3
MSC_INT_RESOURCE_PLAN 5
MSC_INT_RESOURCE_SCHEDULE_PLAN 9
MSC_INT_RESOURCE_SET 3
MSC_INT_RESOURCE_SET_SNO 3
MSC_INT_RES_INTERMEDIATE 16
MSC_INT_ROUTING 18
MSC_INT_ROUTING_SNO 4
MSC_INT_SALES_ORDER 22
MSC_INT_SALES_ORDER_DETAIL 28
MSC_INT_SALES_SNO 3
MSC_INT_SALES_TV_SNO 7
MSC_INT_SATISFIED_DEMAND_PLAN 10
MSC_INT_SCHEDULE_BOR_PLAN 10
MSC_INT_SCHEDULE_MILESTONE 5
MSC_INT_SHIFT_CALENDAR 3
MSC_INT_SOURCE1 2
MSC_INT_SOURCE2 4
MSC_INT_SOURCE_ITEM_PLAN 3
MSC_INT_SRC_RECOMMEND_DETAIL 18
MSC_INT_STANDARD_UOM 4
MSC_INT_STANDARD_UOM_SNO 4
MSC_INT_STORAGE 6
MSC_INT_STORAGE_SNO 6
MSC_INT_STORAGE_TV 5
MSC_INT_STORAGE_TV_SNO 6
MSC_INT_SUB_COMPONENT_ITEM 1
MSC_INT_SUPPLIER 10
MSC_INT_SUPPLIER_GROUP 2
MSC_INT_SUPPLIER_GROUP_MEM 2
MSC_INT_SUPPLIER_GROUP_MEM_SNO 2
MSC_INT_SUPPLIER_GROUP_SNO 2
MSC_INT_SUPPLIER_ITEM 7
MSC_INT_SUPPLIER_ITEM_BRANCH 11
MSC_INT_SUPPLIER_ITEM_SNO 7
MSC_INT_SUPPLIER_ITEM_TV 8
MSC_INT_SUPPLIER_ITEM_TV_SNO 9
MSC_INT_SUPPLIER_SNO 10
MSC_INT_TEMPORAL_RELATION 10
MSC_INT_TEMPORAL_RELATION_SNO 10
MSC_INT_TOOL 15
MSC_INT_TOOL_SNO 12
MSC_INT_TOOL_TV 9
MSC_INT_TOOL_TV_SNO 11
MSC_INT_TRANSFER_ORDER 3
MSC_INT_TRANSFER_ORDER_DETAIL 16
MSC_INT_TRANSFER_ORDER_IN 19
MSC_INT_TRANSFER_ORDER_OUT 19
MSC_INT_TRANSFER_ORDER_SNO 8
MSC_INT_TRANSPORT_MODE 11
MSC_INT_TRANSPORT_MODE_SNO 11
MSC_INT_TRANSPORT_MODE_TV 9
MSC_INT_TRANSPORT_MODE_TV_SNO 10
MSC_INT_VISIT 10
MSC_INT_WORK_ORDER 32
MSC_INT_WORK_ORDER_BOR 14
MSC_INT_WORK_ORDER_IMP_RES 10
MSC_INT_WORK_ORDER_OPERATION 38
MSC_INT_WO_CMRO_CONFIG 14
MSC_INT_WO_CONSUMED_ITEM_BOM 14
MSC_INT_WO_OPERATION_SET 5
MSC_INT_WO_PRODUCED_ITEM_BOM 13
MSC_INT_WO_TEMPORAL_REL 9
MSC_ITEMS 28 This table is used by the collection program to keep track of all inventory item identifiers generated at planning server.
MSC_ITEMS_F 41
MSC_ITEM_CATEGORIES 38 This table stores the item assignment to categories within a category set.
MSC_ITEM_CUSTOMERS 37 Table to hold customer items and cross references.
MSC_ITEM_EXCEPTIONS 28 This table stores a row per exception message against an item for exceptions generated in the Oracle Advanced planning and scheduling (APS)
MSC_ITEM_HIERARCHY_MV 20
MSC_ITEM_ID_LID 3 This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identi
MSC_ITEM_INVENTORY_F 74
MSC_ITEM_ORDERS_F 77
MSC_ITEM_SOURCING 59 This table stores sourcing information for an item used in Oracle Advanced Planning and Scheduling. This table is also used to store Sourcin
MSC_ITEM_SUBSTITUTES 30 This table stores all the Relationships between Item Substitutes for planning.
MSC_ITEM_SUPPLIERS 68 This table stores the processing lead time, order modifier, and delivery calendar information for each item - supplier/site.
MSC_ITEM_WIPS_F 20
MSC_JOB_OPERATIONS 51
MSC_JOB_OPERATION_NETWORKS 48
MSC_JOB_OP_RESOURCES 55
MSC_JOB_OP_RES_INSTANCES 42
MSC_JOB_REQUIREMENT_OPS 51
MSC_LATE_ORDER_MV_TAB 9 KPI Summary Table
MSC_LOCAL_ID_DEMAND 49 MSC_LOCAL_ID_DEMAND table stores the mappings between the Local IDs and the User Defined Keys for all types of Demands. The table is striped
MSC_LOCAL_ID_ITEM 38 MSC_LOCAL_ID_ITEM table stores the mappings between the Local IDs and the User Defined Keys for Items. The table is striped by ENTITY_NAME.
MSC_LOCAL_ID_MISC 53 MSC_LOCAL_ID_MISC table stores the mappings between the Local IDs and the User Defined Keys for Sourcing Rules, Projects, Tasks and Categori
MSC_LOCAL_ID_SETUP 59 MSC_LOCAL_ID_SETUP table stores the mappings between the Local IDs and the User Defined Keys for BOM, Routing, Trading Partners, Departments
MSC_LOCAL_ID_SUPPLY 47 MSC_LOCAL_ID_SUPPLY This table stores the mappings between the Local IDs and the User Defined Keys for all the Supplies. The table is stripe
MSC_LOCATION_ASSOCIATIONS 15 This table stores location associations for organization, customer, customer sites, supplier, and supplier sites.
MSC_LONG_TEXT 9 This table Stores the Short text Content
MSC_MATERIAL_PLANS 73 MSC_MATERIAL_PLANS is a generic table used by forms for querying data.
MSC_MTH_OPEN_SALES_ORDERS_F 2
MSC_NEC_COMPARE_PLANS 10 This table store the the status of the plan which has launched the "Compare Plan Exceptions" concurrent program.
MSC_NEC_EXC_DTL_COMPARE 17 This table is a working table for Plan Comparison Reports.
MSC_NET_CHANGE_CRITERIA 15 This table stores the criteria used in Plan Comparison Reports.
MSC_NET_RESOURCE_AVAIL 46 This table stores the resource availability profile of the different resources.
MSC_NET_RES_INST_AVAIL 45
MSC_OE_DATA_TEMP 10
MSC_OPERATION_COMPONENTS 17 This table is the intersection table between MSC_BOM_COMPONENTS and MSC_ROUTING_OPERATIONS.
MSC_OPERATION_NETWORKS 50 This table is a child table of msc_operations. Describes the network structure of operations of a network routing.
MSC_OPERATION_RESOURCES 50 This table stores operation resources from a resource sequence. For each resource sequence, we have an alternative between different set of
MSC_OPERATION_RESOURCE_SEQS 25 This tables stores the operation resources for each routing operation.
MSC_ORG_ACCESS 11 This table stores the organizations to which a responsibility has access
MSC_ORG_AGGR_IBUC 13 This table Stores the aggregated quantity of the install base item instances at item,date,org level
MSC_ORP_MATERIAL_PLANS 16
MSC_ORP_RESOURCE_PLANS 14
MSC_OUTBOUND_ENTRIES 26 Outbound XML transactions from Collaborative Planning
MSC_PARAMETERS 52 This table stores information about how the planning process works for a given organization. Each organization will have an entry in MSC_PA
MSC_PARTNER_CONTACTS 19 This table stores the partner contacts.
MSC_PART_DEMANDS 21
MSC_PART_PEGGING 49
MSC_PART_SUPPLIES 44
MSC_PDR_PARAMETERS 25 Store the parameters user entered in the Planning Detailed Reports
MSC_PDR_PARAMETERS_NEW 22 Store the parameters user entered in the Planning Detailed Reports
MSC_PERIOD_START_DATES 18 Workday calendar period start dates
MSC_PHUB_CATEGORIES_MV 5
MSC_PHUB_CUSTOMERS_MV 14
MSC_PHUB_DATES_MV 23
MSC_PHUB_ITEM_CATEGORIES_MV 5
MSC_PHUB_ORGS_MV 12
MSC_PHUB_PROJECTS_MV 10
MSC_PHUB_RESOURCES_MV 21
MSC_PLANNERS 35 This table stores and maintains a list of planner codes.
MSC_PLANS 331 This table stores different plans, with their names, and settings in the Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chai
MSC_PLAN_BUCKETS 34 This table stores bucket dates for Planner Workbench Horizontal Plan.
MSC_PLAN_CONSTRAINTS 30
MSC_PLAN_ORGANIZATIONS 56 This table stores the parameters relative to organizations that participate to the plan in Oracle Advanced Planning and Scheduling (APS). Th
MSC_PLAN_ORG_KPIS 5 Maintains the key performance indicators and thresholds for plans created on Oracle Supply Chain Hub.
MSC_PLAN_ORG_STATUS 6 Maintains the history of statuses of collaborating organizations in a plan.
MSC_PLAN_PARTITIONS 13 The table stores partition information for plans.
MSC_PLAN_REFRESHES 13 This table used by collection program to keep track of the refresh numbers for each plan.
MSC_PLAN_SCHEDULES 40 This table stores master production schedules and master demand schedules for the planning process in an organization. This table is also us
MSC_PO_REQUISITIONS_INTERFACE 35 Requisition Import interface table
MSC_PO_RESCHEDULE_INTERFACE 20 Requisition reschedule interface table
MSC_PQ_RESULTS 52 Stores results of different types of personal queries.
MSC_PROCESS_EFFECTIVITY 35 This table stores links between the bill of material and routings and store effectivities for this process.
MSC_PROFILES 11
MSC_PROJECTS 43 This table stores the manufacturing parameters for a given project and organization.
MSC_PROJECT_TASKS 22 This table stores the tasks maufacturing parameters.
MSC_PURCHASE_ORDER_INTERFACE 17 This table stores the Purchase Order information to be rescheduled in the Source instance.
MSC_QUERY 49 Table used to pass data across sessions.
MSC_QUESTIONS_B 10 This table stores the seeded and user defined questions for Ask Oracle. The associated MSC_QUESTIONS_TL table contains the translated questi
MSC_QUESTIONS_TL 11 This table contains the translated questions for Ask Oracle
MSC_REGIONS 46 This table contains geographical regions data
MSC_REGIONS_TEMP 6 This table temporarily contains geographical regions data needed during an ATP request.
MSC_REGION_LOCATIONS 35 Stores mapping of locations to regions. This includes separate records for the most specific region mapped as well as records for its parent
MSC_RELATED_EXCEPTIONS 27 This table is for storing related exceptions to a custom exceptions. This table is not used presently.
MSC_REPETITIVE_PERIODS 12 Repetitive planning period start dates
MSC_RESERVATIONS 35 Material reservations
MSC_RESOURCES_CUM_F 20
MSC_RESOURCES_F 27
MSC_RESOURCE_CHANGES 37 Resource capacity modifications
MSC_RESOURCE_GROUPS 32 This table stores different resource groups.
MSC_RESOURCE_HIERARCHY_MV 21
MSC_RESOURCE_INSTANCE_REQS 59
MSC_RESOURCE_REQUIREMENTS 99 This table stores the resource requirments generated by existing supplies.
MSC_RESOURCE_SHIFTS 31 Resource shift information
MSC_ROUTINGS 32 This table stores the different routings available for a bill of material.
MSC_ROUTING_OPERATIONS 42 This tables stores the operations composing each routing.
MSC_RP_CATEGORY_MV 5
MSC_RP_CTB_DONOR_COMPONENTS 17
MSC_RP_CTB_ORDER_COMPONENTS 17
MSC_RP_ITEM_UPDATES 11
MSC_RP_KPI 28
MSC_RP_RELEASED_ORDERS 11
MSC_SAFETY_STOCKS 38 Safety stock levels
MSC_SALES_ORDERS 92 This table stores sales order demand and reservations from source application instances.
MSC_SCHEDULING_RULES 36 This table stores the scheduling rules used to schedule lines.
MSC_SECURITY_RULES 26 This table is not used.
MSC_SELECTION_CRITERIA 27 MSC Selection Criteria Stores the UI Search selection criteria
MSC_SEQUENCE_DEPENDENT_SETUPS 17 The table stores the sequence dependent setups and tears down. This is used by HLS to ensure a minimun delay between two operations using t
MSC_SERIAL_NUMBERS 38 This table stores unit level details for an onhand item.
MSC_SHIFT_DATES 20 Workday calendar shift dates
MSC_SHIFT_EXCEPTIONS 32 Workday calendar shift exceptions
MSC_SHIFT_TIMES 31 Workday calendar shift times
MSC_SHORT_TEXT 9 This table Stores the Short text Content
MSC_SIMULATION_SETS 31 This table stores the different simulation sets.
MSC_SINGLE_LVL_PEG 10 Single level supply to supply or supply to demand pegging. Currently used for DRP plans
MSC_SNAPSHOT_TASKS 18 Tasks to be performed by Snapshot Workers
MSC_SORT_DATA 13 This table describes the sorted details used by the Find window.
MSC_SOURCING_HISTORY 20 Historical information related to sourcing.
MSC_SOURCING_RULES 38 This table stores sourcing rules and bills of distribution information.
MSC_SOURCING_TRANSACTIONS 8
MSC_SQLLOAD_PARAMETERS 8 This table stores sql load parameters like table name, bindsize, number of rows etc.
MSC_SRP_ITEM_EXCEPTIONS 16
MSC_SR_ASSIGNMENTS 46 This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level.
MSC_SR_RECEIPT_ORG 38 Receiving Organizations for Sourcing Rules or Bills of distribution
MSC_SR_SOURCE_ORG 49 Source organization for Sourcing Rules or Bills of distribution
MSC_SR_ZN_AGGR_IBUC 11 Source side table that Stores the aggregated quantity of the install base item instances at item,date,zone level
MSC_ST_ASSIGNMENT_SETS 15 The staging table used by the collection program to valid and process data for table MSC_ASSIGNMENT_SETS.
MSC_ST_ATP_RULES 50 The staging table used by the collection program to validate and process data for table MSC_ATP_RULES.
MSC_ST_BILL_OF_RESOURCES 18 The staging table used by the collection program to validate and process data for table MSC_BILL_OF_RESOURCES.
MSC_ST_BIS_BUSINESS_PLANS 18 The staging table used by the collection program to validate and process data for table MSC_BIS_BUSINESS_PLANS.
MSC_ST_BIS_PERIODS 26 The staging table used by the collection program to validate and process data for table MSC_BIS_PERIODS.
MSC_ST_BIS_PFMC_MEASURES 24 The staging table used by the collection program to validate and process data for table MSC_BIS_PFMC_MEASURES.
MSC_ST_BIS_TARGETS 35 The staging table used by the collection program to valid and process data for table MSC_BIS_TARGETS.
MSC_ST_BIS_TARGET_LEVELS 32 The staging table used by the collection program to validate and process data for table MSC_BIS_TARGET_LEVELS
MSC_ST_BOMS 41 The staging table used by the collection program to valid and process data for table MSC_BOMS.
MSC_ST_BOM_COMPONENTS 68 The staging table used by the collection program to valid and process data for table MSC_BOM_COMPONENTS.
MSC_ST_BOR_REQUIREMENTS 29 The staging table used by the collection program to valid and process data for table MSC_BOR_REQUIREMENTS.
MSC_ST_BUDGETS_F 22
MSC_ST_CALENDARS 29 This is an interface table for staging definition of workday calendars from Legacy Instances. The 'Pre-Processor' would then validate the da
MSC_ST_CALENDAR_DATES 23 The staging table used by the collection program to validate and process data for table MSC_CALENDAR_DATES.
MSC_ST_CALENDAR_EXCEPTIONS 24 This is an interface table for staging exception dates for calendar from Legacy Instances. The 'Pre-Processor' would then validate the data
MSC_ST_CALENDAR_SHIFTS 26 The staging table used by the collection program to validate and process data for table MSC_CALENDAR_SHIFTS.
MSC_ST_CAL_WEEK_START_DATES 18 The staging table used by the collection program to validate and process data for table MSC_CAL_WEEK_START_DATES.
MSC_ST_CAL_YEAR_START_DATES 15 The staging table used by the collection program to validate and process data for table MSC_YEAR_START_DATES.
MSC_ST_CATEGORY_SETS 28 The staging table used by the collection program to validate and process data for table MSC_CATEGORY_SETS.
MSC_ST_COMPANY_USERS 26 Staging table for user company association information.
MSC_ST_COMPONENT_SUBSTITUTES 36 The staging table used by the collection program to validate and process data for table MSC_COMPONENT_SUBSTITUTES.
MSC_ST_COSTS_F 63
MSC_ST_CO_PRODUCTS 31 This table is used for collecting the CO Product Bill in Legacy Collections
MSC_ST_DEMANDS 144 The staging table used by the collection program to validate and process data for table MSC_DEMANDS.
MSC_ST_DEMANDS_CUM_F 39
MSC_ST_DEMANDS_F 77
MSC_ST_DEMAND_CLASSES 42 The staging table used by the collection program to validate and process data for demand classes.
MSC_ST_DEMANTRA_F 73
MSC_ST_DEMANTRA_ODS_F 85
MSC_ST_DEPARTMENT_RESOURCES 84 The staging table used by the collection program to validate and process data for table MSC_DEPARTMENT_RESOURCES.
MSC_ST_DESIGNATORS 55 The staging table used by the collection program to validate and process data for table MSC_DESIGNTORS.
MSC_ST_DOC_ATTACHMENTS 22 This staging table Stores the Attachment information
MSC_ST_EAM_ACT_ASSOCIATIONS 16
MSC_ST_EAM_ASSET_EQUIP_DTLS 14
MSC_ST_EXCEPTIONS_F 52
MSC_ST_GROUPS 44 The staging table used by the collection program to validate and process data for table MSC_GROUPS
MSC_ST_GROUP_COMPANIES 43 The staging table used by the collection program to validate and process data for table MSC_GROUP_COMPANIES
MSC_ST_INTERORG_SHIP_METHODS 71 The staging table used by the collection program to validate and process data for table MSC_INTERORG_SHIP_METHODS.
MSC_ST_ITEMS_F 43
MSC_ST_ITEM_CATEGORIES 39 The staging table used by the collection program to validate and process data for table MSC_ITEM_CATEGORIES.
MSC_ST_ITEM_CUSTOMERS 34 Staging table to hold item customers data.
MSC_ST_ITEM_INVENTORY_F 58
MSC_ST_ITEM_ORDERS_F 76
MSC_ST_ITEM_SOURCING 69 This is a denormalized table for staging Sourcing Rules related data from Legacy Instances. The data in this table would be processed by the
MSC_ST_ITEM_SUBSTITUTES 37 The staging table used by the collection program to validate and process data for table MSC_DEMANDS.
MSC_ST_ITEM_SUPPLIERS 57 The staging table used by the collection program to validate and process data for table MSC_ITEM_SUPPLIERS.
MSC_ST_ITEM_WIPS_F 19
MSC_ST_JOB_OPERATIONS 51
MSC_ST_JOB_OP_RESOURCES 57
MSC_ST_JOB_REQUIREMENT_OPS 56
MSC_ST_LOCATION_ASSOCIATIONS 36 The staging table used by the collection program to validate and process data for table MSC_LOCATION_ASSOCIATIONS.
MSC_ST_LONG_TEXT 9 This table Stores the Long text Content
MSC_ST_NET_RESOURCE_AVAIL 22 The staging table used by the collection program to validate and process data for table MSC_NET_RESOURCE_AVAIL.
MSC_ST_NET_RES_INST_AVAIL 23
MSC_ST_OPERATION_COMPONENTS 17 The staging table used by the collection program to validate and process data for table MSC_OPERATION_COMPONENTS.
MSC_ST_OPERATION_NETWORKS 73 The staging table used by collections program to validate and process data for table MSC_OPERATION_NETWORKS.
MSC_ST_OPERATION_RESOURCES 60 The staging table used by the collection program to validate and process data for table MSC_OPERATION_RESOURCES.
MSC_ST_OPERATION_RESOURCE_SEQS 21 The staging table used by the collection program to validate and process data for table MSC_OPERATION_RESOURCE_SEQS.
MSC_ST_PARAMETERS 34 The staging table used by the collection program to validate and process data for table MSC_PARAMETERS.
MSC_ST_PARTNER_CONTACTS 31 The staging table used by the collection program to validate and process data for table MSC_PARTNER_CONTACS.
MSC_ST_PERIOD_START_DATES 19 The staging table used by the collection program to validate and process data for table MSC_PERIOD_START_DATES.
MSC_ST_PLANNERS 45 The staging table used by the collection program to validate and processdata for table MSC_PLANNERS....
MSC_ST_PROCESS_EFFECTIVITY 29 The staging table used by the collection program to validate and process data for table MSC_PROCESS_EFFECTIVITY.
MSC_ST_PROFILES 13 This is the staging table to keep the profile options
MSC_ST_PROJECTS 27 The staging table used by the collection program to validate and process data for table MSC_PROJECTS.
MSC_ST_PROJECT_TASKS 46 The staging table used by the collection program to validate and process data for table MSC_PROJECT_TASKS.
MSC_ST_REGIONS 46 The staging table used by the collection program to validate and process data for table MSC_REGIONS.
MSC_ST_REGION_LOCATIONS 35 The staging table used by the collection program to validate and process data for table MSC_REGION_LOCATIONS.
MSC_ST_RESERVATIONS 55 The staging table used by the collection program to validate and process data for table MSC_RESERVATIONS.
MSC_ST_RESOURCES_CUM_F 24
MSC_ST_RESOURCES_F 31
MSC_ST_RESOURCE_CHANGES 36 The staging table used by the collection program to validate and process data for table MSC_RESOURCE_CHANGES.
MSC_ST_RESOURCE_GROUPS 42 The staging table used by the collection program to validate and processdata for table MSC_ST_RESOURCE_CHANGES.
MSC_ST_RESOURCE_INSTANCE_REQS 45
MSC_ST_RESOURCE_REQUIREMENTS 101 The staging table used by the collection program to validate and process data for table MSC_RESOURCE_REQUIREMENTS.
MSC_ST_RESOURCE_SHIFTS 29 The staging table used by the collection program to validate and process data for table MSC_RESOURCE_SHIFTS.
MSC_ST_ROUTINGS 64 The staging table used by the collection program to validate and process data for table MSC_ROUTINGS.
MSC_ST_ROUTING_OPERATIONS 55 The staging table used by the collection program to validate and process data for table MSC_ROUTING_OPERATIONS.
MSC_ST_SAFETY_STOCKS 35 The staging table used by the collection program to validate and process data for table MSC_SAFETY_STOCKS.
MSC_ST_SALES_ORDERS 109 The staging table used by the collection program to validate and process data for table MSC_SALES_ORDERS.
MSC_ST_SERIAL_NUMBERS 48 The staging table used by the collection program to validate and process data for table MSC_SERIAL_NUMBERS.
MSC_ST_SHIFT_DATES 21 The staging table used by the collection program to validate and process data for table MSC_SHIFT_DATES.
MSC_ST_SHIFT_EXCEPTIONS 26 The staging table used by the collection program to validate and process data for table MSC_SHIFT_EXCEPTIONS.
MSC_ST_SHIFT_TIMES 25 The staging table used by the collection program to validate and process data for table MSC_SHIFT_TIMES.
MSC_ST_SHORT_TEXT 9 This staging table Stores the Short text Content
MSC_ST_SIMULATION_SETS 16 The staging table used by the collection program to validate and process data for table MSC_SIMULATION_SETS.
MSC_ST_SOURCING_HISTORY 20 Historical information related to Sourcing
MSC_ST_SOURCING_RULES 20 The staging table used by the collection program to validate and process data for table MSC_SOURCING_RULES.
MSC_ST_SR_ASSIGNMENTS 31 The staging table used by the collection program to valid and process data for table MSC_SR_ASSIGNMENTS.
MSC_ST_SR_RECEIPT_ORG 20 The staging table used by the collection program to validate and process data for table MSC_SR_RECEIPT_ORG.
MSC_ST_SR_SOURCE_ORG 26 The staging table used by the collection program to validate and process data for table MSC_SR_SOURCE_ORG.
MSC_ST_SUB_INVENTORIES 36 The staging table used by the collection program to validate and process data for table MSC_SUB_INVENTORIES.
MSC_ST_SUPPLIERS_F 37
MSC_ST_SUPPLIER_CAPACITIES 35 The staging table used by the collection program to validate and process data for table MSC_SUPPLIER_CAPACITIES.
MSC_ST_SUPPLIER_FLEX_FENCES 32 The staging table used by the collection program to validate and process data for table MSC_SUPPLIER_FLEX_FENCES.
MSC_ST_SUPPLIES 248 The staging table used by the collection program to validate and process data for table MSC_SUPPLIES.
MSC_ST_SUPPLIES_F 67
MSC_ST_SYSTEM_ITEMS 171 The staging table used by the collection program to valid and process data for table MSC_SYSTEM_ITEMS.
MSC_ST_TRADING_PARTNERS 81 The staging table used by the collection program to validate and process data for table MSC_TRADING_PARTNERS.
MSC_ST_TRADING_PARTNER_SITES 51 The staging table used by the collection program to validate and process data for table MSC_TRADING_PARTNER_SITES.
MSC_ST_UNITS_OF_MEASURE 27 The staging table used by the collection program to validate and process data for table MSC_UNITS_OF_MEASURE.
MSC_ST_UNIT_NUMBERS 16 The staging table used by the collection program to validate and process data for table MSC_UNIT_NUMBERS.
MSC_ST_UOM_CLASS_CONVERSIONS 33 The staging table used by the collection program to validate and process data for table MSC_UOM_CLASS_CONVERSIONS.
MSC_ST_UOM_CONVERSIONS 31 The staging table used by the collection program to validate and process data for table MSC_UOM_CONVERSIONS.
MSC_ST_VISITS 30
MSC_ST_WAREHOUSE_F 22
MSC_ST_WORKDAY_PATTERNS 27 This is an interface table for staging days on/days off patterns for your calendar and your shifts from Legacy Instances. The 'Pre-Processor
MSC_ST_WORK_BREAKDOWN_STRUCT 23
MSC_ST_WO_ATTRIBUTES 44
MSC_ST_WO_MILESTONES 27
MSC_ST_WO_OPERATION_REL 36
MSC_ST_WO_SUB_COMP 20
MSC_ST_WO_TASK_HIERARCHY 33
MSC_ST_ZN_AGGR_IBUC 13 This is the staging table that Stores the aggregated quantity of the install base item instances at item,date,zone level
MSC_ST_ZONE_REGIONS 34 The staging table used by the collection program to validate and process data for table MSC_ZONE_REGIONS.
MSC_SUB_INVENTORIES 37 MSC_SUB_INVENTORIES stores information about the netting type of eachsubinventory defined in Oracle Inventory. Each subinventory will havea
MSC_SUPDEM_HDRS_INTERFACE 23
MSC_SUPDEM_LINES_INTERFACE 102 Supply demand lines interface table
MSC_SUPPLIERS_F 34
MSC_SUPPLIER_CAPACITIES 44 This table stores the capacity information for planned items within an MPS, MRP, or DRP plan. Each row stores the capacity within a date r
MSC_SUPPLIER_FLEX_FENCES 40 MSC_SUPPLIER_FLEX_FENCES stores the supplier flex fence information for planned items within an MPS, MRP, or DRP plan. Each row stores the
MSC_SUPPLIER_LT_OUTCOMES 17 This table stores the supplier lead time variabilities
MSC_SUPPLIER_PLANS 51 MSC_SUPPLIER_PLANS is a generic table used by forms for querying data. This table is used to display supplier plan information in the Planne
MSC_SUPPLIER_REQUIREMENTS 36
MSC_SUPPLIES 248 This table lists all the supplies for this plan. The supplies created by the planning process are added to this table.
MSC_SUPPLIES_F 60
MSC_SUP_DEM_ENTRIES 173 This table holds transaction data for Oracle Collaborative planning.
MSC_SUP_DEM_HISTORY 67 Table to maintain historical information on data loaded into Oracle Collaborative planning.
MSC_SUP_HEADERS_INTERFACE 14
MSC_SUP_LINES_INTERFACE 25
MSC_SYSTEM_ITEMS 242 MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items planned by the planning proces
MSC_TEMP_ALLOC_DEMANDS 17 Child table to MSC_DEMANDS storing pre-allocated demands
MSC_TEMP_ALLOC_SUPPLIES 19 Child table to MSC_SUPPLIES storing pre-allocated supplies. Used during ATP post plan processing
MSC_TEMP_REGION_LOCATIONS 7
MSC_TEMP_SALES_ORDERS 46
MSC_TEMP_SUMM_RES 15 Temp table for calculating resource summary data. (unused)
MSC_TEMP_SUMM_SD 17 Temp table for calculating supply/demand summary data during post plan processing
MSC_TEMP_SUMM_SO 17 Temp table used to calculate summary data for sales orders during post plan processing
MSC_TEMP_SUMM_SUP 15 Temp table for calculating supply summary data for post plan processing. (unused)
MSC_TP_ID_LID 8 This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identi
MSC_TP_SITE_ID_LID 8 This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identi
MSC_TRADING_PARTNERS 77 This table stores information about the different organizations: customers, vendors, and planned organizations.
MSC_TRADING_PARTNER_MAPS 9 This table contains mapping of data between MSC_TRADING_PARTNERS andMSC_COMPANIES and MSC_COMPANY_SITES table.
MSC_TRADING_PARTNER_SITES 43 This table stores information about the different sites of an organization.
MSC_UNDO_DETAILS 14 This table describes the details of changes made to plan output.
MSC_UNDO_SUMMARY 13 This table describes the summary of changes made to plan output.
MSC_UNITS_OF_MEASURE 33 Unit of measure definitions
MSC_UNIT_NUMBERS 31 This table stores the different units numbers.
MSC_UOM_CLASS_CONVERSIONS 36 Conversions between base units of two different classes
MSC_UOM_CONVERSIONS 34 This table stores the different non-base unit of measures known conversions.
MSC_USER_ADV_EXPRESSIONS 31 User Defied expressions for custom exceptions.
MSC_USER_EXCEPTIONS 42 MSC_USER_EXCEPTIONS is the header table for user defined exceptions. It stores attributes such as the name and the schedule for the user def
MSC_USER_EXCEPTION_COMPONENTS 35 Holds components of a custom exception: Select clause attributes, simple condition attributes, advanced condition attributes
MSC_USER_EXCEPTION_NTFS 27 Recipients for exception notifications
MSC_VISITS 21
MSC_WAREHOUSE_F 19
MSC_WIP_JOB_DTLS_INTERFACE 82 Requests to add/delete/ modify material/resource requirements for jobs and schedules
MSC_WIP_JOB_SCHEDULE_INTERFACE 47 Requests to create or modify jobs and schedules
MSC_WORKBENCH_DISPLAY_OPTIONS 281 User display preferences for Planner Workbench in APS and horizontal plan screen in Supply Chain Hub.
MSC_WORKDAY_PATTERNS 17 MSC_WORKDAY_PATTERNS stores the days on/days off patterns for your calendar and your shifts. You can define multiple days on/days off to for
MSC_WORK_BREAKDOWN_STRUCT 14