1. Tables and Views for SCM
  2. MSS_PLAN_DEFINITIONS

MSS_PLAN_DEFINITIONS

This table stores plan definitions.

Details

  • Schema: FUSION

  • Object owner: MSS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MSS_PLAN_DEFINITIONS_PK

PLAN_ID

Columns

Name Datatype Length Precision Not-null Comments
PLAN_ID NUMBER 18 Yes Identifier of the Production Scheduling plan.
SHORT_PLAN_ID NUMBER Short Plan Id which will be used for creating plan partitions
PLAN_CODE VARCHAR2 300 Yes User defined code of the Production Scheduling plan.
ORGANIZATION_ID NUMBER 18 Yes Organization ID of the Production Scheduling plan.
ORGANIZATION_CODE VARCHAR2 100 Organization code of the Production Scheduling plan.
DESCRIPTION VARCHAR2 2000 Description of the Production Scheduling plan.
SP_PLAN_ID NUMBER 18 Indirect foreign key to the MSC_PLAN_DEFINITIONS table.
SP_PLAN_NAME VARCHAR2 30 This column holds the plan name in MSC_PLAN_DEFINITIONS.
SP_ORGANIZATION_ID NUMBER 18 Organization ID associated with the Supply Panning plan corresponding to the Production Scheduling plan organization ID.
DUPLICATED_FROM_PLAN_ID NUMBER 18 The PLAN_ID of the plan from which this plan was duplicated.
TIMEZONE_CODE VARCHAR2 50 Timezone identifier for the plan.
MAINTENANCE_ENABLED_FLAG VARCHAR2 1 Is the plan maintenance enabled (Y|N)?
HORIZON_DURATION NUMBER Yes User defined scheduling horizon duration.
HORIZON_DURATION_UNIT VARCHAR2 12 Yes Time unit of measure for horizon durations: seconds|minutes|hours|days|weeks.
ANCHOR_TIMESTAMP TIMESTAMP Yes Reference timestamp used to evaluate scheduling horizons and timestamp. The time component also controls the First Cycle Start Time for a multi-stage synchronization environment in the engine.
HORIZON_ANCHOR_BEHAVIOR VARCHAR2 12 Yes Horizon advancement: specifies how the anchor timestamp is applied to the planning time fence: 'Rolling' behavior: evaluated time fence duration is constant, equaling defined value; 'Dynamic' behavior: evaluated time fence duration is computed based on the day-of-week of the ANCHOR_TIMESTAMP and increased by HORIZON_EXTENSION if less than MINIMUM_TIME_FENCE.
USE_ANCHOR_FOR_HORIZON_FLAG VARCHAR2 1 Flag to fix the horizon start to the anchor timestamp (Y/N)
MINIMUM_TIME_FENCE NUMBER For Dynamic Horizon advancement, this is the minimum duration threshold before it is extended by HORIZON_EXTENSION. Uses Horizon Duration Unit.
HORIZON_EXTENSION NUMBER For Dynamic Horizon advancement, this is the amount to add to time fence, other horizons when evaluated time fence hits minimum limit. Uses Horizon Duration Unit.
FIXED_TIME_FENCE_DURATION NUMBER Allows specifying a Fixed Time Fence for all resources in the plan. The Fixed Time Fence could be overridden by individual resources. Uses Horizon Duration Unit.
PUBLISH_HORIZON_DURATION NUMBER The publish horizon duration. If null it inherits the horizon duration. Uses Horizon Duration Unit.
FIRM_PUBLISH_HORIZON_FROM_PTF NUMBER Time duration from the end of the fixed time fence for which work orders will be set to the firm status upon schedule release to Oracle Fusion Scheduling. Uses Horizon Duration Unit.
RES_CAPACITY_HORIZON_DURATION NUMBER Defines the duration of the resource capacity horizon. If null Resource Constrained Horizon is disabled. Uses Horizon Duration Unit.
PAST_DUE_DEMAND_DURATION NUMBER Past due demand duration before horizon start. Uses Horizon Duration Unit.
PAST_DUE_SUPPLY_DURATION NUMBER Past due supply duration before horizon start. Uses Horizon Duration Unit.
LATENESS_TOLERANCE NUMBER Time threshold after which demands and work orders are considered late.
LATENESS_TOLERANCE_UNIT VARCHAR2 10 Time unit of measure for lateness tolerance: seconds|minutes|hours|days|weeks.
HORIZON_START_DATE TIMESTAMP Evaluated Production Scheduling plan horizon start date.
HORIZON_END_DATE TIMESTAMP Evaluated Production Scheduling plan horizon end date.
CALENDAR_HORIZON_START_DATE TIMESTAMP Evaluated global calendar horizon start date.
CALENDAR_HORIZON_END_DATE TIMESTAMP Evaluated global calendar horizon end date.
DATA_HORIZON_START_DATE TIMESTAMP Evaluated data horizon start date, taking demand date, etc. into consideration.
DATA_HORIZON_END_DATE TIMESTAMP Evaluated data horizon end date.
FIXED_TIME_FENCE_EVAL NUMBER Evaluated Fixed Time Fence for all resources in the plan. Uses Horizon Duration Unit.
PLAN_OWNER VARCHAR2 64 Owner of the Production Scheduling plan.
LAST_APPROVED_BY VARCHAR2 64 User who initiated the approve plan action.
APPROVED_FLAG NUMBER 1 Production Scheduling plan approved for use in Supply Planning (1/0)?
LAST_APPROVED_DATE TIMESTAMP Production Scheduling plan last approved Date.
PLAN_APPROVAL_STATUS NUMBER Production Scheduling plan approval status.
BUILD_STRATEGY VARCHAR2 10 The build strategy for fulfilling demand: JIT|PreBuild.
PRE_BUILD_POLICY VARCHAR2 30 The pre-build policy: Balanced|DynamicResourceAllocation|MultiStageSynchronization.
RESOURCE_ALLOCATION_MODE VARCHAR2 40 Controls the resource allocation priorities: EarliestCompletionTime|MinimizeChangeoversAndIdleTimes.
ACCELERATED_DISPATCHING_FLAG VARCHAR2 1 Use accelerated resource dispatching (Y/N)?
WORK_ORDER_GROUP_ATTRIBUTE_ID NUMBER 18 Reference to an attribute ID which will be used to group a series of operation steps (from multiple work orders) together, when using the Dynamic Resource Allocation pre-build policy. Foreign key to MSS_ATTRIBUTES.
REPAIR_UNCONSTRAINED_MODE VARCHAR2 30 Controls the manual scheduling mode for repair: ConstrainedRepairMode|UnconstrainedRepairMode.
REPAIR_SEQUENCING_MODE VARCHAR2 40 Controls the repair sequencing mode: SingleStage|MultiStage|MultiStageIncludeRelatedWorkOrders.
USE_SCHEDULING_BUCKET_FLAG VARCHAR2 1 Use the scheduling bucket defined in the following 3 columns (Y|N)?
SCHEDULING_BUCKET NUMBER The time interval over which demand event and operations should be grouped for the multi-stage synchronization solver algorithm (real number of units).
SCHEDULING_BUCKET_UNIT VARCHAR2 10 Scheduling bucket unit: seconds|minutes|hours|days|weeks.
DRA_PREBUILD_MAXIMUM NUMBER The time interval considered for moving production earlier when using bucket-based DRA sequencing.
DRA_PREBUILD_MAXIMUM_UNIT VARCHAR2 10 DRA prebuild maximum unit: seconds|minutes|hours|days|weeks.
PREBUILD_UPSTREAM_RELAXED_FLAG VARCHAR2 1 Allow production to be pre-built for upstream stages with unconstrained resources (Y|N)?
RESPECT_FIRM_INSIDE_PTF_FLAG VARCHAR2 1 Respect firm dates inside the Planning Time Fence (Y|N)?
FIRM_IN_PTF_ON_REFRESH_FLAG VARCHAR2 1 Automatically firm work orders within the planning time fence during schedule refresh (Y|N)?
WORK_ORDER_UNIT_OF_EFFORT VARCHAR2 30 Schedule work orders according to their unit of effort (minimum transfer quantity): Yes|No|SelectByRouting.
ADJACENT_OPS_PREFERRED VARCHAR2 1 Adjacent Operations Preferred when scheduling with minimum transfer quantity (Y|N)?
USE_SOLVE_TIME_LIMIT_FLAG VARCHAR2 1 Use the solver time limit defined in the following 2 columns (Y|N)?
SOLVE_TIME_LIMIT_DURATION NUMBER The maximum time interval after which the solver stops automatically with a partial plan schedule (real number of units).
SOLVE_TIME_LIMIT_UNIT VARCHAR2 10 Solver time limit unit: seconds|minutes|hours|days|weeks.
LAST_REQUEST NUMBER 5 Last request on the scheduling plan: 0: Refresh, 1: Refresh and Solve, 2: Solve, 3: Repair, 4: Schedule Release, 5: Duplicate Schedule
LAST_REQUEST_ID NUMBER 18 ESS Job ID of the last plan execution.
LAST_EXECUTION_ID NUMBER 18 Execution ID corresponding to a last plan execution session. Foreign key to MSS_PLAN_STATUS.
LAST_REFRESH_DATE TIMESTAMP Completion date-time of last plan refresh session.
LAST_PUBLISH_DATE TIMESTAMP Completion date-time of last schedule publish session.
REQUEST_IN_PROCESS_FLAG VARCHAR2 1 Is there an execution request currently in process (Y|N)?
DEFAULT_RESOURCE_GANTT_GRP_ID NUMBER 18 Reference to resource group ID that filters the resources displayed by default in Resource Gantt view. Foreign key to MSS_GROUPS.
DEFAULT_GANTT_ZOOM_DURATION NUMBER This is the visible zoom duration when first opening the schedule view. Uses Horizon Duration Unit.
PRESERVE_WO_STATUS_FLAG VARCHAR2 1 When the value of this column is set to Yes, the status does not change to ORA_RELEASED while releasing the work order (Y|N).
OPERATION_LABEL_MODE VARCHAR2 80 Operation label display mode: WorkOrderAndOperation|WorkOrderAndItem|ItemAndWorkOrder|ItemAndOperation, default to WorkOrderAndOperation.
RESOURCE_LABEL_MODE VARCHAR2 30 Resource label display mode: ResourceCode|ResourceName, default to ResourceCode.
ALLOW_SAME_ATTR_CHANGEOVER VARCHAR2 1 Allow changeovers between operations that have the same attribute value (Y|N)?
CHANGEOVERS_USE_RES_CALENDAR VARCHAR2 1 Do changeovers need to respect the resource calendar (Y/N)?
INCLUDE_UNRELEASED_SP_ORDERS VARCHAR2 1 Include unreleased planned orders in the schedule (Y/N)?
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.

Foreign Keys

Table Foreign Table Foreign Key Column
MSS_PLAN_DEFINITIONS mss_plan_status LAST_EXECUTION_ID
MSS_PLAN_DEFINITIONS mss_groups PLAN_ID, DEFAULT_RESOURCE_GANTT_GRP_ID

Indexes

Index Uniqueness Tablespace Columns
MSS_PLAN_DEFINITIONS_N1 Non Unique Default LAST_EXECUTION_ID
MSS_PLAN_DEFINITIONS_N2 Non Unique Default PLAN_ID, DEFAULT_RESOURCE_GANTT_GRP_ID
MSS_PLAN_DEFINITIONS_U1 Unique Default PLAN_ID
MSS_PLAN_DEFINITIONS_U2 Unique Default PLAN_CODE