In Release 9.2.1, a new feature added to the Pricing module considers seller assignments when pricelists and pricing rules are evaluated.
This upgrade procedure is optional.
Performing the upgrade procedure improves performance, as the pricing process runs in 9.2.1 mode, which assumes that all previous version records are updated with seller assignments. If it is not done, existing pricelists and pricing rules, which do not have seller assignments, are treated as in previous releases. They are considered to be applicable to all sellers.
To take advantage of the new functionality, use the SQL queries that are provided in the migration strategy.
Set the yfs.pricing.upgrade.complete property to Y after you run the queries.
This optional procedure can be done after all other upgrade tasks are complete.
INSERT INTO YPM_PRCLST_SLR_ASSNMNT (PRCLST_SLR_ASSNMNT_KEY, ENTERPRISE_CODE,
PRICELIST_HDR_KEY, CREATEPROGID, CREATEUSERID, MODIFYPROGID, MODIFYUSERID)
(SELECT PL.PRICELIST_HDR_KEY, PLA.ENTERPRISE_CODE ,
PL.PRICELIST_HDR_KEY, '921_MIGRATOR_001', '921_MIGRATOR_001','921_MIGRATOR_001', '921_MIGRATOR_001'
FROM YPM_PRICELIST_HDR PL, YPM_PRICELIST_ASSIGNMENT PLA WHERE
PLA.PRICELIST_HDR_KEY = PL.PRICELIST_HDR_KEY
AND PL.ORGANIZATION_CODE = PL.SELLER_ORGANIZATION_CODE
AND ( NOT EXISTS (SELECT '1' FROM
YPM_PRCLST_SLR_ASSNMNT WHERE YPM_PRCLST_SLR_ASSNMNT.PRICELIST_HDR_KEY = PL.PRICELIST_HDR_KEY)));
INSERT INTO YPM_PRC_RULE_SLR_ASSNMNT (PRC_RULE_SLR_ASSNMNT_KEY, ENTERPRISE_CODE,
PRICING_RULE_KEY, CREATEPROGID, CREATEUSERID, MODIFYPROGID, MODIFYUSERID)
(SELECT PR.PRICING_RULE_KEY, PRA.ENTERPRISE_CODE ,
PR.PRICING_RULE_KEY, '921_MIGRATOR_001', '921_MIGRATOR_001','921_MIGRATOR_001', '921_MIGRATOR_001'
FROM YPM_PRICING_RULE PR, YPM_PRICING_RULE_ASSIGNMENT PRA WHERE
PRA.PRICING_RULE_KEY = PR.PRICING_RULE_KEY
AND PR.ORGANIZATION_CODE = PR.SELLER_ORGANIZATION_CODE
AND ( NOT EXISTS (SELECT '1' FROM
YPM_PRC_RULE_SLR_ASSNMNT WHERE YPM_PRC_RULE_SLR_ASSNMNT.PRICING_RULE_KEY = PR.PRICING_RULE_KEY)));
UPDATE YPM_PRICING_RULE PR SET PR.SELLER_ORGANIZATION_CODE=PR.ORGANIZATION_CODE WHERE PR.SELLER_ORGANIZATION_CODE is null;
Set the yfs.pricing.upgrade.complete property to Y.
This value indicates that a pricelist or pricing rule that is defined in an older version has a seller assignment. The seller assignment is considered during a price calculation.
If the value is left as the default N, a pricelist or pricing rule without a seller assignment is considered to be applicable to all sellers.