Results for “ap_expense_feed_dists_v”

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

Overview

AP_EXPENSE_FEED_DISTS_V is a Payables (AP) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes distribution-level data for corporate card expense feeds processed through the Payables expense report interface. The view joins the distribution table, AP_EXPENSE_FEED_DISTS, to the corresponding feed line, AP_EXPENSE_FEED_LINES, and enriches the result with cardholder, card, merchant, tax, and currency attributes. Its principal role is to provide a flattened, query-friendly structure for reporting and integration — most notably for building expense reports from bank and card feed files ahead of Payables invoice import. Because the underlying tables carry denormalized merchant and card data, the view allows report writers and interface developers to retrieve a complete expense distribution record without manually replicating the joins. Status is VALID in the documented environment.

Underlying Base Objects

The view is defined over several objects, with AP_EXPENSE_FEED_DISTS and AP_EXPENSE_FEED_LINES forming its core. AP_EXPENSE_FEED_DISTS holds distribution rows keyed by FEED_DISTRIBUTION_ID and FEED_LINE_ID; AP_EXPENSE_FEED_LINES holds line-level data keyed by FEED_LINE_ID. The two are joined to attach card and employee context. Card data is sourced from AP_CARDS, AP_CARD_PROFILES, and AP_CARD_PROGRAMS, while IBY_FNDCPT_PAYER_ALL_INSTRS_V supplies card number information. Employee identity is resolved through HR_EMPLOYEES_CURRENT_V, HR_PERSON_NAME, and HR_GENERAL, with HR_SECURITY enforcing row-level access. Lookups and utility logic are provided by AP_LOOKUP_CODES, FND_CURRENCY, FND_GLOBAL, and FND_PROFILE. The view therefore sits above both transactional feed data and the reference/master data needed to interpret it.

Key Columns

• FEED_LINE_ID / FEED_DISTRIBUTION_ID — primary keys linking distributions to feed lines.
• INVOICE_ID / INVOICE_LINE_ID — the Payables invoice and line created from the feed.
• AMOUNT / LINE_AMOUNT — distribution amount and line amount respectively.
• DIST_CODE_COMBINATION_ID — the accounting flexfield code combination for the distribution.
• STATUS_LOOKUP_CODE / STATUS_CHANGE_DATE — processing status and its timestamp.
• INVOICED_FLAG / CREATE_DISTRIBUTION_FLAG — indicators for invoicing and distribution creation.
• TAX_CODE, TAX_AMOUNT, TAX_RATE, TAX_TYPE, TAX_PAID_FLAG — tax attributes at both primary and alternate merchant levels.
• MERCHANT_NAME, MERCHANT_NUMBER, MERCHANT_CITY, MERCHANT_COUNTRY — merchant detail for the transaction.
• CARD_NUMBER, CARD_ID, CARD_PROGRAM_ID — card and program identification.
• EMPLOYEE_ID — the cardholder linked via HR.
• ORIGINAL_CURRENCY_CODE / POSTED_CURRENCY_CODE / CURRENCY_CONVERSION_RATE — currency and conversion data.
• TRANSACTION_DATE / POSTED_DATE — transaction and posting timestamps.
• ORG_ID — multi-org operating unit identifier.
• ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield segments.

Common Use Cases and Queries

Typical uses include validating feed distributions before invoice import, auditing merchant and tax data, and reconciling card feed lines to Payables invoices.

SELECT feed_line_id, invoice_id, amount, merchant_name,
       tax_amount, original_currency_code, org_id
FROM   apps.ap_expense_feed_dists_v
WHERE  org_id = :p_org_id
AND    transaction_date >= :p_from_date;

To inspect distributions for a specific invoice line:

SELECT feed_distribution_id, dist_code_combination_id,
       amount, invoiced_flag, status_lookup_code
FROM   apps.ap_expense_feed_dists_v
WHERE  invoice_line_id = :p_invoice_line_id;

Because the view references HR security objects, queries return only cardholder data the session is authorized to see.