FND Forms Personalizations – 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
Forms personalizations and actions
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
Form Name, Function Name, Application Name, Description like, Last Updated By, Last Update within Days, Last Update Date From, Last Update Date To, Show Context
Oracle EBS Tables Used
fnd_form_custom_prop_values, fnd_concurrent_programs_vl, fnd_application, fnd_form_functions_vl, fnd_form_custom_rules, fnd_form_vl, fnd_application_vl, fnd_form_custom_scopes, fnd_industries, fnd_responsibility_vl, fnd_user, fnd_form_custom_actions, fnd_languages_vl, fnd_form_custom_prop_list
Report Categories
Related Reports
FND User Login Page Favorites, FND Responsibility Access, FND FNDLOAD Object Transfer, FND Attachment Functions, FND Flex Value Sets, Usages and Values, Blitz Report Assignments and Responsibilities, FND User Login History
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 Forms Personalizations 21-Jul-2017 173253.xlsx |
| Blitz Report™ XML Import | FND_Forms_Personalizations.xml |
| SQL Source | FND Forms Personalizations.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-forms-personalizations/ |
Executive Summary
The FND Forms Personalizations report is the definitive audit tool for all custom logic applied to Oracle Forms via the “Personalization” framework. It replaces the need to manually open every form to check for customizations.
Business Challenge
- Upgrade Assessment: Identifying all personalizations that need to be tested or re-implemented during an upgrade.
- Troubleshooting: Checking if a “bug” is actually caused by a custom personalization rule.
- Logic Review: Documenting business rules implemented via personalization (e.g., making a field mandatory).
The Solution
This Blitz Report extracts the full personalization logic:
- Rule: The Trigger Event (e.g.,
WHEN-NEW-FORM-INSTANCE) and Condition. - Actions: The specific actions taken (e.g., Property Property, Message, Builtin).
- Scope: Whether the rule applies to the Site, Responsibility, or User level.
Technical Architecture
The report joins FND_FORM_CUSTOM_RULES, FND_FORM_CUSTOM_ACTIONS, and FND_FORM_CUSTOM_SCOPES. It provides a flattened view of the Rule -> Action hierarchy.
Parameters & Filtering
- Form Name: Filter for personalizations on a specific screen.
- Description: Search for keywords in the rule description.
- Show Context: Toggle to see the scope (Site/Resp/User).
Performance & Optimization
- Complex Logic: The report handles the one-to-many relationship between Rules and Actions.
FAQ
- Q: Does this show CUSTOM.pll changes?
- A: No, this only shows changes made in the “Forms Personalization” window stored in the database.
CUSTOM.pllis a file-based customization.
- A: No, this only shows changes made in the “Forms Personalization” window stored in the database.
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