Attempting to Save a Web Service Failing with "Cannot update the WEB_SVC_OPERATION_PARAM record. DOMAIN_NAME must be set." (Doc ID 1467201.1)

Last updated on SEPTEMBER 02, 2014

Applies to:

Oracle Transportation Management - Version 6.2.0 to 6.2.5 [Release 6.2]
Information in this document applies to any platform.

Symptoms

When editing a WebService configuration, upon saving the WebService, the following error is encountered:

update web_svc_operation_param set wsdl_schema_type_local=?, wsdl_schema_type_namespace=?, is_required=?, is_document=?,
is_attachment=?, is_zipped=?, is_return_value=?, transformer_stylesheet=?, transformer_plugin_gid=?, data_query_type_gid=?,
out_xml_profile_gid=?, encoding_style_uri=?, domain_name=?, is_body_param=? where operation_name=? and parameter_name=?
and web_service_gid=?; [any, http://www.w3.org/2001/XMLSchema, Y, N, N, N, Y, null, null, null, null, null, null, N, process,
result, DOMAIN.WEBSERVICE]

  Cannot update the WEB_SVC_OPERATION_PARAM record. DOMAIN_NAME must be set.

  java.sql.SQLException: ORA-01407: cannot update ("GLOGOWNER"."WEB_SVC_OPERATION_PARAM"."DOMAIN_NAME") to NULL

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms