Register Executable REST Web Service Fails With Error 500 Internal Error when Invoking It

(Doc ID 2387665.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.6 version, Performance

When attempting to invoke the Register Executable web service,
the following error occurs.

ERROR
-----------------------
500 Internal server error'

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

Input code :
{
 "EXECUTABLE_Input":{
    "RESTHeader":{
       "Responsibility":"OM_SUPER_USER",
       "RespApplication":"ONT",
       "SecurityGroup":"STANDARD",
       "NLSLanguage":"AMERICAN"
    },
    "InputParameters":{
"EXECUTABLE": "WF_PROCESS3",
"APPLICATION":"Custom Programs",
"SHORT_NAME":"WF_PROCESS3",
"EXECUTION_METHOD":"PL/SQL Stored Procedure",
"EXECUTION_FILE_NAME":"fnd_wf_standard.callback"
}
}


}

Output: 500 Internal server error

{
  "ISGServiceFault": {
      "Code": "ISG_SERVICE_EXECUTION_ERROR",
      "Message": "Error occurred while executing the web service request",
      "Resolution": "System error, please see service log trace for details.",
      "ServiceDetails": {
          "ServiceName": "fnd_program",
          "OperationName": "executable",
          "InstanceId": "0"
      }
  }
}


Changes

 

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