Search Results fv_ipac_import




Overview
Explore in AI Chat

Overview

FV_IPAC_IMPORT is a Federal Financials (FV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that supports the import of Intra-Governmental Payment and Collection (IPAC) disbursement transactions. IPAC is the U.S. Treasury mechanism through which federal agencies settle inter-agency reimbursable and transfer transactions. The table functions as the staging and validation repository for IPAC bulk files received from Treasury's GOALS/SPS systems, which are subsequently processed into Oracle Payables/Receivables invoices and accounting events.

The ETRM documentation identifies a single foreign key — INVOICE_LINE_ID referencing FTE_INVOICE_LINES — establishing the linkage between staged IPAC records and the resulting invoice lines. In data-vault modeling terms, FV_IPAC_IMPORT exhibits standalone characteristics with no hub-to-hub or multi-parent join relationships, suggesting it is best modeled as a satellite or staging table rather than a link. The presence of GROUP_ID and REQUEST_ID columns further confirms that it is a concurrent-program staging table whose lifecycle is tied to a specific importer process run. The owner is the FV schema and the object is documented as VALID at 155 columns in the 12.2.2 physical schema.

Key Information Stored

The surrogate primary key is IPAC_IMPORT_ID, enforced by unique index FV_IPAC_IMPORT_U1. This is the only documented business-key candidate.

Common Use Cases and Queries

Typical usage centers on reconciling imported IPAC files to generated payables invoices and on diagnosing import failures.

  • Batch status reconciliation: SELECT RECORD_STATUS, COUNT(*), SUM(SUMMARY_AMOUNT) FROM FV_IPAC_IMPORT WHERE BATCH_NAME = :batch GROUP BY RECORD_STATUS;
  • Unlinked transactions: SELECT IPAC_IMPORT_ID, TRANSACTION_ID FROM FV_IPAC_IMPORT WHERE INVOICE_LINE_ID IS NULL AND RECORD_STATUS = 'ERROR';
  • Join to the invoice line: SELECT a.TRANSACTION_ID, a.DETAIL_AMOUNT, l.INVOICE_LINE_ID FROM FV_IPAC_IMPORT a JOIN FTE_INVOICE_LINES l ON a.INVOICE_LINE_ID = l.INVOICE_LINE_ID;
  • SGL distribution reporting: unpivot the SGL_NUMBER1..16 columns to produce Treasury FMS 224 style reporting.
  • Concurrent request troubleshooting: filter by REQUEST_ID or GROUP_ID to isolate the rows produced by a specific IPAC Import run.

Related Objects