MCA Parameters
Parameters control the model. They can be changed in the UI or directly in the tables. Parameters are stored in two tables: PARAMETERS and FLAGS. Not all the parameters fields are listed below, just some very interesting ones.
The PARAMETERS Table
- Fiscal Year Planning Periods (default 12)
- Number of Years History (default 2) Number of years to be considered for initializing forecasting
- Default Transit Time (default 0) The default transit time that will be applied if not specified in the Location transit time data.
- Default Lead Time (default 0) Default lead time will be applied if part lead time data is not specified. (calendar days)
- Default New Buy Lead Time (default 0) New Buy Lead Time to be used when part does not explicitly specify one (in Calendar days).
- Default Holding Cost Rate (default 0) Default value for annual inventory holding cost rate. This will be used in ROQ calculation if data is not provided with Part master data. Acceptable range: 0 – 1.
- Default Repair Lead Time (default 0) Repair Lead Time to be used when part does not explicitly specify one. (in Calendar days).
- Default Loc Availability Target (default 0) If no availability target is set at a Location SPO will apply this default location availability target. Acceptable Range: 0 – 1.
- Default MTTR (default 0) Default mean time to remove and replace a defective part with good one. (in calendar days)
- Provisioning Initial Stock (default 0) Global TSL starting value for a provisioning case,i.e. if set to 1 the provisioning engine will “seed” all part location TSLs within the case with quantity 1 and start optimization from that point. Acceptable values: Positive Integer
- Snapshot Create Cycle (default 1) Determines how often the what-if script makes copy of production data. Acceptable values: 0 – do not create snapshot except under the condition that no snapshot exists, 1 – make a copy once every month, 2 – every other month, 3 – every quarter
- Number of Data Ready Scenarios (default 3) Number of copies of the most recent snapshot that should be made available (e.g. a value of 2 implies that two scenario schemas based on the most recent snapshot will be made available)
- Request Export Interval (default 0) Sets frequency of job that copies exported requests to X_EXP_PROPOSED_REQUEST table.(interfaces with the execution system)[requires restart]
FLAG Table
- TSL Export Mode (default None) Specifies the criteria by which TSLs should be exported to the Execution System. Acceptable values: FULL, DELTA, NONE.
- SAFETY_STOCK_EXPORT_MODE (default None) Specifies the criteria by which Safety Stock should be exported to the Execution System (FULL or NONE)
- ROP_ROQ_EXPORT_MODE (default None) Specifies the criteria by which ROPs and ROQs should be exported to the Execution System (FULL or NONE)
- DISPLAY_AGGREGATE_FILL_RATE (default T) Configures the SPO Network Aggregate Views to calculate and display Network Fill Rates. NOTE: this configuration only applies when the BACKORDERABLE_LOCATIONS parameter is set to NONE. Acceptable values: T(true), or F(false)
- BACKORDERABLE_LOCATIONS (default All) Specifies the locations that allow backorders when a demand cannot be filled. Acceptable values: NONE, ROOT, ALL
- CURRENT_PERIOD (Default Fixed)This flag is used by Tactics to calculate the current date. If set to FIXED, current date = 1st day of the period in the CURRENT_PERIOD table; if this table is empty, current date = 1st day of the period in which the system date falls. For all other values, current date = system date.
- DEFAULT_REPAIR_SUPPLIER (default Repair) The supplier that will be assigned to repair requests if part-repair_supplier records do not exist for the part.
- DEFAULT_NEW_BUY_SUPPLIER (default New-Buy) The supplier that will be assigned to new-buy requests if part-new-buy_supplier records do not exist for the part.
- STRATEGY_LEAD_TIME_TYPE (default Blended) GENERAL – Use General Lead Time data for strategic optimization, BLENDED – Blend New Buy and Repair Lead Times based on Condemnation Rate. Acceptable values: GENERAL, BLENDED
- INITIAL_TARGET_STOCK_LEVEL (default ZERO) Configures SPO Optimization to use Zero, Current Inventory or Redeployed Inventory as the starting point. Acceptable values: ZERO, CURRENT_INVENTORY, REDEPLOYED_INVENTORY. The REDEPLOYED_INVENTORY option is applicable only in Availability Optimization. Default Value: ZERO