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

PIR grid data not loading Master data issue

Insert Lucidchart DiagramSend email
    XporterXMLWordPrintable

Details

    • Impediment
    • Resolution: Completed
    • Medium
    • None
    • None
    • Data, S2O
    • None
    • S2O Sprint 17
    • GxP
    • A

    Description

      for ex. for sku F000130986

      MAster data not coming in stage from UDH_DEV so S2O SIQ not able to load data in Mango db 

      AND PIR data reads API from Mongodb not able to populate it.

      Checking with UDH team on master data missing for few of skus e.g. F000019823

       

      For below query in UDH DEV its not populating for Country & MArket

      SELECT  p."country_key", p."region",p."market_key",
      CAST(gch."country_desc" AS NVARCHAR(60)) AS "Country" ,
          CAST(gch."market_desc" AS NVARCHAR(60)) AS "Market" 
          
      FROM "pgsudh_cdm"."apo_country_product_master" p
      LEFT JOIN "pgsudh_cdm"."GLOBAL_COUNTRY_HIERARCHY" AS gch ON
          gch."country_key" = p."country_key"
          AND gch."region_key" = p."region"
          AND gch."market_key" = p."market_key"
      WHERE p."material_key" = 'F000019823' AND p."snp_selection_filter" = 'STO'

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              DADAHN Gaikwad, Nilesh Dadahari
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: