When importing the WSDL: http://www.itis.gov/ITISWebService.xml , the generated request transformation is missing the ns prefixes in the xpath. Also, the namespaces that are added are inconsistent. On one import it they may all be added and on the next, one may be missing.

Generated:

CREATE VIRTUAL PROCEDURE
BEGIN
SELECT t.* FROM XMLTABLE(XMLNAMESPACES(DEFAULT 'http://itis_service.itis.usgs.org', 'http://metadata.itis_service.itis.usgs.org/xsd' AS ax26, 'http://data.itis_service.itis.usgs.org/xsd' AS ax24), '/getCommonNamesFromTSNResponse/return/commonNames' PASSING ITISServiceView.getCommonNamesFromTSN_response.xml_in COLUMNS commonName string PATH '/commonName', "language" string PATH '/language', tsn string PATH '/tsn') AS t;
END

Should be:

CREATE VIRTUAL PROCEDURE
BEGIN
SELECT t.* FROM XMLTABLE(XMLNAMESPACES(DEFAULT 'http://itis_service.itis.usgs.org', 'http://data.itis_service.itis.usgs.org/xsd' AS ax26), '/getCommonNamesFromTSNResponse/return/ax26:commonNames' PASSING xml_in COLUMNS commonName string PATH '/ax26:commonName', "language" string PATH '/ax26:language', tsn string PATH '/ax26:tsn') AS t;
END