Missing safety days of supply in SIQ

Hi Vinay,

Good Day!

REF - IM42711868

Issue:

For three presentations of Sutent Chile the safety days of supply information is missing in SIQ although in SAP the information is correct.

SUTENT 12.5mg HFC 1x28 BTL CL  F000106576 CL01 SSDOS 47 DAYS not in SIQ

SUTENT 25mg HFC 1x28 BTL CL  F000106574    CL01 SSDOS 48 DAYS NOT in SIQ

SUTENT 50mg HFC 1x28 BTL CL  F000106572    CL01  SSDOS 47 DAYS not in SIW

Analysis:

User has reported few M-HUB SKUs for which Safety DOS is maintained in APO, but same its displayed as 0 in SIQ. On checking, we could see that at location level(CL01), the Safety DOS is fetching value but as its  M-Hub, the SP - [WEB].[SP02_005_SR_Get_Key_Info_OnDemand{*}]  is fetching value from location as ‘CL’ which is having Null value in [dbo].[tbl_Supply_info]. Value is inserted in this table from  SP - {}[dbo]{}.{}[SPROC_200_SR_tbl_Supply_info]{},{*} which is taking data from master table - dbo.imp_BOBJ_APO_Master_Data. However , for M-Hub i.e. country level import delta query, there is no mapping to fetch Safety DOS in master data table , whereas its there at location level query:

In master data, we can see for location length =2, there is no value for Safety DOS :

Requesting your help on how to proceed with this ticket.

Thanks & Regards,

Sarita.