Search Results interface_distribution_id

Overview

RA_INTERFACE_DISTRIBUTIONS_ALL is the Receivables interface table that stores accounting distributions for transactions imported through the AutoInvoice process. It resides in the AR schema and forms one of the core staging structures used when external source systems (order management, billing, legacy systems, or feeder programs) supply invoice, debit memo, credit memo, and chargeback data for validation and import into Oracle Receivables. Each row represents a single accounting distribution line associated with an interface line in RA_INTERFACE_LINES_ALL, carrying the account class, amount or percentage, and the full accounting flexfield segments that will ultimately be posted once AutoInvoice creates the corresponding transaction distributions.

From a Data Vault modeling perspective, the mined FK structure classifies this table as standalone, meaning it neither behaves as a pure hub (no natural business key emerges across all referencing FKs) nor as a classic link between two hubs. This is a modeling suggestion only; functionally, the table acts as a staging and staging-satellite structure whose rows are transient, refreshed with each AutoInvoice run, and therefore not a durable historical record in the same sense as RA_CUST_TRX_LINE_GL_DIST_ALL.

Key Information Stored

• INTERFACE_DISTRIBUTION_ID — surrogate primary key (RA_INTERFACE_DISTRIBUTIONS_PK) and the unique business-key candidate (RA_INTERFACE_DISTRIBUTIONS_U1 / UK1). Referenced by downstream interface tables such as PO_INTERFACE_ERRORS and PO_DISTRIBUTIONS_INTERFACE.
• INTERFACE_LINE_ID — foreign reference linking the distribution to its parent interface line in RA_INTERFACE_LINES_ALL.
• INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE1–15 — flexible descriptive context columns used to pass source-system values into the line.
• ACCOUNT_CLASS — identifies whether the distribution is revenue, tax, freight, receivable, unearned revenue, or another class.
• AMOUNT and PERCENT — the monetary value or percentage allocation for the distribution; one of these drives the accounting entry.
• ACCTD_AMOUNT — the accounted amount in the ledger functional currency.
• CODE_COMBINATION_ID and SEGMENT1–SEGMENT30 — the accounting flexfield reference and its concatenated segment values prior to validation.
• INTERFACE_STATUS — processing status flag used by AutoInvoice to determine validation and load outcomes.
• REQUEST_ID — the concurrent request that created or processed the row, enabling run-level diagnostics.
• ORG_ID — the operating unit context.
• INTERIM_TAX_CCID and INTERIM_TAX_SEGMENT1–30 — interim tax accounting flexfield values for tax distributions.
• ATTRIBUTE1–15, GLOBAL_ATTRIBUTE1–30, and GLOBAL_ATTRIBUTE_CATEGORY — descriptor flexfield and global descriptive flexfield columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

The full documented schema contains 140 columns; the list above captures the functionally significant ones.

Common Use Cases and Queries

AutoInvoice administrators and technical consultants use this table to diagnose why distributions fail validation. A typical query filters by REQUEST_ID and INTERFACE_STATUS to isolate a specific run:

SELECT i.INTERFACE_DISTRIBUTION_ID, i.INTERFACE_LINE_ID,
       i.ACCOUNT_CLASS, i.AMOUNT, i.ACCTD_AMOUNT,
       i.INTERFACE_STATUS
  FROM AR.RA_INTERFACE_DISTRIBUTIONS_ALL i
 WHERE i.REQUEST_ID = :p_request_id
   AND i.INTERFACE_STATUS = 'REJECTED';

Another frequent pattern joins distributions to their parent interface lines to confirm the ACCOUNT_CLASS matches the intended line type before import. Reporting queries reconcile distributions that failed against errors logged in PO_INTERFACE_ERRORS, matching on INTERFACE_DISTRIBUTION_ID. Reconciliation of source-system totals against interface totals validates that AMOUNT and ACCTD_AMOUNT were supplied correctly. Purging scripts identify stale rows by REQUEST_ID and CREATION_DATE after successful import. Because the table is a staging structure, most queries should be scoped to a specific REQUEST_ID to avoid mixing runs.

Related Objects

• RA_INTERFACE_LINES_ALL — the parent interface line table; join on INTERFACE_LINE_ID.
• RA_INTERFACE_SALESCREDITS_ALL — related staging table for sales credit lines identified during import.
• PO_INTERFACE_ERRORS — references this table via INTERFACE_DISTRIBUTION_ID, capturing rejection errors from the purchasing/procurement side.
• PO_DISTRIBUTIONS_INTERFACE — also references INTERFACE_DISTRIBUTION_ID, linking procurement distribution staging to Receivables distribution staging.
• RA_CUST_TRX_LINE_GL_DIST_ALL — the persistent destination table where validated distributions land after successful AutoInvoice processing.
• RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL — the transactions and lines created after import.
• GL_CODE_COMBINATIONS — validates CODE_COMBINATION_ID and the SEGMENT columns during import.
• AutoInvoice Execution Report — concurrent program output sourced from these rows, used for validation and error review.