Unable to Add or Deactivate Service Point Error: "Meter Location ... not found"
(Doc ID 3022098.1)
Last updated on MAY 20, 2024
Applies to:
Oracle Utilities Customer Cloud Service - Version 23C and laterOracle Utilities Customer to Meter Base - Version 2.8.0.0.0 and later
Information in this document applies to any platform.
Symptoms
Getting an error attempting to Add or Deactivate a Service Point(SP).
Service Point has the Device Location 'Extendable Lookup' populated with the Device Location configuration loaded but when Adding or Deactivating a SP, an error is presented with the message 'Meter Location <VALUE> not found':
When attempting to deactivate a Service Point, such as one created from a migration data import:
The meter location is not populated on the CCB SP or Asset Location database tables.
This can be confirmed by the following database queries:
select sp_id,sp_type_cd,sp_status_flg,mtr_loc_cd,mtr_loc_details from CI_SP where SP_ID='<CCBID>'; --CCB Service Point ID
SELECT D1_SP_ID, TRIM(EXTRACTVALUE(xmlparse(content bo_data_area),'deviceLocation')) device_location, TRIM(EXTRACTVALUE(xmlparse(content bo_data_area),'deviceLocationDetails')) device_location_details from D1_SP where D1_SP_ID='<MDMID>'; --Service Point ID
SELECT node_id, TRIM(EXTRACTVALUE(xmlparse(content bo_data_area),'siteLocation')) device_location, TRIM(EXTRACTVALUE(xmlparse(content bo_data_area),'siteLocationDetail')) site_location_detail from W1_NODE where node_id='<ALOCID>'; --Asset Location ID
The SP mapping can also be found in this database table:
select * from D1_SP_IDENTIFIER where d1_sp_id='<MDMID>';
Related service point IDs:
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |