Results for “reporting_date”

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

Overview

PN_VOL_HIST_LINES_ITF is an interface table in the PN (Property Manager) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. Its documented purpose is to hold batch line information for volume history processing. In EBS property management, volume history records capture the periodic reporting of production volumes, deductions, and related financial amounts for variable rent agreements. This interface table functions as the staging area where batch lines are loaded before the Property Manager volume history concurrent programs validate and move them into the permanent operational tables.

The ETRM metadata classifies this object heuristically as standalone under Data Vault modeling. This suggests the table behaves as an independent staging structure with limited referential dependencies; only a single documented foreign key exists, so it is best treated as a satellite-like interface object rather than a true hub or link.

Key Information Stored

The table contains 21 documented columns. The most operationally significant are:

• BATCH_ID — Identifier grouping lines loaded together as one batch run.
• VAR_RENT_ID — Foreign key to PN_VAR_RENTS_ALL, tying each line to a variable rent agreement.
• LINE_ITEM_ID — Business identifier for the individual interface line.
• REP_STR_DATE / REP_END_DATE — Reporting period start and end dates for the volume history line.
• REPORTING_DATE — The date on which the volume is reported.
• AMOUNT / DEDUCTION_AMT — Gross amount and deduction amount for the line.
• DEDUCTION_TYPE_CODE — Classifies the deduction applied.
• VOL_DEDUCT_ID — Reference to the volume deduction definition.
• VOL_HIST_STATUS_CODE / STATUS — Processing and validation status of the interface row.
• REPORT_TYPE_CODE — Indicates the type of volume report being processed.
• GROUP_DATE — Date used for grouping batch lines.
• ERROR_LOG — Stores validation errors encountered during import.
• CERTIFIED_BY — Party certifying the reported volume.

Standard EBS WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) provide audit tracking. No surrogate primary key or unique index is documented in the ETRM metadata; VAR_RENT_ID plus LINE_ITEM_ID and BATCH_ID typically serve as business-key candidates.

Common Use Cases and Queries

Typical usage involves bulk-loading volume history lines from external systems into this interface, then running the Property Manager import concurrent program. Common queries include retrieving all unprocessed lines for a batch, finding rows with errors, and aggregating amounts by variable rent agreement.

• Monitoring batch status: SELECT STATUS, VOL_HIST_STATUS_CODE, COUNT(*) FROM PN_VOL_HIST_LINES_ITF GROUP BY STATUS, VOL_HIST_STATUS_CODE;
• Isolating failed lines: SELECT BATCH_ID, LINE_ITEM_ID, ERROR_LOG FROM PN_VOL_HIST_LINES_ITF WHERE ERROR_LOG IS NOT NULL;
• Reconciling amounts by agreement: SELECT VAR_RENT_ID, SUM(AMOUNT) FROM PN_VOL_HIST_LINES_ITF GROUP BY VAR_RENT_ID;

Reporting use cases include pre-import validation reports, batch reconciliation summaries, and audit trails of certified volumes by reporting period.

Related Objects

• PN_VAR_RENTS_ALL — Primary FK target; join on VAR_RENT_ID to resolve the variable rent agreement.
• Property Manager volume history base and interface processing concurrent programs that read and clear this table.
• Deduction and volume deduction definition tables referenced via VOL_DEDUCT_ID and DEDUCTION_TYPE_CODE.
• Standard EBS audit/reporting views over the PN schema that query interface activity.