1. Tables and Views for SCM
  2. MSC_PARAMETERS

MSC_PARAMETERS

Stores the Organizations collected to Fusion.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

MSC_PARAMETERS_PK

ORGANIZATION_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ORGANIZATION_ID NUMBER 18 Yes This column indicates the organization identifier.
DEFAULT_INCL_PLAN_BULK NUMBER 1 Default the Bulk supply type to be included in planning. Valid values are 1(Yes) and 2(No). If value is null then it should be treated as 1(Yes) for backward compatibility.
DEFAULT_INCL_PLAN_SUPPLIER NUMBER 1 Default the Supplier supply type to be included in planning. Valid values are 1(Yes) and 2(No). If value is null then it should be treated as 1(Yes) for backward compatibility.
LAST_RES_SUP_TARGET_COLL_DATE TIMESTAMP Indicates when last target collection modified resource availability for resources of respective org. This column is populated by collection flow and is used to determine whether aggregated resource supply is stale or not. Null value indicates that cache needs to be recomputed.
SR_INSTANCE_ID NUMBER 18 Identifier of the source system from where the data is collected. Obsolete
ORGANIZATION_CODE VARCHAR2 49 Yes This column indicates the organization code.
DEMAND_TIME_FENCE_FLAG NUMBER Yes Flag to indicate whether to use the demand time fence. The Demand Time Fence is defined at the item level
PLANNING_TIME_FENCE_FLAG NUMBER Yes Planning time fence code of the inventory item.
OPERATION_SCHEDULE_TYPE NUMBER Yes This value indicates OPERATION_SCHEDULE_TYPE.
CONSIDER_WIP NUMBER Yes Flag to Indicate whether to consider WIP
CONSIDER_PO NUMBER Yes Flag to Indicate whether to consider PO
SNAPSHOT_LOCK NUMBER Yes Snapshot lock specified for the organization.
PLAN_SAFETY_STOCK NUMBER Yes This value indicates the plan safety stock value for the organization.
CONSIDER_RESERVATIONS NUMBER Yes Flag to Indicate whether to consider reservations
PART_INCLUDE_TYPE NUMBER Yes This value indicates the part inclusion type for the organization.
DEFAULT_ABC_ASSIGNMENT_GROUP VARCHAR2 40 Indicates the default ABC assignment group
PERIOD_TYPE NUMBER Yes This value indicates the period type of the organization.
RESCHED_ASSUMPTION NUMBER This value indicates the reschedule assumption of the organization.
PLAN_DATE_DEFAULT_TYPE NUMBER Plan date default type specified for the organization.
INCLUDE_REP_SUPPLY_DAYS NUMBER Flag indicates whether to include repetitive supply days for an organization.
INCLUDE_MDS_DAYS NUMBER Indicates whether to include MDS days
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.
REPETITIVE_HORIZON1 NUMBER 38 Repetitive horizon 1 of the organization.
REPETITIVE_HORIZON2 NUMBER 38 Repetitive horizon 2 of the organization.
REPETITIVE_BUCKET_SIZE1 NUMBER 38 Repetitive bucket size 1 of the organization.
REPETITIVE_BUCKET_SIZE2 NUMBER 38 Repetitive bucket size 2 of the organization.
REPETITIVE_BUCKET_SIZE3 NUMBER 38 Repetitive bucket size 3 of the organization.
REPETITIVE_ANCHOR_DATE DATE Repetitive anchor date of the organization.
COLLECTED_FLAG NUMBER Flag indicating whether the row is collected from source application instance
NETWORK_SCHEDULING_METHOD NUMBER This column indicates the method used for network scheduling.
INCLUDE_PAST_DUE_FORECAST NUMBER Indicates whether to include past due forecast
NET_ON_HAND NUMBER This value indicates the Net onhand defined for the organization.
PARTNER_ID NUMBER 18 This value indicates the trading partner identifier generated during planning collections.
ORGANIZATION_NAME VARCHAR2 240 Yes This column indicates the organization name.
MASTER_ORGANIZATION_ID NUMBER 18 This column indicates the master organization identifier.
CALENDAR_CODE VARCHAR2 22 CALENDAR_CODE of the given Calendar
CALENDAR_EXCEPTION_SET_ID NUMBER Unique id for the calendar exception set
OPERATING_UNIT NUMBER This value indicates OPERATING_UNIT.
PROJECT_REFERENCE_ENABLED NUMBER This flag indicates whether the project reference is enabled. 1-Yes, 2-No.
PROJECT_CONTROL_LEVEL NUMBER This value indicates the update date of the program.
DEMAND_LATENESS_COST NUMBER Cost incurred when the demand is met late.
SUPPLIER_CAP_OVERUTIL_COST NUMBER Supplier capacity overutilization cost specified as per ASL agreements.
RESOURCE_CAP_OVERUTIL_COST NUMBER Resource capacity overutilization cost of the organization.
DEFAULT_DEMAND_CLASS VARCHAR2 34 Indicates the default demand class
MODELED_CUSTOMER_ID NUMBER 18 This is the organization that is modeled as a customer.
MODELED_CUSTOMER_SITE_ID NUMBER 18 This is the organization that is modeled as a customer site.
MODELED_SUPPLIER_ID NUMBER 18 This is the organization that is modeled as a supplier.
MODELED_SUPPLIER_SITE_ID NUMBER 18 This is the organization that is modeled as a supplier site.
TRANSPORT_CAP_OVER_UTIL_COST NUMBER Transport capacity over utilization cost value.
USE_PHANTOM_ROUTINGS NUMBER This flag indicates whether phantom routings can be used during manufacturing.
INHERIT_PHANTOM_OP_SEQ NUMBER Flag indicates whether phantom option operation sequence number is inherited.
DEFAULT_ATP_RULE_ID NUMBER 18 Indicates the default ATP rule id
COMPANY_ID NUMBER 18 Unique id assigned to the company
ORG_SUPPLIER_MAPPED VARCHAR2 1 This value indicates whether the organization is mapped to the supplier.
ACCEPT_DEMANDS_FROM_UNMET_PO NUMBER Flag indicates whether to accept demands from unmet PO for supplier modeled org. 1-Yes, 2-No.
INHERIT_OC_OP_SEQ_NUM NUMBER Flag indicates whether option class operation sequence number is inherited.
SR_BUSINESS_GROUP_ID NUMBER 18 This value indicates the source side business group identifier.
SR_LEGAL_ENTITY NUMBER Source side value of the legal entity of the organization.
SR_SET_OF_BOOKS_ID NUMBER 18 Source side value of the Set of Books identifier.
SR_CHART_OF_ACCOUNTS_ID NUMBER 18 Source side value of the chart of accounts identifier.
BUSINESS_GROUP_NAME VARCHAR2 240 Business group for the organization record.
LEGAL_ENTITY_NAME VARCHAR2 240 This column indicates the Legal name for the entity.
OPERATING_UNIT_NAME VARCHAR2 240 This value indicates OPERATING_UNIT_NAME.
MATERIAL_ACCOUNT NUMBER This value indicates the material account for the organization.
EXPENSE_ACCOUNT NUMBER Expense account of the organization.
ORGANIZATION_TYPE NUMBER This value indicates the type of organization.
SERVICE_LEVEL NUMBER 18 Service level specified in the shipping method.
CUSTOMER_CLASS_CODE VARCHAR2 30 Stores the customer class code of a customer
CURRENCY_CODE VARCHAR2 30 Currency associated with amounts
WEIGHT_UOM VARCHAR2 30 This value indicates the unit of measure defined in terms of weight.
MAXIMUM_WEIGHT NUMBER This value indicates the maximum weight set.
VOLUME_UOM VARCHAR2 30 This value indicates the unit of measure defined in terms of volume.
MAXIMUM_VOLUME NUMBER This value indicates the maximum volume set.
REFRESH_NUMBER NUMBER Refresh identifier populated by the collection program.
BUSINESS_UNIT_NAME VARCHAR2 240 Business Unit of the Organization.
PAST_DUE_FORECAST_DAYS NUMBER The number of days of past due forecasts to include in plans. No value indicates include all past due forecasts; zero indicates include no past due forecasts. This value does not apply to independent demands derived from assemble-to-order models.
BUSINESS_UNIT_ID NUMBER 18 Business unit the organization belongs to as per HCM setup.
OPERATING_UNIT_ID NUMBER 18 This value indicates Operating Unit Identifier.
DROP_SHIP_VAL_ORG_FLAG NUMBER 1 Indicate the organization is validation organization for drop ship
FIXED_DATE_ENABLED_FLAG NUMBER 1 Indicate the organization should use the fixed date set in profile MSC_FIXED_DATE
PAST_DUE_SO_DAYS NUMBER 9 days before plan date to include past due sales order
PAST_DUE_SUPPLY_DAYS NUMBER 9 days before plan date to include past supplies
PLANT_FLAG NUMBER Flag to indicate if the organization is a manufacturing plant or not. 1 -Yes, 2 -No.
TIMEZONE_CODE VARCHAR2 64 Stores the time zone code for the organization
ABC_ASSIGNMENT_GROUP_NAME VARCHAR2 40 Default ABC assignment group for organization. Obsolete
USE_CUST_FOR_XFER_FLAG NUMBER 1 This column helps collections to identify the customer and customer-site to use for transfer org scenario.
SUBINV_PLANNING_ENABLED NUMBER Indicates if the org is enabled for sub inventory level planning.
ABC_ASSIGNMENT_GROUP_ID NUMBER 18 This column identifies ABC Assignment Group id
SALES_ORDER_COLL_START DATE Indicates the time when last sales order collection started. This column is populated by collection flow. If current order promising request time is between SALES_ORDER_COLL_START and SALES_ORDER_COLL_END then order promising will write these requests to MSC_HVGOP_LATEST_DEMANDS table. Null value indicates no need to store demands separately.
SALES_ORDER_COLL_END DATE Indicates the time when last sales order collection ended. This column is populated by collection flow. If current order promising request time is between SALES_ORDER_COLL_START and SALES_ORDER_COLL_END then order promising will write these requests to MSC_HVGOP_LATEST_DEMANDS table. If SALES_ORDER_COLL_START is Not Null and SALES_ORDER_COLL_END is Null it means the Collection has started but it's not finished yet, which means the processed demands still need to be stored in MSC_HVGOP_LATEST_DEMANDS.
SO_REFRESH_NUMBER NUMBER Refresh identifier populated by the collection program for Sales Order Entity. This will help to stamp Sales Order Coll End Time using this SO_REFRESH_NUMBER column.
ENABLE_IOT_FLAG NUMBER 1 Contains one of the following values: 1 or 2. If 1, then the plant is integrated to Oracle Internet of Things Cloud Service. If 2, then the plant is not integrated. The default value is 2.
EXTERNAL_MANUFACTURER_SUPPLIES NUMBER 1 This column value is 1 if particular organization is a contract manufacturing organization (supplier modeled as an organization) else 2
LAST_DEM_TARGET_COLL_DATE TIMESTAMP 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 MSC_HVGOP_IAP table then cache is stale and needs recomputation. Null value indicates that cache needs to be recomputed.
LAST_SUP_TARGET_COLL_DATE TIMESTAMP 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 MSC_HVGOP_IAP table then cache is stale and needs recomputation. Null value indicates that cache needs to be recomputed.
LAST_POPR_TARGET_COLL_DATE TIMESTAMP This column indicates the date when the POPR target collection ran for the respective organization. This will be used for rebaselining the supplier demand in supplier capacity flow.
COLLECT_NONNETTABLE_PAR_SUBINV NUMBER Indicates whether to collect item subinventories for PAR enabled non-nettable subinventories.
LAST_WO_RES_TARGET_COLL_DATE TIMESTAMP This column indicates the date when the Work Order Operation Resource target collection ran for the respective organization. This will be used for rebaselining the demand portion of resource.
CUTOFF_TIME NUMBER This column stores the shipping cut off time of respective organization in minutes. The value ranges from 0 to (24*60) -1
ORG_SPECIFIC_SUBST_EXISTS NUMBER 1 Flag indicates if there are any organization specific substitution records. Value values are 1 (Yes) and 0 or null (No).
PICK_PACK_LEAD_TIME NUMBER This column stores the pick-pack lead time for respective org for preparing shipment

Foreign Keys

Table Foreign Table Foreign Key Column
MSC_PARAMETERS msc_parameters ORGANIZATION_ID
msc_reservations msc_parameters ORGANIZATION_ID
msc_items_addtl_attrib msc_parameters ORGANIZATION_ID
msc_sub_inventories msc_parameters ORGANIZATION_ID
msc_demands msc_parameters ORGANIZATION_ID
msc_routings msc_parameters ORGANIZATION_ID
msc_supplies msc_parameters ORGANIZATION_ID
msc_parameters msc_parameters ORGANIZATION_ID

Indexes

Index Uniqueness Tablespace Columns
MSC_PARAMETERS_N1 Non Unique Default MASTER_ORGANIZATION_ID, ORGANIZATION_ID
MSC_PARAMETERS_U1 Unique Default ORGANIZATION_ID
MSC_PARAMETERS_U3 Unique Default ORGANIZATION_CODE