L3 Support
  1. L3 Support
  2. LS-739

Fixed Numbers Location tagging missing NEP

        Details

        • Type: CR CR
        • Status: Cancelled Cancelled (View Workflow)
        • Priority: Urgent Urgent
        • Resolution: Cancelled
        • Component/s: FN
        • Labels:
          None Labels
        • Customer:
          OMAN-Tel
        • Product:
          NEP

          Description

          Dear @Abir Messaikeh@Zein Trabelsi@Ayed Bada,

          We've observed an issue where the exchange value is not being populated for subscriber 6500 in both the fn_fiber_trail_mv and fn_copper_trail_mv materialized views.

          To resolve this data gap, can we implement a VLOOKUP (or equivalent join/query logic) to retrieve and map the correct exchange for the subscriber?

          The proposed mapping logic would be:
          1. Look up the subscriber ID (e.g., '6500') within the fn_fiber_trail_mv and fn_copper_trail_mv views.
          2. Use the retrieved subscriber ID to join with the master fn_subscriber table.
          3. Extract the corresponding exchange from the fn_subscriber table and use it to update/reflect the correct exchange for the subscriber records in the trail views.

          Please let me know if this approach is feasible and when we can expect the fix to be implemented.

            Activity

            Ascending order - Click to sort in descending order
            Abir Messaikeh made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2025-10-24 24:00 (milestone: set planned start date to due date)
            Planned End 2025-10-24 24:00 (milestone: set planned end date to due date)
            Abir Messaikeh made changes -
            Attachment MSISDN.csv [ 120111 ]
            Abir Messaikeh made changes -
            Assignee Khaled Khalil [ kkhalil ] Shamim Ahmed [ sahmed ]
            Abir Messaikeh made changes -
            Reporter Abir Messaikeh [ amessaikeh ] Shamim Ahmed [ sahmed ]
            Abir Messaikeh made changes -
            Status Opened [ 1 ] Need More Info [ 10011 ]
            Hide
            Permalink
            Abir Messaikeh added a comment -

            checking if still required

            Show
            Abir Messaikeh added a comment - checking if still required
            Hide
            Permalink
            Abir Messaikeh added a comment -

            checked wirh shamim , nothing required for now , closing the ticket

            Show
            Abir Messaikeh added a comment - checked wirh shamim , nothing required for now , closing the ticket
            Abir Messaikeh made changes -
            Status Need More Info [ 10011 ] Cancelled [ 10013 ]
            Resolution Cancelled [ 10100 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Opened Opened Need More Info Need More Info
            		10m 2s 1 Abir Messaikeh 20/Oct/25 2:33 PM
            Need More Info Need More Info Cancelled Cancelled
            		63d 2h 8m 1 Abir Messaikeh 22/Dec/25 3:42 PM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Shamim Ahmed
                Reporter:
                Shamim Ahmed
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:
                  Planned Start:
                  Planned End:

                  Drag and Drop