Unable to Add or Deactivate Service Point Error: "Meter Location ... not found" (Doc ID 3022098.1)

Last updated on MAY 20, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.