Concurrent request Error: The executable file for this concurrent program cannot be executed.

 Issue: Concurrent request completed with below Error.

This request finished with an error and produced the following completion message: The executable file /test1/apps/fs2/EBSapps/appl/fnd/12.0.0/bin/XXCUST_PROG for this concurrent program cannot be executed.

ERROR:

The executable file /test1/apps/fs2/EBSapps/appl/fnd/12.0.0/bin/XXCUST_PROG for this concurrent program cannot be executed.

Contact your system administrator or support representative.

Cause:

Verify that the execution path to the executable file

Run the below command

$ls -lrt /test1/apps/fs2/EBSapps/appl/fnd/12.0.0/bin/XXCUST_PROG

Output of the above command shows executable is pointing to a wrong symbolic link

Solution:

1.Create a soft link with the program name as below:

$cd /test1/apps/fs2/EBSapps/appl/fnd/12.0.0/bin/

$ln -s -f $FND_TOP/bin/fndcpesr XXCUST_PROG

2. Re-run the concurrent program and test the issue.

How to update override email address using backend sql query in EBS 11i/12.x?

Query to check Override address in EBS workflow notification Mailer:

SQL>

 select fscpv.parameter_value

    from fnd_svc_comp_params_tl fscpt

    ,fnd_svc_comp_param_vals fscpv

    where fscpt.display_name = 'Test Address'

    and fscpt.parameter_id = fscpv.parameter_id;   

PARAMETER_VALUE

--------------------------------------------------------------------------------

NONE

SQL Query to update Override email address from backend in EBS :

SQL> update fnd_svc_comp_param_vals

set    parameter_value = 'TEST_EMAIL@DOMAIN.COM'

where  parameter_id =

( select parameter_id

 from   fnd_svc_comp_params_tl

 where  display_name = 'Test Address');  

1 row updated.

SQL> commit;

Commit complete.

Verify that override email address is updated:

SQL> select fscpv.parameter_value

    from fnd_svc_comp_params_tl fscpt

    ,fnd_svc_comp_param_vals fscpv

    where fscpt.display_name = 'Test Address'

    and fscpt.parameter_id = fscpv.parameter_id;  

PARAMETER_VALUE

--------------------------------------------------------------------------------

TEST_EMAIL@DOMAIN.COM

SQL>