Search Results ra_interface_distributions_all




Overview
Explore in AI Chat

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

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.