Results for “ap_expense_feed_dists_all”

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

Overview

AP_EXPENSE_FEED_DISTS_ALL is a Payables (AP) base table that stores the accounting distribution information generated for credit card expense feed transactions. In Oracle EBS 12.1.1 and 12.2.2, this table holds the distribution lines that will ultimately be transferred to the General Ledger for credit card expenses before and after they are interfaced into Payables as invoices. Each row represents a single accounting distribution — a charge amount, its code combination, and the associated tax, approval, and verification attributes — linked back to the expense feed line that produced it.

From a Data Vault modeling perspective, the heuristic classification for this object is a link. This reflects its role as an associative table that resolves relationships between expense feed lines, invoice interface records, and GL code combinations, rather than functioning as an independent hub of business keys or a pure descriptive satellite.

Key Information Stored

The table contains 40 documented columns. The most operationally significant are:

• FEED_DISTRIBUTION_ID — the surrogate primary key defined by the unique index AP_EXPENSE_FEED_DISTS_U1 and the AP_EXPENSE_FEED_DISTS_PK constraint. It uniquely identifies each distribution row.
• FEED_LINE_ID — foreign key to AP_EXPENSE_FEED_LINES_ALL, tying the distribution to its parent expense feed line.
• INVOICE_ID and INVOICE_LINE_ID — links to the invoice interface (AP_INVOICES_INTERFACE) and invoice line (FTE_INVOICE_LINES) records created from the feed.
• DIST_CODE_COMBINATION_ID — foreign key to GL_CODE_COMBINATIONS, identifying the Accounting Flexfield string charged.
• AMOUNT — the monetary value of the distribution.
• STATUS_LOOKUP_CODE and STATUS_CHANGE_DATE — track the lifecycle state of the distribution and when it last changed.
• TAX_CODE and AMOUNT_INCLUDES_TAX_FLAG — capture tax treatment of the charge.
• INVOICED_FLAG — indicates whether the distribution has been invoiced.
• MANAGER_APPROVAL_ID and EMPLOYEE_VERIFICATION_ID — approval and verification references for expense compliance.
• ACCOUNT_SEGMENT_VALUE, ACCOUNT_SEGMENT_VALUE_DEFAULT, and COST_CENTER — supporting accounting attribute values.
• ORG_ID — the operating unit that owns the distribution, central to multi-org reporting.
• CONC_REQUEST_ID — the concurrent request that processed the record.
• Standard audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, plus ATTRIBUTE_CATEGORY and ATTRIBUTE1–15.

Common Use Cases and Queries

Typical scenarios include reconciling credit card feeds, auditing uncleared distributions, and reporting by code combination or operating unit. A representative query joins the distribution to its parent feed line and GL account:

• Reconciliation: SELECT d.FEED_DISTRIBUTION_ID, d.AMOUNT, d.STATUS_LOOKUP_CODE FROM AP_EXPENSE_FEED_DISTS_ALL d WHERE d.ORG_ID = :org AND d.INVOICED_FLAG = 'N';
• Account analysis: join to GL_CODE_COMBINATIONS on DIST_CODE_COMBINATION_ID to summarize spend by account.
• Feed tracing: join to AP_EXPENSE_FEED_LINES_ALL on FEED_LINE_ID and to AP_INVOICES_INTERFACE on INVOICE_ID.
• Status monitoring: filter by STATUS_LOOKUP_CODE and STATUS_CHANGE_DATE for aging reports.

Related Objects

• AP_EXPENSE_FEED_LINES_ALL — parent lines; join on FEED_LINE_ID.
• AP_INVOICES_INTERFACE — target invoice interface; join on INVOICE_ID.
• GL_CODE_COMBINATIONS — accounting flexfield values; join on DIST_CODE_COMBINATION_ID.
• FTE_INVOICE_LINES — invoice line detail; join on INVOICE_LINE_ID.
• AP_EXPENSE_FEED_DISTS_PK / AP_EXPENSE_FEED_DISTS_U1 — the primary key and unique index enforcing FEED_DISTRIBUTION_ID. Credit card import and invoice generation programs in the Payables module read and write this table during expense processing.