Description
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.
qTest: Test Execution
Attachments
Issue Links
- relates to
-
OS-9666 Missing safety days of supply in SIQ
- Closed