How to Update "Site Name" Profile Option in Oracle EBS from Backend (SQL) — Quick and Easy


In Oracle E-Business Suite (EBS), the profile option called "Site Name" helps identify the environment (e.g., Development, UAT, Production).
Sometimes after a clone or environment refresh, you may want to change this value to reflect the new environment (like from Production to TEST) directly from the backend.

Here’s a simple step-by-step guide to update the Site Name profile via SQL.

Step 1: Check Current "Site Name" Value

Connect to the database as APPS user and run:


SELECT profile_option_value
FROM apps.FND_PROFILE_OPTION_VALUES
WHERE profile_option_id = 125;

Output:


PROFILE_OPTION_VALUE
--------------------------------------------
Production Instance

This shows the current value of "Site Name".

Step 2: Update the "Site Name" to Your New Value

For example, to set the site name as:


TEST Refreshed from Production on : 13-JUN-2025

Run:

UPDATE apps.FND_PROFILE_OPTION_VALUES
SET profile_option_value = 'TEST Refreshed from Production on : 13-JUN-2025'
WHERE profile_option_id = 125;

 This updates the value in the backend.

Step 3: Verify the Update

Check if the value has been updated correctly:


SELECT profile_option_value
FROM apps.FND_PROFILE_OPTION_VALUES
WHERE profile_option_id = 125;

Output:


PROFILE_OPTION_VALUE
--------------------------------------------
TEST Refreshed from Production on : 13-JUN-2025

Step 4: Commit the Change

Finally, commit the change to make it permanent:


COMMIT;





Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment