Tech Trainings

Oracle Cloud ERP -Fusion (SaaS) – Profile Creation and Query to extract

September 4, 2020 by admin

Steps to Create –

As an administrator, here’s how you can set the profile options:

1. In the Setup and Maintenance work area, go to:
   • Task: Manage Profile Options
2. In the Manage Profile Options page, click the New icon in the Profile Options section.
3. In the Create page, specify the details as listed in the table. Set Current date as the Start Date.
4. Click Save and Close.
5. At the Profile Option Levels, set Site to Enabled and Updatable.
6. Click Save and Close.

--Query to fetch profile name, level, value
SELECT
    fpob.profile_option_name,
    fpov.profile_option_value,
    fpov.level_value
FROM
    fnd_profile_option_values  fpov,
    fnd_profile_options_b      fpob
WHERE
        1 = 1
    AND fpob.profile_option_id = fpov.profile_option_id
  --  AND fpov.level_value = 'SITE'
   --AND fpob.profile_option_name = upper(p_profile_name)     ;

Comments |0|