Uploaded image for project: 'OSCAR'
  1. OSCAR
  2. OS-10145

REG IM42810011 - SUPPLY STATUS COMMUNICATION > DATA ISSUE - 'Planner' value in SIQ is not Reflecting APO value for code F055502000

Insert Lucidchart DiagramSend email
    XporterXMLWordPrintable

Details

    • Bug
    • Resolution: Completed
    • Medium
    • 5.5
    • None
    • SR
    • None
    • SR Sprint 107

    Description

      For SKU F055502000 at US19 location, user has maintained APO Demand planner id in APO and its reflecting in UDH as well. However , it is coming as blank in SIQ.

      On checking , we could see that APO Demand Planner value is Null in master data - dbo.imp_bobj_apo_master_data .

      In SP - SP99_001_SR_imp_HANA_APO_Master_Data_Daily_UDH , we are mapping DemandplannerID from [RAW].[imp_UDH_APO_Master_Data_Location] to master data. Here, in this RAW table [RAW].[imp_UDH_APO_Master_Data_Location] ,  DemandplannerID is null so we are getting Null for APO Demand Planner in master data. However this RAW table has value APO Demand Planner field.

      Kindly check if we can map APO Demand Planner instead of DemandplannerID to avoid this issue.

      Attachments

        Activity

          People

            haldes10 Soumya Halder
            kiryke kiryke
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day
                1d