Results for “adj_type”

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

Overview

AP_PPA_INVOICE_LINES_GT is a Payables (AP) schema table that functions as a global temporary (GT) staging structure for invoice line data during invoice import and validation processing. It is populated by the Payables Invoice Import and related partner/procurement activity programs, which load external invoice line records into this staging area before Oracle validates and commits them to the permanent AP_INVOICE_LINES_ALL structure. The table carries 160 documented columns in ETRM 12.2.2, reflecting the broad range of attributes that must be captured for invoice lines spanning standard, purchase order matched, project-related, and tax-bearing transactions.

From a Data Vault modeling perspective, the ETRM heuristic classifies this object as standalone. This classification reflects its nature as a transient staging container rather than a persisted entity: it holds no incoming foreign-key dependencies and does not serve as a durable hub, link, or satellite for downstream history. Analysts should treat it as a processing structure whose contents are session-scoped and may be cleared after import completes.

Key Information Stored

The table's most significant columns define the identity, origin, accounting, and matching context of each staged invoice line:

• INVOICE_ID — Identifier of the parent invoice header; the primary correlate back to AP_INVOICES_ALL.
• LINE_NUMBER — Sequence of the line within the invoice; together with INVOICE_ID forms the natural business key for a line.
• LINE_TYPE_LOOKUP_CODE — Categorizes the line (e.g., item, tax, freight, miscellaneous).
• LINE_SOURCE — Indicates the originating subsystem supplying the line.
• AMOUNT and BASE_AMOUNT — Entered and functional-currency amounts for the line, with ROUNDING_AMT capturing residual rounding.
• QUANTITY_INVOICED, UNIT_PRICE, UNIT_MEAS_LOOKUP_CODE — Quantity, price, and unit of measure for item-based lines.
• PO_HEADER_ID, PO_LINE_ID, PO_SHIPMENT_LINE_ID / PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID — Purchase order matching references used by the matching engine.
• RCV_TRANSACTION_ID, RCV_SHIPMENT_LINE_ID — Receiving transaction references for receipt-matched flows.
• AWARD_ID, PROJECT_ID, TASK_ID, EXPENDITURE_TYPE — Grants and project accounting attributes.
• SUMMARY_TAX_LINE_ID, TAX_RATE_ID, TAX_REGIME_CODE, TAX_STATUS_CODE — Tax determination and linkage to ZX summary lines.
• INVOICE_LINE_ID — Foreign key to FTE_INVOICE_LINES, distinguishing the staged record from the final line identity.
• GENERATE_DISTS and DEFAULT_DIST_CCID — Control distribution generation and default accounting.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 plus GLOBAL_ATTRIBUTE1–20 — Descriptive flexfield storage.

The table does not expose a documented surrogate primary key in the ETRM metadata; INVOICE_ID plus LINE_NUMBER constitute the practical business-key candidate.

Common Use Cases and Queries

The dominant use case is diagnosing invoice import failures and validating staged data before commit. A typical query lists staged lines for a given invoice:

• SELECT invoice_id, line_number, line_type_lookup_code, amount, po_header_id, po_line_id FROM ap_ppa_invoice_lines_gt WHERE invoice_id = :p_invoice_id ORDER BY line_number;
• Reconciliation against final lines: join AP_INVOICE_LINES_ALL on invoice_id and line_number to detect lines that failed validation.
• PO match analysis: group by po_header_id to confirm expected receipt and distribution references are populated.
• Tax audit: filter SUMMARY_TAX_LINE_ID IS NOT NULL to verify tax lines reconcile to ZX_LINES_SUMMARY.
• Data quality reporting: count lines where LINE_TYPE_LOOKUP_CODE or AMOUNT is null before import submission.

Because the table is session-scoped, queries must run within the importing session or immediately after load.

Related Objects

• AP_INVOICE_LINES_ALL — Permanent target that receives validated rows from this staging table.
• PO_RELEASES_ALL — Referenced via PO_RELEASE_ID for release-level matching.
• IGF_AW_AWARD_ALL — Referenced via AWARD_ID for grants-funded lines.
• ZX_LINES_SUMMARY — Referenced via SUMMARY_TAX_LINE_ID for tax summary linkage.
• FTE_INVOICE_LINES — Referenced via INVOICE_LINE_ID, providing the associated invoice line record.
• IGI_DOS_TRX_SOURCES — Referenced via SOURCE_TRX_ID, linking staged lines to their originating transaction source.