[LS-917] NEW Attribute to add in 5g cell report SSB frequency Created: 04/Feb/26  Updated: 25/Feb/26  Due: 04/Feb/26  Resolved: 23/Feb/26

Status: Closed
Project: L3 Support
Component/s: NEP
Affects Version/s: None
Fix Version/s: None

Type: CR Priority: Normal
Reporter: Priyasha Tiwari Assignee: Srishti Kashyap
Resolution: Fixed Votes: 0
Labels: NEP_D
Σ Remaining Estimate: 0 minutes Remaining Estimate: 0 minutes
Σ Time Spent: 4 days, 3 hours, 30 minutes Time Spent: 4 days, 3 hours, 30 minutes
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: File 20260216_V_5G_CELL_REPORT_DBVIEW.sql     File Ericsson_xml.rar     File Nokia_xml.rar    
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
LS-920 NEW Attribute to add in 5g cell repor... Technical task Open Bug Khaled Khalil  
LS-919 NEW Attribute to add in 5g cell repor... Technical task Open Bug Khaled Khalil  
Customer:
Airtel India
Planned Start:
Planned End:
Actual Start:
Date of Baselining:

 Description   

TO ADD NEW ATTRIBUTE TO 5 CELL REPORT (SSB FREQUENCY).. ADD THIS DATA IN LAST OF THIS REPORT

The Attribute type is a number (Long)
Add the attribute to the model (and share it with AI team for parsing)
The new parameter shall be considered in:
Import from XML/CSV for 5G cells
Reports of 5G cells
Edit Panels OF 5G cells
DB Views: 5G_cell_report



 Comments   
Comment by Marwan Kanaan [ 04/Feb/26 ]

this is a CR not a bug

Comment by Srishti Kashyap [ 05/Feb/26 ]

Hi Dear
Build 3.7.71.556 is release with attribute ssbFrequency added in model of 5g cell.

Comment by Abir Messaikeh [ 12/Feb/26 ]

incomplete

Comment by Priyasha Tiwari [ 12/Feb/26 ]

AI patch releases, model attribute only added to database, all other changes to be done

Import from XML/CSV for 5G cells
Reports of 5G cells
Edit Panels OF 5G cells
DB Views: 5G_cell_report

Comment by Marwan Kanaan [ 12/Feb/26 ]

Dear @Priyasha Tiwari,

The patch has been handed over to Srishti for testing on the DB clone environment, as my local schema currently has significant missing data.

Once the DB view is delivered by the Integration team, I will proceed with updating it accordingly.

Best Regards,
Marwan Kanaan I Software Developer

Comment by Marwan Kanaan [ 16/Feb/26 ]

Dear @Integration Support team,

Kindly execute the below query on the target database and restart the server afterward:

ALTER TABLE NRCELL
ADD SSBFREQUENCY NUMBER(25);
COMMIT;

Please note that this query was already included in the latest patch and should have been executed during the deployment phase to prevent the reported issue.

Kindly confirm once completed.

Best Regards,
Marwan Kanaan I Software Developer

Comment by Marwan Kanaan [ 16/Feb/26 ]

Db view handed to srishti to test it

Comment by Marwan Kanaan [ 16/Feb/26 ]

Dear @Priyasha Tiwari,

Kindly find the updated DB view attached.

Best Regards,
Marwan Kanaan I Software Developer

Generated at Fri Apr 17 08:22:16 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.