Sourcing Rules
After the organizations are assigned to the 'Service Supply Chain Planner' responsibility, we need to create sourcing rules.
In a supply chain network, Sourcing Rules define from what all organizations an organization's demand is fulfilled.
If there are more than one organizations, that can replenish an organization 'A',then sourcing rules gives the flexibility to give the Rank and also the Allocation Percentage for each of the replenishing organizations.
Functional Details
Navigation - Service Supply Chain Planner --> Sourcing --> Sourcing Rules
If the system asks for choosing an organization we can choose the organization for which we want to create the sourcing rule for.
Sourcing Rules can be created at Org Level, or Global Level.Global level sourcing rule will be available for all orgs.
Important Fields
Name - Name of the sourcing rule
Description - Description of the sourcing rule
Radio button - All orgs (Global Level) , Org (Org Level)
Check box - Planning Active
This check box will be checked (automatically) only when sum of the allocation percentages of the shipping organizations equals 100 %.The sourcing rule will be valid only when the 'Planning Active' checkbox is checked
Effective Date - The date from/to which the sourcing rule will be effective
Shipping Organizations block
Type - Transfer From, Make At, Buy From, Repair At
Org - Shipping Organization
Inventory Rebalance - Check box to determine if the shipping org is a rebalancing org
Inventory Rebalancing Rank - If there is more than one inventory rebalancing org, then we can sepecify an inventory rebalancing org
Supplier, Supplier Site - Will be populated for Repair Vendor organizations or for Supplier orgs.
Allocation % - The percentage of demand that the shipping org should satisfy.
(If there is more than one shipping org, the allocation % should sum of to 100 %)
Rank - If there are more than one shipping organizations, then the Replenishment order of the orgs.
Shipping Method, Intransit Time - Shipping details between Shipping Organization and the organization for which the sourcing rule is getting created
If Org B is shipping to Org A, then we give the Type as 'Transfer From'
If Org R is a Repair Vendor Org, then we give the Type as 'Repair At'
Rebalancing (Circular sourcing):The key difference between circular sourcing and normal sourcing is that a circular source participates in the supply chain replenishment only in case of excess (or surplus) inventory that will not be needed within a given time fence.
If Org A is rebalancing with Org B, then for circular sourcing to come into effect, it is mandatory to setup a rebalancing relationship between Org B and Org A.
Technical Details
All the tables that are involved in the sourcing rules are given below
Sourcing Rule Name is stored in table - MSC_SOURCING_RULES
The Effective dates of the sourcing entries is stored in table - MSC_SR_RECEIPT_ORG
The source organization details (shipping organizations) are stored in - MSC_SR_SOURCE_ORG
The shipping method is stored in table - MSC_INTERORG_SHIP_METHODS
SQL Queries
1)
select sr_instance_id,
sourcing_rule_id,
sourcing_rule_name,
description,
planning_active,
sourcing_rule_type
from msc_sourcing_rules
WHERE SOURCING_RULE_NAME = 'sourcing_rule_name';
2)
select sr_receipt_id,
sr_instance_id, -- source instance id
sr_receipt_org,
sourcing_rule_id,
effective_date,
disable_date
from msc_sr_receipt_org
where sourcing_rule_id = 'sourcing_rule_id';
3)
select source_organization_id,
circular_src, -- 'Y' if circular source is enabled
circular_src_rank,
allocation_percent,
rank, -- Replensihment Rank
ship_method
from msc_sr_source_org
where sr_receipt_id = 'from msc_sr_receipt_org table';
4)
select from_organization_id,
to_organization_id,
ship_method,
default_flag,
intransit_time,
sr_instance_id
from msc_interorg_ship_methods
where from_organization_id = 'source_org_id'
and to_organization_id = 'to_org_id'
and plan_id = -1;
After the organizations are assigned to the 'Service Supply Chain Planner' responsibility, we need to create sourcing rules.
In a supply chain network, Sourcing Rules define from what all organizations an organization's demand is fulfilled.
If there are more than one organizations, that can replenish an organization 'A',then sourcing rules gives the flexibility to give the Rank and also the Allocation Percentage for each of the replenishing organizations.
Functional Details
Navigation - Service Supply Chain Planner --> Sourcing --> Sourcing Rules
If the system asks for choosing an organization we can choose the organization for which we want to create the sourcing rule for.
Important Fields
Name - Name of the sourcing rule
Description - Description of the sourcing rule
Radio button - All orgs (Global Level) , Org (Org Level)
Check box - Planning Active
This check box will be checked (automatically) only when sum of the allocation percentages of the shipping organizations equals 100 %.The sourcing rule will be valid only when the 'Planning Active' checkbox is checked
Effective Date - The date from/to which the sourcing rule will be effective
Shipping Organizations block
Type - Transfer From, Make At, Buy From, Repair At
Org - Shipping Organization
Inventory Rebalance - Check box to determine if the shipping org is a rebalancing org
Inventory Rebalancing Rank - If there is more than one inventory rebalancing org, then we can sepecify an inventory rebalancing org
Supplier, Supplier Site - Will be populated for Repair Vendor organizations or for Supplier orgs.
Allocation % - The percentage of demand that the shipping org should satisfy.
(If there is more than one shipping org, the allocation % should sum of to 100 %)
Rank - If there are more than one shipping organizations, then the Replenishment order of the orgs.
Shipping Method, Intransit Time - Shipping details between Shipping Organization and the organization for which the sourcing rule is getting created
If Org B is shipping to Org A, then we give the Type as 'Transfer From'
If Org R is a Repair Vendor Org, then we give the Type as 'Repair At'
Rebalancing (Circular sourcing):The key difference between circular sourcing and normal sourcing is that a circular source participates in the supply chain replenishment only in case of excess (or surplus) inventory that will not be needed within a given time fence.
If Org A is rebalancing with Org B, then for circular sourcing to come into effect, it is mandatory to setup a rebalancing relationship between Org B and Org A.
Technical Details
All the tables that are involved in the sourcing rules are given below
Sourcing Rule Name is stored in table - MSC_SOURCING_RULES
The Effective dates of the sourcing entries is stored in table - MSC_SR_RECEIPT_ORG
The source organization details (shipping organizations) are stored in - MSC_SR_SOURCE_ORG
The shipping method is stored in table - MSC_INTERORG_SHIP_METHODS
SQL Queries
1)
select sr_instance_id,
sourcing_rule_id,
sourcing_rule_name,
description,
planning_active,
sourcing_rule_type
from msc_sourcing_rules
WHERE SOURCING_RULE_NAME = 'sourcing_rule_name';
2)
select sr_receipt_id,
sr_instance_id, -- source instance id
sr_receipt_org,
sourcing_rule_id,
effective_date,
disable_date
from msc_sr_receipt_org
where sourcing_rule_id = 'sourcing_rule_id';
3)
select source_organization_id,
circular_src, -- 'Y' if circular source is enabled
circular_src_rank,
allocation_percent,
rank, -- Replensihment Rank
ship_method
from msc_sr_source_org
where sr_receipt_id = 'from msc_sr_receipt_org table';
4)
select from_organization_id,
to_organization_id,
ship_method,
default_flag,
intransit_time,
sr_instance_id
from msc_interorg_ship_methods
where from_organization_id = 'source_org_id'
and to_organization_id = 'to_org_id'
and plan_id = -1;
