Results for “inv_schedule_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PN_VAR_GRP_DATES_ALL is a Property Manager (PN) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the critical dates associated with a variable rent agreement. Records are created by the periods generation program, which drives the calculation and processing cycles of variable rent agreements. Each row captures a single group-date instance tied to a variable rent agreement and a specific period, providing the scheduling framework used for reporting, invoicing, volumetrics, and deductions.

The table is owned by the PN schema and is documented as VALID, with 21 columns and a primary key constraint, PN_VAR_GRP_DATES_PK, on GRP_DATE_ID. A unique index, PN_VAR_GRP_DATES_U1, also exists on GRP_DATE_ID, distinguishing the surrogate key (GRP_DATE_ID) from documented business-key candidates. Under a heuristic Data Vault classification, the table is hub-leaning: it acts as a durable key-bearing anchor that multiple dependent satellite-style tables reference via GRP_DATE_ID. This classification is offered as a modeling suggestion and should be validated against the actual grain and population of records in a given environment.

Key Information Stored

Each row represents a group date for a variable rent agreement period. The most significant columns include:

• GRP_DATE_ID – surrogate primary key (PN_VAR_GRP_DATES_PK) and the unique business-key candidate (PN_VAR_GRP_DATES_U1).
• VAR_RENT_ID – foreign key to PN_VAR_RENTS_ALL, linking the group date to its parent variable rent agreement.
• PERIOD_ID – foreign key to PN_VAR_PERIODS_ALL, identifying the accounting or processing period.
• GRP_START_DATE and GRP_END_DATE – the effective range for the group date.
• GROUP_DATE – the central business date for the group.
• REPTG_DUE_DATE – reporting due date for the group.
• INV_START_DATE, INV_END_DATE, INVOICE_DATE, INV_SCHEDULE_DATE – invoice-related milestones governing billing and scheduling.
• PRORATION_FACTOR – the factor applied when proration is required.
• ACTUAL_EXP_CODE, FORECASTED_EXP_CODE, VARIANCE_EXP_CODE – expense codes supporting actual, forecast, and variance reporting.
• ORG_ID – multi-org operating unit identifier.
• Audit columns – CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical reporting scenarios include retrieving upcoming invoice dates, analyzing group date ranges, and joining to related volumetric and deduction tables for summary reporting. A representative query is:

• SELECT g.GRP_DATE_ID, g.GROUP_DATE, g.INVOICE_DATE, g.PRORATION_FACTOR FROM PN_VAR_GRP_DATES_ALL g WHERE g.VAR_RENT_ID = :p_var_rent_id AND g.ORG_ID = :p_org_id;
• Join to summaries: SELECT s.* FROM PN_VAR_RENT_SUMM_ALL s, PN_VAR_GRP_DATES_ALL g WHERE s.GRP_DATE_ID = g.GRP_DATE_ID;
• Volumetric history extraction: SELECT v.* FROM PN_VAR_VOL_HIST_ALL v, PN_VAR_GRP_DATES_ALL g WHERE v.GRP_DATE_ID = g.GRP_DATE_ID AND g.PERIOD_ID = :p_period_id;

Related Objects

The following tables reference PN_VAR_GRP_DATES_ALL through the GRP_DATE_ID column and are the most significant related objects:

• PN_VAR_RENT_SUMM_ALL.GRP_DATE_ID – summary-level rent data.
• PN_VAR_VOL_HIST_ALL.GRP_DATE_ID – volumetric history.
• PN_VAR_DEDUCTIONS_ALL.GRP_DATE_ID – deduction processing.
• PN_VAR_REPORT_DATES_ALL.GRP_DATE_ID – reporting date detail.
• PN_VAR_TRX_HEADERS_ALL.GRP_DATE_ID – transaction headers.
• PN_VAR_VOL_ARCH_ALL.GRP_DATE_ID and PN_VAR_DEDUCT_ARCH_ALL.GRP_DATE_ID – archived volumetric and deduction records.
• PN_VAR_RENTS_ALL and PN_VAR_PERIODS_ALL – parent tables referenced by VAR_RENT_ID and PERIOD_ID respectively.