Demand Priority Rules
The SPP planning engine will take the criteria and criteria order defined in the demand priority rules form to give the priority to the different orders like Sales orders, Forecast, Schedule Date etc while creating the planned orders.
Functional Details
Navigation -- Service Supply Chain Planner --> Setup --> Demand Priority Rules
Important Fields
Name - Name of the demand priority rule
Descrption - Description of the rule
Enabled - Checkbox to enable or disable the rule
Criteria Name and Criteria Order
As shown in the above screenshot, the criteria can be, for example:
Schedule Date - The Due date of the orders will be given highest priority
Sales Orders, Forecasts & MDS Entries Priority - Sales Orders collected from source, Forecasts from Demantra will be given the highest priority
SPP Planning Engine will first plan and meet the demands given in the Demand Priority Rule.
The SPP planning engine will take the criteria and criteria order defined in the demand priority rules form to give the priority to the different orders like Sales orders, Forecast, Schedule Date etc while creating the planned orders.
Functional Details
Navigation -- Service Supply Chain Planner --> Setup --> Demand Priority Rules
Important Fields
Name - Name of the demand priority rule
Descrption - Description of the rule
Enabled - Checkbox to enable or disable the rule
Criteria Name and Criteria Order
As shown in the above screenshot, the criteria can be, for example:
Schedule Date - The Due date of the orders will be given highest priority
Sales Orders, Forecasts & MDS Entries Priority - Sales Orders collected from source, Forecasts from Demantra will be given the highest priority
SPP Planning Engine will first plan and meet the demands given in the Demand Priority Rule.
Technical Details
The Demand Priority rules will be stored in the table - MSC_SCHEDULING_RULES
SQL Query
SELECT DISTINCT
msr.meaning, -- Demand Priority Rule Name
MSR.RULE_ID ,
MSR.USAGE_CODE ,
MFG.MEANING , -- Criteria Name
MSR.SEQUENCE_NUMBER -- Criteria Order
FROM MFG_LOOKUPS MFG,
MSC_SCHEDULING_RULES MSR
WHERE MFG.LOOKUP_CODE = MSR.USAGE_CODE
AND MFG.LOOKUP_TYPE = 'MSC_PRIORITY_RULE'
and msr.meaning = 'Demand Priority Rule Name';
The Demand Priority rules will be stored in the table - MSC_SCHEDULING_RULES
SQL Query
SELECT DISTINCT
msr.meaning, -- Demand Priority Rule Name
MSR.RULE_ID ,
MSR.USAGE_CODE ,
MFG.MEANING , -- Criteria Name
MSR.SEQUENCE_NUMBER -- Criteria Order
FROM MFG_LOOKUPS MFG,
MSC_SCHEDULING_RULES MSR
WHERE MFG.LOOKUP_CODE = MSR.USAGE_CODE
AND MFG.LOOKUP_TYPE = 'MSC_PRIORITY_RULE'
and msr.meaning = 'Demand Priority Rule Name';