FND Profile Option Values – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
Profile option values on all setup levels. Unlike Oracle’s SQL script from note 201945.1, this report also shows the user visible profile option value in addition to the internal system profile option value.
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
User Profile Name starts with, User Profile Name any lang, Setup Level, Setup Level Value, Application Name, Application Short Name, System Profile Name starts with, Last Update Date From, Last Update Date To, Last Updated By, Profile System Value like, Profile Option Value is null, Redundant
Oracle EBS Tables Used
fnd_application_vl, fnd_profile_options_vl, fnd_profile_option_values, fnd_responsibility_vl, fnd_user, hr_all_organization_units_vl, fnd_nodes
Report Categories
Related Reports
FND Profile Option Value Upload, FND Debug and Trace Settings, FND User Login History, FND Responsibilities, FND Concurrent Requests, FND Responsibility Access, CAC Inventory Organization Summary, CAC Inventory Accounts Setup
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Profile Option Values 11-May-2017 124115.xlsx |
| Blitz Report™ XML Import | FND_Profile_Option_Values.xml |
| SQL Source | FND Profile Option Values.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-profile-option-values/ |
Executive Summary
The FND Profile Option Values report is the definitive tool for auditing system configuration. It shows the value of every profile option at every level (Site, Application, Responsibility, User, Server, Org).
Business Challenge
- Troubleshooting: Investigating why a user sees different behavior than others (often due to a User-level profile override).
- Environment Comparison: Checking if the “Site” level profiles match between PROD and TEST.
- Security Audit: Verifying that critical security profiles (e.g., “Signon Password Hard to Guess”) are set correctly.
The Solution
This Blitz Report lists the profile values:
- Profile Name: The user-friendly name (e.g., “MO: Operating Unit”).
- Level: The hierarchy level (Site, Resp, User, etc.).
- Value: The actual setting (e.g., “Vision Operations”).
- Visible Value: It decodes internal IDs (like Org ID 204) into readable names (like “Vision Operations”).
Technical Architecture
The report queries FND_PROFILE_OPTION_VALUES and joins to context tables like FND_USER, FND_RESPONSIBILITY, and HR_ALL_ORGANIZATION_UNITS.
Parameters & Filtering
- User Profile Name: Search by the friendly name.
- Setup Level: Filter to see only “Site” or “User” level settings.
- Redundant: A special filter to find values set at lower levels that are identical to the Site level (cleanup opportunity).
Performance & Optimization
- Volume: There are millions of profile values. Always filter by Profile Name or Level.
FAQ
- Q: Why are there two value columns?
- A: “Profile System Value” is what is stored in the DB (often an ID). “Profile User Value” is the translated, human-readable meaning.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH