Search Results import_seq

Overview

AR_GTA_TRXIMP_TMP is a temporary interface (staging) table owned by the AR (Receivables) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to serve as a temporary interface table for VAT invoice processing, in practice supporting the Global Tax/transaction import flows that stage inbound invoice and tax data before it is validated and moved into the permanent Receivables transaction tables. The "TMP" suffix and the module context indicate that rows are transient: they are populated by a concurrent program or external load, consumed by a validation and transfer routine, and then purged or truncated.

The table is documented as standalone, with no foreign keys to other objects, and is classified heuristically as standalone under a Data Vault style model — that is, it is best treated as a staging source rather than a modeled hub, link, or satellite in its own right. It carries a generic positional column layout (COL1 through COL25) in addition to the standard Oracle EBS audit columns, which reflects its role as a flexible landing area for externally supplied VAT invoice records.

Key Information Stored

The surrogate primary key is IMPORT_SEQ, which is also backed by the unique index AR_GTA_TRXIMP_TMP_U1 (AR_GTA_TRXIMP_TMP_PK). Because the same column serves as both the primary key and the only documented unique index, IMPORT_SEQ is the sole business-key candidate in the schema — there is no separate natural key column such as an invoice number or tax registration identifier exposed in the metadata. The most significant columns are:

• IMPORT_SEQ — surrogate identifier and unique index column; used to sequence and reference staged rows.
• COL1 through COL25 — generic positional staging columns. Because the physical schema does not document meaningful names for these, they hold the raw inbound VAT invoice payload (invoice identifiers, tax amounts, tax codes, dates, and reference data) as mapped by the loader program.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS who-columns, providing the audit trail of insertion and any subsequent modification.
• PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — concurrency and traceability columns identifying the concurrent request and program that loaded or processed the row.

The generic COL*n* naming means downstream code, not the table definition, determines the semantic meaning of each staged value.

Common Use Cases and Queries

The primary use case is the staged import of VAT invoice data prior to validation and transfer into Receivables. Typical operations include inspecting pending rows, checking load completeness, and tracing rows back to the originating concurrent request.

-- Inspect the most recent staged rows
SELECT import_seq, col1, col2, col3,
       creation_date, created_by, request_id
FROM   ar.ar_gta_trximp_tmp
ORDER  BY import_seq DESC;

-- Trace rows loaded by a specific concurrent request
SELECT import_seq, col1, col2, request_id, program_id
FROM   ar.ar_gta_trximp_tmp
WHERE  request_id = :request_id;

Reporting scenarios center on reconciling the count and content of staged rows against the source file or feeder system, and on identifying rows that failed validation (for example, rows lacking a match in permanent tax tables). Because the table is temporary, administrators also monitor its row count to confirm that transfer-and-purge routines have completed and that stale data is not accumulating.

Related Objects

The documented metadata records no foreign keys, so no internal EBS table references AR_GTA_TRXIMP_TMP directly at the database level. Its principal relationships are functional rather than enforced, and the most significant associated objects are:

• AR_GTA_TRXIMP_TMP_PK / AR_GTA_TRXIMP_TMP_U1 — the primary key constraint and unique index on IMPORT_SEQ that govern row identity.
• RA_INTERFACE_LINES_ALL — the standard Receivables interface table into which validated staged rows are typically transferred for AutoInvoice processing.
• RA_INTERFACE_DISTRIBUTIONS_ALL — receives the distribution/tax detail associated with transferred interface lines.
• RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL — the permanent Receivables transaction tables that hold the final VAT invoices after interface processing.
• FND_CONCURRENT_REQUESTS / FND_CONCURRENT_PROGRAMS — join via REQUEST_ID and PROGRAM_ID to trace the concurrent program that loaded or processed staged rows.
• AR_TAX_INTERFACE / EBTax tax tables (ZX_*) — referenced functionally during VAT validation of the staged data.

These relationships are conceptual and should be confirmed against the actual loader and transfer logic in the target environment, as the table's generic column structure and standalone classification provide no enforced join paths within the schema.