Planned Order For A Supplier Not Showing Proper Split As Per Sourcing Rule - Sourcing History Not Collected Correctly
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 220.127.116.11 to 12.2.1 [Release 11.5 to 12.2]
Information in this document applies to any platform.
11.5.10 in Production and Test
with patch 10077340 collection rollup #35
Supplier Sourcing history is not collected for the correct supplier site.
Supplier site is MONTEVIDEO and is same supplier site in multiple OU - so we have multiple records in msc_tp_site_id_lid for single record in msc_trading_partner_sites
-- this is normal and expected.
BUT - Supplier sourcing history is for wrong supplier site and shows qty = ZERO, so planning does not split sourcing correctly.
Run collections for sourcing history
Compare the records and see the supplier site is wrong one.
-- it is using site_id that matches row in msc_trading_partner_sites and not the site_id which is mapped via msc_tp_site_id_lid
get right sourcing history so planning will be accurate.
cannot use this planning result and sourcing split is completely wrong.
PARTNER_SITE_ID - 31323069
SR_TP_SITE_ID - 264552
Compare data in MRP_AP_VENDOR_SITES_V
and find that all 12 rows are collected for this same site - each for different OU
All this looks correct
Then check the data in
Sourcing history table
This should be showing SR_TP_SITE_ID as 224357
which is the same site in the sourcing rule in MRP data.
Also check the data in the source side and see all history is for this same site id 224357
checked code and gave SQL from MSC_CL_MISCELLANEOUS.load_sourcing_history and it shows multiple rows - including the correct row for our sr_tp_site_id
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms