[LS-776] RE: KSA - NEP Inventory sync issue vs NEP DB View Created: 10/Nov/25  Updated: 13/Nov/25  Due: 07/Nov/25

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

Type: CR Priority: Normal
Reporter: Manjit Kumar Assignee: Mustapha Al-Hage
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: 0 minutes
Time Spent: 1 day, 9 minutes
Original Estimate: Not Specified

Customer:
Zain KSA 3.X
Planned Start:
Planned End:
Actual Start:
Date of Baselining:

 Description   

From: Suleiman Kiplangat <Suleiman.K@cybermak.net>
Sent: Friday, November 7, 2025 3:10 PM
To: Daljeet Singh Virdi <Daljeet.Virdi@mobinets.com>; Abir Messaikeh <Abir.Messaikeh@nuiva.com>
Cc: ALM Support <ALM.Support@cybermak.net>; support <support@mobinets.com>; Kosi Ali <Kosi.A@cybermak.net>; Marwan Yousef <Marwan@cybermak.net>
Subject: RE: KSA - NEP Inventory sync issue vs NEP DB View

+++ updating subject.

From: Suleiman Kiplangat <Suleiman.K@cybermak.net>
Sent: Friday, November 7, 2025 3:43 PM
To: Daljeet Singh Virdi <Daljeet.Virdi@mobinets.com>; Abir Messaikeh <Abir.Messaikeh@nuiva.com>
Cc: ALM Support <ALM.Support@cybermak.net>; support <support@mobinets.com>; Kosi Ali <Kosi.A@cybermak.net>; Marwan Yousef <Marwan@cybermak.net>
Subject: NEP Inventory sync issue vs NEP DB View vs
Importance: High

Dear Daljeet/Abir,

Kindly note that we have identified an issue where the NEP Inventory report is not syncing to the NEP DB view as expected.
Site matching was done earlier, resolved on Inventory, but still reporting Auto_Site in DB View.

Sample nodes with an issue in the DB view but okay in Inventory..

AQQ2170_01
AQQ2331_01
AQQ2424_01
AQQ2425_01
AQQ2426_01_NNN
BAH2152_01
BHAB2124
BHMF2137
BHMF2336_02
BHS2361_NNN
BRQ2219_02
BSA2313_01
BSA2313_02
BSA2316
BSA2318
HJR2254
HLA2419_01
JDJZ2071_01
JDJZ2418
MTB2377
MUMA2070
MUMA2337
QLW2370_NNN
QLW2374_01
QLW2376_01
SRA2353_01
SRA2353_02
SRA2355
SRA2359_01
SRA2359_02
SRA2362_01
SRA2362_02
SRA2362_03
TBL2297_01
TBL2319
TBL2328_01_NNN
TNM2082_01
TNM2088_01
TNM2093

We request your urgent support to resolve this ASAP.

Best regards,

Suleiman Kiplangat
ALM Support Team
CyberMAK Information Systems

 Comments   
Comment by Anonymous [ 10/Nov/25 ]

The following script was executed on the KSA database to refresh the database view:

EXEC DBMS_MVIEW.REFRESH('NE_VIEW');

Comment by Bessem Manita [ 10/Nov/25 ]

Dear Manjit,
As mentioned earlier by Abir, the API was disabled, so it’s better to keep it as is and handle the DB refresh separately.
Kindly proceed with creating a new cron job specifically for the DB refresh as done below.

call REFRESH_ASSET_VIEWS();

BR,

Generated at Fri Apr 17 13:28:35 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.