Search Results ra_interface_distributions_u1

Overview

AR.RA_INTERFACE_DISTRIBUTIONS_ALL is the AutoInvoice distribution interface table in Oracle E-Business Suite Receivables. It stores the accounting distribution lines that accompany imported transaction lines, forming the debit and credit entry set later transferred into RA_CUST_TRX_LINE_GL_DIST_ALL when AutoInvoice successfully creates a transaction. The table is the distribution-level counterpart of RA_INTERFACE_LINES_ALL and must be populated together with it, since AutoInvoice matches each distribution row to a line through the INTERFACE_LINE_ID and INTERFACE_LINE_CONTEXT pairing.

The object is registered under the AR product with FND Design Data AR.RA_INTERFACE_DISTRIBUTIONS_ALL and is defined as a multi-org view that retrieves data for the current operating unit and ignores data belonging to other operating units. It is a candidate for a multi-org view that retrieves data for the current operating unit and ignores data belonging to other operating units.

In Data Vault terms, the table is classified heuristically as standalone. Modeling guidance would suggest treating it as an interface staging object rather than a durable hub or satellite: rows are transient, tied to a concurrent request, and purged or recycled after the AutoInvoice import completes. The primary key RA_INTERFACE_DISTRIBUTIONS_PK is defined on INTERFACE_DISTRIBUTION_ID.

Key Information Stored

The table is physically stored in the APPS_TS_INTERFACE tablespace with 140 documented columns. The most significant columns are:

• INTERFACE_DISTRIBUTION_ID — surrogate primary key and the column behind the unique index RA_INTERFACE_DISTRIBUTIONS_U1. This is the value a caller must pre-generate from the sequence before inserting.
• INTERFACE_LINE_ID — foreign link to the corresponding line in the AutoInvoice line interface; indexed by the non-unique index RA_INTERFACE_DISTRIBUTIONS_N1.
• INTERFACE_LINE_CONTEXT — identifies the source transaction context, typically the originating system, and is required to correlate distributions with lines.
• INTERFACE_LINE_ATTRIBUTE1 through INTERFACE_LINE_ATTRIBUTE15 — flexible descriptive attributes used to classify or tag the distribution row.
• ACCOUNT_CLASS — controls which accounting class (receivable, revenue, tax, freight, receivables factoring, and so on) the distribution represents; combined with REQUEST_ID in the non-unique index RA_INTERFACE_DISTRIBUTIONS_N2.
• AMOUNT — the distribution amount in the entered currency, normally required when PERCENT is not supplied.
• PERCENT — the percentage allocation used when Amount is derived from the line total.
• CODE_COMBINATION_ID — the accounting flexfield combination for the distribution, together with SEGMENT1 through SEGMENT30 for source systems that supply the account as individual segments.
• INTERIM_TAX_CCID and INTERIM_TAX_SEGMENT1 through SEGMENT30 — account elements applied for interim tax handling.
• ACCTD_AMOUNT — the accounted amount for the distribution.
• REQUEST_ID — who-column identifying the concurrent request that last updated the row.
• INTERFACE_STATUS — import status; the concurrent process updates this field as rows are processed.
• ORG_ID — operating unit identifier, populated by the multi-org view.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1 through ATTRIBUTE15, GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE30 — descriptive flexfield containers for extensibility.

Because INTERFACE_DISTRIBUTION_ID is the only unique index, it is the sole documented business-key candidate; all other access paths (INTERFACE_LINE_ID and the REQUEST_ID/ACCOUNT_CLASS combination) are non-unique.

Common Use Cases and Queries

• Validating that every AutoInvoice line has at least one distribution before submission.
• Reconciling interface rows to the final GL distributions after import.
• Identifying rows rejected by AutoInvoice so they can be corrected and resubmitted.
• Auditing which concurrent request loaded or left rows in the interface.

A typical check for unbalanced or missing distributions:

SELECT interface_line_id, account_class, SUM(NVL(amount,0)) amt
FROM ra_interface_distributions_all
WHERE request_id = :p_request_id
GROUP BY interface_line_id, account_class
HAVING SUM(NVL(amount,0)) = 0;

A purge helper that removes processed rows for a given request:

DELETE FROM ra_interface_distributions_all
WHERE request_id = :p_request_id
AND interface_status = 'PROCESSED';

Related Objects

• RA_INTERFACE_LINES_ALL — the line-level interface table; join on INTERFACE_LINE_ID and INTERFACE_LINE_CONTEXT.
• RA_CUST_TRX_LINE_GL_DIST_ALL — the destination table populated by AutoInvoice from the interface distributions.
• RA_INTERFACE_ERRORS_ALL — stores rejection messages raised against interface distributions during import.
• RA_INTERFACE_DISTRIBUTIONS_PK — the primary key constraint on INTERFACE_DISTRIBUTION_ID.
• PO_INTERFACE_ERRORS — references INTERFACE_DISTRIBUTION_ID as a foreign key to this table.
• PO_DISTRIBUTIONS_INTERFACE — references INTERFACE_DISTRIBUTION_ID as a foreign key to this table.
• FND_CONCURRENT_REQUESTS — related through REQUEST_ID for concurrent program tracking.
• AR_AUTOINVOICE / RAXTRX — the AutoInvoice concurrent program that consumes and validates these rows.