Database Administration (MOSC)

MOSC Banner

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center