Skip to the content.

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

Enginatics

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

The Solution

This Blitz Report extracts the full personalization logic:

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

Performance & Optimization

FAQ


© Enginatics GmbH