How to change Execution Method of a Concurrent Program Executable

Oracle application will not allow you change execution method if ‘Executable’ is used by any concurrent program. If you need to change it, you may do so using following steps.

1. Download executable using FNDLOAD


2. Open ldt file using some editor such as ‘vi’


3. Change ‘EXECUTION_METHOD_CODE’ and ‘EXECUTION_FILE_NAME’ to desired value.


4. Upload you executable and you are ready to go.

Relevant portion of executable ldt are given below

BEGIN EXECUTABLE "skm_test_sql" "XXONT"
  OWNER = "SMISRA"
  LAST_UPDATE_DATE = "2008/06/01"
  EXECUTION_METHOD_CODE = "I"
  EXECUTION_FILE_NAME = "biv_debug_proc"
  USER_EXECUTABLE_NAME = "skm_test_sql"
END EXECUTABLE