| layout | default |
|---|---|
| title | PN Generate Portfolio Detail | Oracle EBS SQL Report |
| description | Application: Property Manager Source: Generate Portfolio Detail Report Short Name: PNGPDRXML DB package: XXENPN |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, Generate, Portfolio, Detail, pn_lease_reports_data_gtt, pn_leases_all, pn_lease_details_all |
| permalink | /PN%20Generate%20Portfolio%20Detail/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Application: Property Manager Source: Generate Portfolio Detail Report Short Name: PNGPDR_XML DB package: XXEN_PN
Operating Unit, As of Period, Representation
pn_lease_reports_data_gtt, pn_leases_all, pn_lease_details_all, pn_eqp_leases_all, pn_eqp_lease_details_all, pn_amendment_report_gtt, q_portfolio_detail, q_amendment_detail
PN Generate Portfolio Summary, PN Generate Lease Details, PN Generate Lease Analysis, PN Schedule Approval Status Upload, PN Billing/Payment Term Upload, PN GL Reconciliation
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.
| Resource | Link |
|---|---|
| Excel Example Output | None |
| Blitz Report™ XML Import | PN_Generate_Portfolio_Detail.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/pn-generate-portfolio-detail/ |
The PN Generate Portfolio Detail report is a comprehensive operational and financial reporting tool designed for Oracle Property Management (PN). It provides a granular, consolidated view of an entire lease portfolio as of a specific period, encompassing details from individual leases, their terms, and any amendments. This report is indispensable for property managers, financial analysts, and executives to gain deep insight into the composition, performance, and financial obligations of their property assets, supporting both daily operations and strategic portfolio management.
Managing a diverse portfolio of properties and leases requires detailed, up-to-date information across numerous dimensions. Organizations often struggle with:
- Lack of Consolidated Portfolio View: While individual lease reports exist, obtaining a single, detailed report that consolidates all active leases within a portfolio, along with their key attributes and financial impact, is a significant challenge.
- Historical Portfolio Analysis: Assessing the state of the portfolio (e.g., total rentable area, occupancy, revenue) at a specific point in the past for audit or comparative analysis is complex due to the dynamic nature of lease data and amendments.
- Impact of Amendments: Lease agreements are frequently amended, making it difficult to keep track of the current terms and how historical amendments have shaped the portfolio over time.
- Strategic Decision Support: Without a detailed portfolio-level view, making informed decisions about acquisitions, dispositions, or portfolio restructuring is based on incomplete or outdated information.
This report offers a flexible, detailed, and date-effective solution for comprehensive lease portfolio analysis, transforming how property management teams understand and manage their assets.
- Complete Portfolio Snapshot: It provides a comprehensive, itemized list of all leases within a defined portfolio as of a specified period, detailing lease attributes, financial terms, and amendment information. This offers an unparalleled view of portfolio composition.
- Date-Effective Historical Analysis: The "As of Period" parameter is crucial, allowing users to analyze the portfolio's exact state (including all active leases and their terms) at any given point in time, which is essential for historical comparisons, audit, and trend analysis.
- Unified Lease and Amendment Data: The report seamlessly integrates lease header and detail information with data on lease amendments, providing a complete audit trail of changes that have impacted the portfolio.
- Foundation for Strategic Management: By offering granular data across the entire portfolio, the report serves as a robust foundation for strategic property management decisions, enabling deeper analysis of revenue generation, expense obligations, and asset utilization.
The report queries core Oracle Property Management tables, including historical records and leveraging Global Temporary Tables (GTTs) for efficient processing.
- Primary Tables/Views Involved:
pn_leases_allandpn_lease_details_all(for lease header and detailed attribute information).pn_eqp_leases_allandpn_eqp_lease_details_all(corresponding tables for equipment leases).pn_lease_reports_data_gttandpn_amendment_report_gtt(Global Temporary Tables, often used to stage and process large datasets efficiently, especially for complex analytical reports).
- Logical Relationships: The report populates the GTTs with relevant lease and amendment data based on the
As of Periodparameter. It then queries these temporary tables, joining lease details with amendment information to present a consolidated, date-effective view of the entire portfolio. The use of GTTs allows for complex intermediate calculations without impacting other sessions.
|-
The report offers key parameters for focused portfolio analysis:
- Operating Unit: Filters the report to a specific business unit or organizational context.
- As of Period: The critical parameter for time-sensitive reporting, allowing users to select the accounting period for which they want to view the portfolio snapshot.
- Representation: (If applicable) Allows selection of the currency or format in which financial amounts are displayed.
As a detailed portfolio report, it is optimized through efficient use of temporary tables and period-driven processing.
- Global Temporary Tables (GTTs): The use of GTTs is a significant optimization. It allows the report to process large volumes of data for the portfolio by staging intermediate results in memory or temporary segments, greatly speeding up complex joins and aggregations without logging to redo/undo, thus enhancing performance and scalability.
- Period-Driven Processing: The
As of Periodparameter ensures that the report only processes data relevant to the selected period, avoiding the need to scan entire historical datasets. - Optimized Data Extraction: The underlying
XXEN_PNpackage is likely designed with efficient SQL to extract and prepare data for the portfolio view.
1. What is the difference between this 'Portfolio Detail' and the 'Portfolio Summary' reports? The 'Portfolio Detail' report provides a granular, line-by-line view of every lease and its key attributes within the portfolio, suitable for in-depth analysis and auditing. The 'Portfolio Summary' report, in contrast, offers an aggregated, high-level overview (e.g., total square footage, total revenue by property type), designed for executive dashboards and quick performance assessments.
2. Does this report include both real estate and equipment leases?
Yes, based on the Used tables (e.g., pn_leases_all and pn_eqp_leases_all), this report is designed to consolidate details for both real estate and equipment leases, providing a complete view of all leased assets within the portfolio.
3. How does the report handle lease amendments that change terms historically?
By leveraging historical tables (pn_amendment_report_gtt indicates amendment details) and the As of Period parameter, the report can accurately reflect the lease terms and financial implications as they stood on a specific date, even if those terms were amended multiple times throughout the lease's lifecycle.
- 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
© 2026 Enginatics