1. Tables and Views for SCM
  2. MSC_RECOMMENDATIONS

MSC_RECOMMENDATIONS

This table is created for maintaining the recommendations for list of demands. This is used in Supply Planning Demand Fulfillment View.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

msc_recommendations_PK

PLAN_ID, RECOMMENDATIONS_ID, RECOMMENDATION_TYPE

Columns

Name Datatype Length Not-null Comments
STATUS NUMBER The value indicates the status of the recommendation. 1-Accepted, 2-In review, 3-Pending
ORDER_NUMBER VARCHAR2 240 The order number of the pegged supply. For planned order, the value is transaction_id, for other order type, the value is order_number in msc_supplies table
ORDER_LINE_NUMBER VARCHAR2 100 The order line number of the pegged supply
ORDER_TYPE NUMBER Specifies the type of order: planned order, purchase order, etc.
SOURCE_ORG_ID NUMBER Source organization identifier for inter organization transfers of the pegged supply
ORGANIZATION_ID NUMBER This column indicates the organization identifier of the pegged supply, or overloaded resource capacity
INVENTORY_ITEM_ID NUMBER Identifies the inventory item id of the pegged supply or the overloaded supplier capacity
SUPPLIER_ID NUMBER This value indicates the Supplier identifier of the pegged supply or the overloaded supplier capacity
SUPPLIER_SITE_ID NUMBER This value indicates the Supplier site identifier of the pegged supply or the overloaded supplier capacity.
SUGGESTED_DUE_DATE DATE The end date of the supply (completion date of first unit). This value is from new_schedule_date of the pegged supply in msc_supplies
EXPEDITE_DATE DATE When the recommendation is for the demand at risk due to insufficient lead time, this date is new_schedule_date of the pegged supply. For late supply pegged to forecast and late supply pegged to sales order, this is need_by_date of the pegged supply
EXPEDITE_DAYS NUMBER The number of days the order is recommended to be pulled forward. Expedite days is based on the earliest date that would satisfy all end demands to which the supply is pegged. This is also the maximum lateness of all Late Supply... exceptions for this supply order. When there is a pegged demand with a Demand at risk due to insufficient lead time exception, meaning the order is already in the past, the value is 0.
ORDER_QUANTITY NUMBER This value is new_order_quantity of the pegged supply.
ORDER_VALUE NUMBER The order value of the pegged supply, default to 0.
BOM VARCHAR2 100 The bill of material of the pegged supply.
ROUTING VARCHAR2 300 The work definition of the pegged supply.
PLAN_ID NUMBER Yes This value indicates the plan identifier for the record.
TRANSACTION_ID NUMBER Transaction identifier of the pegged supply.
RECOMMENDATION_TYPE NUMBER Yes The value indicates the recommendation type, 1-Expedite Buy Order, 2-Expedite Transfer Order, 3-Expedite Make Order, 4-Resource Capacity, 5-Supplier Capacity, 6-Resource Capacity Constraints, 7-Supplier Capacity Constraints, 8-Late Maturity Supply.
DEMAND_NAME VARCHAR2 100 The name of the at risk demand.
RESOURCE_ID NUMBER The resource identifier of the resource for the overloaded resource capacity.
DEPARTMENT_ID NUMBER The department identifier associated with the resource for the overloaded resource capacity.
AVAILABLE_RESOURCE_CAPACITY NUMBER Resource Capacity available between Start Constraint Date & End Constraint Date.
TOTAL_RESOURCE_CAPACITY NUMBER Resource Capacity required between Start Constraint Date & End Constraint Date, Requested Capacity - Available Capacity.
REQUESTED_DATE DATE The requested date of the pegged supply.
REQUESTED_QUANTITY NUMBER Supplier Capacity required between From Date & To Date, Requested Capacity - Available Capacity.
AVAILABLE_CAPACITY NUMBER Supplier Capacity available between From Date & To Date.
SHORTAGE_QUANTITY NUMBER Requested Capacity - Available Capacity.
SHORTAGE_PERCENTAGE NUMBER Loaded Supplier Capacity, as a percent of the cumulative available supplier capacity.
EARLIEST_AVAILABLE_DATE DATE The earliest available date of the pegged supply.
RECOMMENDATIONS_ID NUMBER Yes The recommendation identifier. For recommendation of type Expedite Buy Order, Expedite Make Order, Expedite Transfer Order, Late Maturity Supply, this is populated with the value of transaction_id, for recommendation of type Resource Capacity, Supplier Capacity, Resource Capacity Constraints, Supplier Capacity Constraints, this is populated with the value of exception_detail_id*-1.
EXCEPTION_DETAIL_ID NUMBER This is the id of the exception in msc_exception_details for the problem that makes this end demand at risk and is solved by this recommendation. This is populated only for recommendation of type Resource Capacity, Supplier Capacity, Resource Capacity Constraints, Supplier Capacity Constraints.
RESOURCE_START_DATE DATE Date when the current occurrence of resource overload starts.
RESOURCE_END_DATE DATE Date till when the current occurrence of resource overload continues (without worsening).
MATERIAL_AVAILABLE_DATE DATE New_schedule_date of the pegged supply.
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.
PLAN_TYPE NUMBER The plan_type indicates the planning mode of the plan. 1-constrained planning, 2-unconstrained planning.
COMPRESSION_DAYS NUMBER The number of days the supply order starts in the past. If there is a pegged demand with a Demand at risk due to insufficient lead time exception, compression days is the short fall days. When there is no Demand at risk due to insufficient lead time exception for the supply, the value is 0.
RESCHEDULE_DAYS NUMBER Difference between old and new schedule dates for existing supplies, calculated by the planning engine.
RSRC_SUPPL_CAP_CONSTR_DATE DATE The Date column stores either Resource Capacity Constraint Date of exception Resource Capacity Constraint or Supplier Capacity Constraint Date of exception Supplier Capacity Constraint.
ADDTL_RSRC_SUPPL_CAPACITY NUMBER The column stores either Additional Capacity Required by Resource Constraint Date of exception Resource Capacity Constraint or Additional Capacity Required by Supplier Capacity Constraint Date of exception Supplier Capacity Constraint.
MATURITY_DATE DATE The column indicates the date on which the on-hand lot matures.
LOT_NUMBER VARCHAR2 80 The lot number of a particular on-hand lot.

Indexes

Index Uniqueness Tablespace Columns
MSC_RECOMMENDATIONS_U1 Unique Default PLAN_ID, RECOMMENDATIONS_ID, RECOMMENDATION_TYPE