Blitz Report VPD Policy Setup – Oracle EBS SQL Report

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

Overview

Lists tables and columns to be secured by Blitz Report’s VPD policy functionality (concurrent program ‘Blitz Report Update VPD Policies’) from lookup XXEN_REPORT_VPD_POLICY_TABLES and validates if corresponding DB policies have been created.

Report Parameters

Oracle EBS Tables Used

dba_policies, fnd_lookup_values, all_tables, all_tab_columns

Report Categories

Enginatics

CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Inventory Lot and Locator OPM Value (Period-End), CAC Material Account Summary, FND Audit Setup, DBA ORDS Configuration Validation, DBA Blitz Report ORDS Configuration, CAC Accounting Period Status, CAC OPM WIP Account Value, CAC Inventory Organization Summary

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 Blitz Report VPD Policy Setup 29-Jun-2020 135303.xlsx
Blitz Report™ XML Import Blitz_Report_VPD_Policy_Setup.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-vpd-policy-setup/

Executive Summary

The Blitz Report VPD Policy Setup report is a security administration tool designed to manage and validate Virtual Private Database (VPD) policies within the Blitz Report framework. It lists the tables and columns configured for VPD security and verifies whether the corresponding database policies have been correctly applied.

Business Challenge

Implementing row-level security via VPD is critical for protecting sensitive data in Oracle EBS. However, ensuring that these policies are correctly defined and active across all relevant tables can be complex. Misconfigurations can lead to data leaks or unauthorized access. Administrators need a reliable way to audit the setup of VPD policies to ensure compliance with security standards.

Solution

The Blitz Report VPD Policy Setup report provides a clear audit trail of the VPD configuration. It compares the intended security setup (defined in the XXEN_REPORT_VPD_POLICY_TABLES lookup) with the actual database policies in effect. This validation step ensures that the security measures intended by the administrators are technically enforced in the database.

Key Features

Technical Details

The report queries dba_policies to check for existing database policies and compares them against the configuration stored in fnd_lookup_values. It also references all_tables and all_tab_columns to validate the existence of the secured objects.

© 2026 Enginatics