Update Profile Option
DECLARE
v_old_path VARCHAR2(4000) := '/old/path'; -- Replace with your current path
v_new_path VARCHAR2(4000) := '/new/path'; -- Replace with desired new path
BEGIN
FOR rec IN (
SELECT pov.profile_option_value_id AS pov_id,
pov.profile_option_value AS pov_value,
pov.profile_option_id AS option_id,
pov.level_id AS level_id,
pov.level_value AS level_value
FROM fnd_profile_option_values pov
WHERE pov.profile_option_value LIKE v_old_path || '%'
) LOOP
UPDATE fnd_profile_option_values
SET profile_option_value = REPLACE(rec.pov_value, v_old_path, v_new_path)