Cannot Invoke Rest Services Due to Error: oracle.tip.adapter.apps.AppsStoredProcedureInteractionSpec.setIsIsgRest(Ljava/lang/String;)V (Doc ID 2466214.1)

Last updated on DECEMBER 08, 2022

Applies to:

Symptoms

On : 12.1.3 version, Performance

When attempting to invoke a service,
the following error occurs.

ERROR
-----------------------

Response
ISGServiceFault>
  <Code>ISG_SERVICE_EXECUTION_ERROR</Code>
  <Message>Error occurred while executing the web service request</Message>
  <Resolution>System error, please see service log trace for details.</Resolution>
  <ServiceDetails>
      <ServiceName>user</ServiceName>
      <OperationName>validate_user_name</OperationName>
      <InstanceId>0</InstanceId>
  </ServiceDetails>
</ISGServiceFault>

Log file:

Wed Sep 12 11:34:16 PDT 2018 : [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' : oracle.apps.fnd.isg.app.ebs.rt.rest.provider.AbstractServiceProvider.servicePOSTRequest : In AbstractServiceProvider throwable. Error: oracle.tip.adapter.apps.AppsStoredProcedureInteractionSpec.setIsIsgRest(Ljava/lang/String;)V
Wed Sep 12 11:34:16 PDT 2018 : [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' : oracle.apps.fnd.isg.app.ebs.rt.common.ErrorContext.makeRestException : ErrorContext -> ErrorCode = null, ErrorMessage = null
Wed Sep 12 11:34:16 PDT 2018 : [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' : oracle.apps.fnd.isg.app.ebs.rt.common.ErrorContext.makeRestException : ISGException -> ErrorCode = ISG_SERVICE_EXECUTION_ERROR, ErrorMessage = Error while executing service !!
Wed Sep 12 11:34:16 PDT 2018 : [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' : oracle.apps.fnd.isg.app.ebs.rt.common.ErrorContext.makeRestException : ISGException -> Not a custom error
Wed Sep 12 11:34:17 PDT 2018 : [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' : oracle.apps.fnd.isg.common.util.IRepAccess.getErrMsg : Error Msg cooresponding to the Error Code=ISG_SERVICE_EXECUTION_ERROR is Error occurred while executing the web service request
Wed Sep 12 11:34:17 PDT 2018 : [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' : oracle.apps.fnd.isg.common.util.IRepAccess.getErrMsg : Error Msg cooresponding to the Error Code=ISG_SERVICE_EXECUTION_ERROR is Error occurred while executing the web service request
Wed Sep 12 11:34:17 PDT 2018 : [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' : oracle.apps.fnd.isg.common.util.IRepAccess.getResolution : Resolution cooresponding to the Error Code=ISG_SERVICE_EXECUTION_ERROR is System error, please see service log trace for details.
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Invoke a service using rest client

Cause

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