API to Update Concurrent Program Default Parameter Value

Hi All,

While cloning test instances from PROD, the default parameter (File Path) is getting copied from PROD. We though of updating the same via DB using the below update statement:

update fnd_descr_flex_column_usages

set default_value=replace(default_value,'prd','dev')

where default_value like '%prd%' and descriptive_flexfield_name like '%XXXXXX%';

Commit;

This statement is able to update the default parameter value at the Concurrent Program definition however, which submitting the program from SRS window, i an still see the PROD value (prd) instead of the updated value. Please suggest whether any one has faced this issue earlier and am i missing anything. I was thing to have an API to update this table