Assignment Set
After creating the sourcing rules, the next step is to group the sourcing rules into a set called as Assignment Set.
The assignment set is given in the plan options of SPP Plan. The SPP plan will determine the sourcing rules from the assignment set and generate Planned orders.
Functional Details
Navigation -- Service Supply Chain Planner --> Sourcing --> Assign Sourcing Rules
Important Fields
Assignment Set - Name of the assignment set
Description - Description of the assignment set
Assignments Block
Sourcing Tab
Assigned To - Every sourcing rule can be assigned at different levels as shown below.
Item-Instance-Organization - Sourcing rule will be applicable to the item given in the Item/Category field and organization given in the Instance/Org field.
Instance-Organization - Sourcing rule will be applicable to all the items of the organization given in the Instance/Org field
Category-Instance-Org - Sourcing rule will be applicable to all the items under the category given in the Item/Category field and organization given in the Instance/Org field.
Instance/Org - Source Instance code and the organization
Item/Category - Item or category to be enetered if the sourcing rule is being assigned at item level or category level
Type - Sourcing Rule
Sourcing Rule/BoD - Sourcing Rule Name
Condition - If the sourcing rule is for movement of usable parts then the condition will be 'Usable'. If the sourcing rule is for movement of defective parts then the condition will be 'Defective'
Region/Zone - Region or Zone to be entered if the sourcing rule is being assinged at region level or Zone level.
Supply Allocation Tab
Supply Allocation rules are to be entered if we want to enable fairsharing between organizations.
Assigned to - One of 'Instance-Org', 'Category-Instance-Org', 'Item-Instance-Org'
Instance/Org - Source Instance code and the organization
Item/Category - Item or category to be enetered if the sourcing rule is being assigned at item level or category level
Allocation Rule - Fairshare rule name
Technical Details
The tables involved in the assignment set are given below
1) Assignment set name is stored in -- MSC_ASSIGNMENT_SETS
2) Assignment block details are stored in -- MSC_SR_ASSIGNMENTS
SQL Query
select assignment_set_id,
sr_instance_id,
assignment_set_name,
description
from msc_assignment_sets
where assignment_set_name = 'assignment set name';
--For Sourcing Tab
select assignment_id,
assignment_set_id,
assignment_type,
sourcing_rule_id,
organization_id,
sr_instance_id,
inventory_item_id,
category_set_id,
category_name
from msc_sr_assignments
where assignment_set_id = 'assignment set id';
-- For Supply Allocation Tab
select assignment_id,
assignment_set_id,
assignment_type,
sourcing_rule_id,
organization_id,
sr_instance_id,
inventory_item_id,
category_set_id,
category_name
from msc_sr_assignments
where sourcing_rule_id = -1
-- sourcing rule will be -1 for all fairshare rules
and assignment_Set_id = 'assignment set id';
After creating the sourcing rules, the next step is to group the sourcing rules into a set called as Assignment Set.
The assignment set is given in the plan options of SPP Plan. The SPP plan will determine the sourcing rules from the assignment set and generate Planned orders.
Functional Details
Navigation -- Service Supply Chain Planner --> Sourcing --> Assign Sourcing Rules
Important Fields
Assignment Set - Name of the assignment set
Description - Description of the assignment set
Assignments Block
Sourcing Tab
Assigned To - Every sourcing rule can be assigned at different levels as shown below.
Instance-Organization - Sourcing rule will be applicable to all the items of the organization given in the Instance/Org field
Category-Instance-Org - Sourcing rule will be applicable to all the items under the category given in the Item/Category field and organization given in the Instance/Org field.
Instance/Org - Source Instance code and the organization
Item/Category - Item or category to be enetered if the sourcing rule is being assigned at item level or category level
Type - Sourcing Rule
Sourcing Rule/BoD - Sourcing Rule Name
Condition - If the sourcing rule is for movement of usable parts then the condition will be 'Usable'. If the sourcing rule is for movement of defective parts then the condition will be 'Defective'
Region/Zone - Region or Zone to be entered if the sourcing rule is being assinged at region level or Zone level.
Supply Allocation Tab
Supply Allocation rules are to be entered if we want to enable fairsharing between organizations.
Assigned to - One of 'Instance-Org', 'Category-Instance-Org', 'Item-Instance-Org'
Instance/Org - Source Instance code and the organization
Item/Category - Item or category to be enetered if the sourcing rule is being assigned at item level or category level
Allocation Rule - Fairshare rule name
Technical Details
The tables involved in the assignment set are given below
1) Assignment set name is stored in -- MSC_ASSIGNMENT_SETS
2) Assignment block details are stored in -- MSC_SR_ASSIGNMENTS
SQL Query
select assignment_set_id,
sr_instance_id,
assignment_set_name,
description
from msc_assignment_sets
where assignment_set_name = 'assignment set name';
--For Sourcing Tab
select assignment_id,
assignment_set_id,
assignment_type,
sourcing_rule_id,
organization_id,
sr_instance_id,
inventory_item_id,
category_set_id,
category_name
from msc_sr_assignments
where assignment_set_id = 'assignment set id';
-- For Supply Allocation Tab
select assignment_id,
assignment_set_id,
assignment_type,
sourcing_rule_id,
organization_id,
sr_instance_id,
inventory_item_id,
category_set_id,
category_name
from msc_sr_assignments
where sourcing_rule_id = -1
-- sourcing rule will be -1 for all fairshare rules
and assignment_Set_id = 'assignment set id';
