Search Results ap_expense_feed_lines_all




Overview
Explore in AI Chat

Overview

The AP_EXPENSE_FEED_LINES_ALL table is a core data repository within the Oracle E-Business Suite Payables module (AP). It serves as the primary staging and storage table for detailed transactional data imported from credit card issuers. This table is central to the automated credit card reconciliation and expense reporting process, enabling organizations to electronically capture, validate, and process employee credit card transactions. Its role is to hold the granular line-level data from the expense feed before it is validated, accounted for, and potentially transferred to an expense report or directly to Payables for invoice creation.

Key Information Stored

The table stores a comprehensive set of attributes for each imported credit card transaction. The primary key is FEED_LINE_ID, which uniquely identifies each transaction record. Critical foreign key relationships define the transaction's context: CARD_ID links to AP_CARDS_ALL (the specific corporate card), and CARD_PROGRAM_ID links to AP_CARD_PROGRAMS_ALL. Financial details are captured through columns such as ORIGINAL_TRANSACTION_AMOUNT and POSTED_TRANSACTION_AMOUNT, with their respective currency codes (ORIGINAL_CURRENCY_CODE, POSTED_CURRENCY_CODE) linked to FND_CURRENCIES. Merchant information (MERCHANT_NAME, MERCHANT_CITY), transaction dates (TRANSACTION_DATE, POSTED_DATE), and reference numbers (MERCHANT_REFERENCE_NUMBER) are also stored. The CODE_ID column, linked to AP_CARD_CODES_ALL, often holds the issuer's transaction category or MCC (Merchant Category Code), which is pivotal for policy compliance and automatic expense categorization.

Common Use Cases and Queries

A primary use case is troubleshooting the credit card feed import process and analyzing unprocessed transactions. Common queries include identifying transactions for a specific card or date range that have not yet been reconciled. For example:

  • SELECT feed_line_id, merchant_name, transaction_amount FROM ap_expense_feed_lines_all WHERE card_id = :p_card_id AND transaction_date BETWEEN :p_start_date AND :p_end_date AND feed_status = 'UNPROCESSED';
  • Reporting on corporate card spending by merchant category or program often involves joining to AP_CARD_CODES_ALL and AP_CARD_PROGRAMS_ALL.
  • Technical support frequently queries this table to verify data integrity post-import, checking for missing currency codes or invalid card program links before users attempt to create expense reports from the feed lines.

The data in this table is typically accessed via the "Credit Card Transactions" or similar form, where employees and managers review and assign transactions to expense reports.

Related Objects

AP_EXPENSE_FEED_LINES_ALL is a central hub in the credit card feed data model. Its most direct child table is AP_EXPENSE_FEED_DISTS_ALL, which stores accounting distributions generated for the feed line. Key parent tables, as defined by its foreign keys, include AP_CARDS_ALL (corporate cards), AP_CARD_PROGRAMS_ALL, AP_CARD_CODES_ALL, and FND_CURRENCIES. The table AP_EXPENSE_FEED_HEADERS_ALL may serve as a logical header, grouping lines from a single feed file. For functional processing, the data is manipulated through standard Oracle Payables interfaces and APIs, and it is often referenced in custom reports designed to analyze corporate card spending prior to its full reconciliation in the Payables or iExpenses modules.