Search Results pn_var_trx_headers_u1

Overview

PN.PN_VAR_TRX_HEADERS_ALL is the header-level transaction table within the Oracle E-Business Suite Property Manager (PN) module, which supports variable rent agreements commonly used in retail leases where rent is calculated from tenant-reported sales. The table stores the details of variable rent calculations, capturing each calculation sub-period along with the sales, deductions, proration factors, and rent amounts computed for that sub-period. It is registered as an FND Design Data object under the PN schema and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. The table is classified as VALID and forms the transactional core of the variable rent calculation engine.

From a heuristic Data Vault modeling perspective, PN_VAR_TRX_HEADERS_ALL can be viewed as a satellite table attached to the variable rent agreement hub (PN_VAR_RENTS_ALL) and the calculation period hub represented by PN_VAR_GRP_DATES_ALL. Each row records a measurable outcome: a prorated rent calculation for a specific sub-period, making it a natural fit for satellite classification rather than a link or pure hub.

Key Information Stored

The table contains 40 documented columns. The single-column unique index PN_VAR_TRX_HEADERS_U1 on TRX_HEADER_ID serves as the business-key candidate, while PN_VAR_TRX_HEADERS_PK defines the physical primary key constraint on the same column. TRX_HEADER_ID is thus the surrogate primary key and unique identifier for each calculation sub-period record.

• TRX_HEADER_ID – Primary key identifying the calculation sub-period.
• VAR_RENT_ID – Foreign key to PN_VAR_RENTS_ALL; identifies the variable rent agreement being calculated.
• PERIOD_ID – Identifies the annual period to which the calculation belongs.
• LINE_ITEM_ID / LINE_ITEM_GROUP_ID – Identify the line item and its Setup table group, used to aggregate sales and deductions.
• GRP_DATE_ID – Foreign key to PN_VAR_GRP_DATES_ALL; identifies the calculation period grouping.
• CALC_PRD_START_DATE / CALC_PRD_END_DATE – Define the boundaries of the calculation sub-period.
• VAR_RENT_SUMM_ID – Foreign key to PN_VAR_RENT_SUMM_ALL; links to the summarized result.
• PRORATION_FACTOR – Days in the sub-period divided by total days in the calculation period.
• REPORTING_GROUP_SALES / PRORATED_GROUP_SALES / YTD_SALES – Actual sales totals at the period, sub-period, and year-to-date levels.
• CALCULATED_RENT / PERCENT_RENT_DUE / YTD_PERCENT_RENT / PRORATED_RENT_DUE / TRUEUP_RENT_DUE – Rent calculation results including percentage rent owed and cumulative true-up adjustments.
• ORG_ID – Multi-org operating unit identifier for the transaction.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – Standard EBS audit columns.

Common Use Cases and Queries

Teams commonly query this table to retrieve rent calculation history for a given lease, to reconcile percentage rent billed through the AR interface, or to audit proration and true-up logic. A typical query joins the header to the rent agreement and summary:

• Retrieving calculated rent by agreement: SELECT trx_header_id, var_rent_id, calc_prd_start_date, calc_prd_end_date, calculated_rent, percent_rent_due FROM pn_var_trx_headers_all WHERE var_rent_id = :rent_id;
• Reconciling AR invoicing: join TRX_HEADER_ID to AR_INV_API_HEADERS_GT or AR_TRX_HEADER_GT to trace which calculation rows produced invoices.
• Reporting trend sales versus rent: aggregate PRORATED_GROUP_SALES and CALCULATED_RENT by PERIOD_ID.
• Detailed drill-down: join to PN_VAR_TRX_DETAILS_ALL on TRX_HEADER_ID for line-level breakdown.

The INVOICE_FLAG column supports filtering records that have been passed to Oracle Receivables, useful in month-end processes.

Related Objects

• PN_VAR_TRX_DETAILS_ALL – Child detail table referenced via TRX_HEADER_ID.
• PN_VAR_RENTS_ALL – Parent rent agreement referenced by VAR_RENT_ID.
• PN_VAR_GRP_DATES_ALL – Parent calculation period grouping referenced by GRP_DATE_ID.
• PN_VAR_RENT_SUMM_ALL – Summary result referenced by VAR_RENT_SUMM_ID.
• AR_INV_API_HEADERS_GT / AR_INV_API_LINES_GT / AR_INV_API_DIST_GT – Interfaces that pull TRX_HEADER_ID for invoice creation.
• AR_TRX_HEADER_GT / AR_TRX_LINES_GT – Temporary interface tables linked by TRX_HEADER_ID.