Workflow Account Password Update from Backend in EBS

In Oracle E-Business Suite (EBS), workflow account passwords can be updated directly from the backend database. The system only accepts encrypted values of the password — plain text passwords will not work.

To update the workflow account password for Inbound and Outbound parameters, execute the following SQL commands with a dummy encrypted value (example shown below):


-- Update Workflow Inbound Account Password
set define off;
update APPLSYS.FND_SVC_COMP_PARAM_VALS
   set PARAMETER_VALUE = 'ENCRYPTED_VALUE'
 where PARAMETER_ID = (
       select parameter_id
         from APPLSYS.FND_SVC_COMP_PARAMS_B
        where parameter_name = 'INBOUND_PASSWORD');

commit;

-- Update Workflow Outbound Account Password
set define off;
update APPLSYS.FND_SVC_COMP_PARAM_VALS
   set PARAMETER_VALUE = 'ENCRYPTED_VALUE'
 where PARAMETER_ID = (
       select parameter_id
         from APPLSYS.FND_SVC_COMP_PARAMS_B
        where parameter_name = 'OUTBOUND_PASSWORD');

commit;


Example :

set define off
update APPLSYS.FND_SVC_COMP_PARAM_VALS set 
PARAMETER_VALUE= '_@#0@##^90@#!9$4#@@$6!!!9#0@`$B9+}*0&9&@0&8#|'
where
PARAMETER_ID=
( select parameter_id from APPLSYS.FND_SVC_COMP_PARAMS_B 
where parameter_name = 'INBOUND_PASSWORD');


 Key Notes:

Replace DUMMY_ENCRYPTED_VALUE with the actual encrypted password string.
Only encrypted values are valid. The backend will not accept plain text passwords.
Ensure you commit the changes after execution.