My Oracle Support Banner

Attempting To Resolve An Address Via The Location Finder Errors With java.lang.NoSuchMethodError (Doc ID 471478.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Field Service - Version 12.0.4 to 12.0.4 [Release 12]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When attempting to resolve an address via the Location Finder, the following error occurs:

ERROR
java.lang.NoSuchMethodError

Steps:
1. Run this script on any Release 12 environment which has the Field Service spatial data:

DECLARE
l_api_version NUMBER;
l_return_status VARCHAR2(1);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000);
l_country VARCHAR2(32);
l_state VARCHAR2(32);
l_city VARCHAR2(32);
l_roadname VARCHAR2(32);
l_postalcode VARCHAR2(32);
l_build_num VARCHAR2(32);
l_alternate VARCHAR2(32);
l_result_array csf_lf_pub.csf_lf_resultarray;
l_count NUMBER;
BEGIN
l_api_version := 1;
l_country := '<COUNTRY>';
l_state := '<STATE>';
l_city := '<CITY>';
l_postalcode := '<POSTAL_CODE>';
l_roadname := '<STREET_NAME>';
l_build_num := '_';
csf_lf_pub.csf_lf_resolveaddress(
p_api_version => l_api_version
, p_init_msg_list => FND_API.G_FALSE
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_country => l_country
, p_state => l_state
, p_city => l_city
, p_postalCode => l_postalcode
, p_roadname => l_roadname
, p_buildingnum => l_build_num
, p_alternate => l_alternate
, x_resultsArray => l_result_array);
DBMS_OUTPUT.put_line('Status : ' || l_return_status );
IF (l_return_status = 'S' OR l_return_status = '1') THEN
l_count := l_result_array.COUNT();
IF (l_count > 0) THEN
FOR i IN 1 .. l_count LOOP
DBMS_OUTPUT.put_line('======================================');
dbms_output.put_line('State = ' || l_result_array(i).state);
dbms_output.put_line('City = ' || l_result_array(i).city);
dbms_output.put_line('Road = ' || l_result_array(i).road);
dbms_output.put_line('Postal = ' || l_result_array(i).postalcode);
dbms_output.put_line('Building = ' || l_result_array(i).buildingnum);
dbms_output.put_line('Accuracy = ' ||
l_result_array(i).accuracy_factor);
dbms_output.put_line('Alternate = ' || l_result_array(i).alternate);
dbms_output.put_line('SegmentID = ' ||
l_result_array(i).locus.sdo_ordinates(5));
dbms_output.put_line('Offset = ' ||
l_result_array(i).locus.sdo_ordinates(6));
dbms_output.put_line('Side = ' ||
l_result_array(i).locus.sdo_ordinates(7));
dbms_output.put_line('Longitude = ' ||
l_result_array(i).locus.sdo_ordinates(2));
dbms_output.put_line('Latitude = ' ||
l_result_array(i).locus.sdo_ordinates(1));
DBMS_OUTPUT.put_line('======================================');
END LOOP;
END IF;
END IF;
EXCEPTION
WHEN OTHERS THEN
BEGIN
DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
END;
END;
/

Changes

 

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
Changes
Cause
Solution
References


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