L3 Support
  1. L3 Support
  2. LS-739 Fixed Numbers Location tagging missing NEP
  3. LS-740

Fixed Numbers Location tagging missing NEP Requirements Writing

        Details

        • Type: Technical task Technical task
        • Status: Open Bug Open Bug (View Workflow)
        • Priority: Urgent Urgent
        • Resolution: Unresolved
        • 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

            There are no comments yet on this issue.
            Cancel

              People

              • Assignee:
                Khaled Khalil
                Reporter:
                Abir Messaikeh
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

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

                  Drag and Drop