Planned Order For A Supplier Not Showing Proper Split As Per Sourcing Rule - Sourcing History Not Collected Correctly (Doc ID 1538166.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 to 12.2.1 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

11.5.10 in Production and Test
with patch 10077340 collection rollup #35

PROBLEM
-------------
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.

STEPS
--------
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


EXPECTED BEHAVIOR
----------------------------
get right sourcing history so planning will be accurate.

BUSINESS IMPACT
----------------------
cannot use this planning result and sourcing split is completely wrong.

  msc_trading_partner_Sites
  PARTNER_SITE_ID - 31323069
  SR_TP_SITE_ID - 264552

  Compare data in MRP_AP_VENDOR_SITES_V
  and msc_tp_site_id_lid
  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

  SR_TP_SITE_ID HISTORICAL_ALLOCATION
  264552                       0
  220035                     22,426

  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

Cause

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