Results for “vat_tax_code_ext1”

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

Overview

The ECE_AR_TRX_LINE_TAX table is an e-Commerce Gateway (EC) staging table that stores customer invoice line tax data used to support the outbound Invoice (810/INVOIC) transaction. In Oracle EBS 12.1.1 and 12.2.2, the outbound invoicing process extracts tax detail from Receivables, loads it into this table through the ECE_AR_TRX_LINE_TAX interface, and then formats the tax lines into the flat file delivered to a trading partner or clearinghouse. The table resides in the EC schema and carries the status VALID in the ETRM repository.

From a Data Vault modeling perspective, the mined foreign-key metadata classifies this object as standalone — no parent relationship to another hub or link was detected. This suggests the table functions as an independent staging or transaction-detail hub, where TRANSACTION_ID acts as the surrogate primary key and TRANSACTION_RECORD_ID, protected by the unique index ECE_AR_TRX_LINE_TAX_U2, is the business-key candidate. Because the table is loaded and purged during the outbound invoice cycle, it is used as a transient satellite rather than a durable historical store.

Key Information Stored

The table contains 81 documented columns. The most significant are:

• TRANSACTION_ID — surrogate primary key; uniquely identifies each tax record.
• TRANSACTION_RECORD_ID — business-key candidate protected by unique index ECE_AR_TRX_LINE_TAX_U2; links the tax line back to its parent invoice line.
• RUN_ID — identifies the e-Commerce Gateway extraction run that produced the record.
• COMMUNICATION_METHOD and TRANSACTION_TYPE — identify the delivery channel and the outbound transaction category (e.g., INVOIC).
• LINE_NUMBER, LINE_TYPE, TAX_LINE_NUMBER, TAX_PRECEDENCE — order and classify tax lines within the invoice.
• TAX_AMOUNT and TAX_RATE — the calculated tax value and rate.
• TAX_TYPE, TAX_CLASSIFICATION, DESCRIPTION, LOCATION — descriptive tax attributes for the partner.
• TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE — exemption handling.
• VAT_TAX_CODE_INT, VAT_TAX_CODE_EXT1–EXT5, VAT_TRANSACTION_TYPE — VAT reporting codes.
• TAX_ATTRIBUTE1–15 and VAT_TAX_ATTRIBUTE1–15 — flexfield-ready extensibility.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — concurrent program and submission context.

Common Use Cases and Queries

Typical scenarios include audit of VAT tax reporting, reconciliation of the 810/INVOIC extract against Receivables tax lines, and troubleshooting partner rejections of tax segments. A sample query returns tax detail for a given extraction run:

SELECT transaction_id, transaction_record_id, line_number, tax_line_number,
       tax_type, tax_rate, tax_amount, vat_tax_code_int, tax_exempt_flag
FROM   ec.ece_ar_trx_line_tax
WHERE  run_id = :p_run_id
ORDER BY line_number, tax_precedence;

To verify the business key, group by TRANSACTION_RECORD_ID and count; more than one row indicates duplication. To reconcile against the source, join tax amounts back to Receivables tax lines using the invoice line reference carried on TRANSACTION_RECORD_ID.

Related Objects

• ECE_AR_TRX_LINE — parent invoice line staging table; join on TRANSACTION_ID or TRANSACTION_RECORD_ID.
• ECE_AR_TRX_HEADER — invoice header staging table; joins through the line table's header key.
• ECE_TP_HEADERS — trading partner header definitions used when building the outbound file.
• RA_CUSTOMER_TRX_LINES — Oracle Receivables source for invoice line tax data.
• RA_CUSTOMER_TRX_LINES_TAX — Receivables tax lines that feed this staging table.
• ZX_LINES / ZX_LINES_DET_FACTORS — E-Business Tax calculation detail referenced by tax codes.
• FND_CONCURRENT_REQUESTS — concurrent request context via REQUEST_ID.
• ECX_OUTBOUND_LOG / ECE_ARCHIVE tables — runtime logs and archival destinations for the outbound invoice run.