Skip to content

README.md

Latest commit

 

History

History
82 lines (60 loc) · 6.41 KB

README.md

File metadata and controls

82 lines (60 loc) · 6.41 KB
layout default
title FND Forms Personalizations | Oracle EBS SQL Report
description Forms personalizations and actions – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Forms, Personalizations, fnd_form_custom_prop_values, fnd_concurrent_programs_vl, fnd_application
permalink /FND%20Forms%20Personalizations/

FND Forms Personalizations – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Forms personalizations and actions

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

Enginatics

Related Reports

FND User Login Page Favorites, FND Responsibility Access, FND Responsibility Access 11i, FND FNDLOAD Object Transfer, FND Attachment Functions, FND Flex Value Sets, Usages and Values, FND User Login History, Blitz Report Assignments and Responsibilities

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output FND Forms Personalizations 21-Jul-2017 173253.xlsx
Blitz Report™ XML Import FND_Forms_Personalizations.xml
Full SQL 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.pll is a file-based customization.

Useful Links

© 2026 Enginatics