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

PCM - 1st Sale Date fetched wrongly (previous correction of material / country mapping do not seem to apply?)

Insert Lucidchart DiagramSend email
    XporterXMLWordPrintable

Details

    • Bug
    • Resolution: Completed
    • Blocker
    • 12.0
    • None
    • NPL
    • None
    • NPL Sprint 3
    • 1st sale date recently modified logic for taking random top 1 value based on material.
    • Design
    • Hide
      Problem Statement

      Users reached out to mention 1st sales date fetched by PCM were incorrect. Issue seems to refer to the AFME cluster markets for which sales dates seems to be fetched based on min date for the location, instead of min date for the country

      Please see 2 examples below:

      PCM 30213 for UAE, indicates 1st sale date of 19Apr24. For this material F000055495, only LB country has a sale...UAE country does not have any sale yet, hence fist sale date should be blank
      PCM 34385 for KW, indicates 1st sales date of 20Nov23. Looking into Daily Hana sales, this reflect the 1s sale date of BH insead of the first sale date of 24Jan24 for KW





      Acceptance Criteria

      Logic previously corrected recently to fetch first sales date based on material and country needs to be checked if still in place

      If not, need to be re instated to make we reflect the correct 1st sale date based on country and not on location


      Show
      Problem Statement Users reached out to mention 1st sales date fetched by PCM were incorrect. Issue seems to refer to the AFME cluster markets for which sales dates seems to be fetched based on min date for the location, instead of min date for the country Please see 2 examples below: PCM 30213 for UAE, indicates 1st sale date of 19Apr24. For this material F000055495, only LB country has a sale...UAE country does not have any sale yet, hence fist sale date should be blank PCM 34385 for KW, indicates 1st sales date of 20Nov23. Looking into Daily Hana sales, this reflect the 1s sale date of BH insead of the first sale date of 24Jan24 for KW Acceptance Criteria Logic previously corrected recently to fetch first sales date based on material and country needs to be checked if still in place If not, need to be re instated to make we reflect the correct 1st sale date based on country and not on location

    Description

      Problem Statement

      Users reached out to mention 1st sales date fetched by PCM were incorrect. Issue seems to refer to the AFME cluster markets for which sales dates seems to be fetched based on min date for the location, instead of min date for the country

      Please see 2 examples below:

      • PCM 30213 for UAE, indicates 1st sale date of 19Apr24. For this material F000055495, only LB country has a sale...UAE country does not have any sale yet, hence fist sale date should be blank
      • PCM 34385 for KW, indicates 1st sales date of 20Nov23. Looking into Daily Hana sales, this reflect the 1s sale date of BH insead of the first sale date of 24Jan24 for KW

       

      Acceptance Criteria

      Logic previously corrected recently to fetch first sales date based on material and country needs to be checked if still in place

      If not, need to be re instated to make we reflect the correct 1st sale date based on country and not on location

       

      Attachments

        Activity

          People

            MAHESP13 Mahesh Gundekar, Pallavi
            ESPAGJ Espagnet, Julien
            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