Search Results ap_expense_feed_dists_all




Overview
Explore in AI Chat

Overview

The AP_EXPENSE_FEED_DISTS_ALL table is a core data object within the Oracle E-Business Suite Payables (AP) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for storing detailed accounting distribution information for credit card transactions. This table is integral to the automated expense feed process, where corporate credit card transaction data is imported into Oracle Payables for validation, approval, and subsequent accounting. Its primary role is to hold the accounting flexfield combinations and monetary amounts that define how each imported credit card line item will be accounted for in the General Ledger, ensuring accurate financial posting.

Key Information Stored

The table stores the accounting distributions for each line of a credit card feed. Its primary key is the FEED_DISTRIBUTION_ID. Critical columns include FEED_LINE_ID, which links the distribution back to its source transaction in the AP_EXPENSE_FEED_LINES_ALL table, and INVOICE_ID, which references the AP_INVOICES_INTERFACE table once the feed data is staged for invoice creation. The core accounting data is held in DIST_CODE_COMBINATION_ID, which stores the identifier for the specific General Ledger account code combination (e.g., expense account, liability account). Other essential columns typically include the distribution amount (AMOUNT), distribution type, and associated tax information, forming a complete accounting entry for the transaction.

Common Use Cases and Queries

This table is primarily accessed for troubleshooting accounting issues in the credit card feed process, auditing distributions before invoice creation, and generating custom reconciliation reports. A common query involves joining to the feed lines and code combinations table to review pending distributions:

  • SELECT aefd.feed_distribution_id, aefd.amount, gcc.segment1, gcc.segment2 FROM ap_expense_feed_dists_all aefd, ap_expense_feed_lines_all aefl, gl_code_combinations gcc WHERE aefd.feed_line_id = aefl.feed_line_id AND aefd.dist_code_combination_id = gcc.code_combination_id AND aefl.status = 'UNPROCESSED';

Another critical use case is identifying distributions linked to invoices stuck in the interface, which can be investigated by joining on INVOICE_ID to the AP_INVOICES_INTERFACE table.

Related Objects

AP_EXPENSE_FEED_DISTS_ALL has defined relationships with several key EBS objects, as indicated by its foreign keys. It is a child table to AP_EXPENSE_FEED_LINES_ALL via FEED_LINE_ID, which contains the header and line details of the imported credit card transaction. It also references AP_INVOICES_INTERFACE via INVOICE_ID, linking the accounting distribution to the staged invoice created from the feed. The most crucial accounting relationship is with GL_CODE_COMBINATIONS via DIST_CODE_COMBINATION_ID, which provides the valid GL account for the distribution. These relationships ensure data integrity throughout the expense feed-to-accounting lifecycle.