Results for “create_distribution_flag”

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

Overview

AP_EXPENSE_FEED_LINES_ALL is the core transaction table in the Oracle Payables (AP) module that stores detailed information about credit card transactions imported from a credit card issuer. It resides in the AP schema and is a key component of the Oracle Internet Expenses credit card feed process, which allows corporations to automatically load employee corporate card charges into Payables for expense reimbursement and reconciliation. Each row represents one credit card transaction line as received from the card provider, capturing merchant, tax, freight, currency, and item-level detail before the line is converted into an expense report or invoice distribution.

From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning. This suggests the table functions primarily as an attribute-bearing record (satellite) surrounding the transactional detail of a credit card feed, rather than serving as an enterprise business hub or link. The presence of numerous descriptive and foreign-key attributes reinforces this interpretation: the table's identity is anchored by the FEED_LINE_ID surrogate, while its context is defined by references to card, program, code, currency, and employee entities.

Key Information Stored

The table contains 98 documented columns in 12.2.2. The most operationally significant are:

• FEED_LINE_ID — the surrogate primary key, enforced by the unique index AP_EXPENSE_FEED_LINES_U1 and the AP_EXPENSE_FEED_LINES_PK constraint. This is the sole documented business-key candidate.
• EMPLOYEE_ID — identifies the employee to whom the corporate card is assigned; foreign key to PSB_EMPLOYEES.
• CARD_ID and CARD_PROGRAM_ID — link the transaction to the specific card (AP_CARDS_ALL) and card program (AP_CARD_PROGRAMS_ALL).
• CARD_NUMBER and REFERENCE_NUMBER / ALT_REFERENCE_NUMBER — issuer-supplied identifiers used for matching and de-duplication.
• AMOUNT, ORIGINAL_CURRENCY_AMOUNT, ORIGINAL_CURRENCY_CODE, POSTED_CURRENCY_CODE, and CURRENCY_CONVERSION_RATE — the monetary core, supporting multi-currency feeds via FND_CURRENCIES.
• TRANSACTION_DATE and POSTED_DATE — the transaction and card processing dates.
• MERCHANT_NAME, MERCHANT_CITY, MERCHANT_COUNTRY, and related merchant address columns — vendor detail for reporting and matching.
• TAX_AMOUNT, FREIGHT_AMOUNT, DUTY_AMOUNT, and DISCOUNT_AMOUNT — component amounts of the transaction.
• CODE_ID — foreign key to AP_CARD_CODES_ALL, used for expense classification.
• RECORD_TYPE, REJECT_CODE, and CREATE_DISTRIBUTION_FLAG — control indicators governing validation and downstream distribution creation.
• ORG_ID — multi-org operating unit context, plus standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, etc.).

Common Use Cases and Queries

Typical uses include diagnosing feed load failures, reconciling imported transactions against employee expense reports, and reporting on corporate card spend by program, employee, or merchant. A common query joins the line to its card and employee records:

• SELECT l.FEED_LINE_ID, l.CARD_NUMBER, l.MERCHANT_NAME, l.AMOUNT, l.TRANSACTION_DATE FROM AP_EXPENSE_FEED_LINES_ALL l WHERE l.ORG_ID = :org_id AND l.TRANSACTION_DATE BETWEEN :from_date AND :to_date;
• Identifying rejected lines: WHERE l.REJECT_CODE IS NOT NULL.
• Auditing lines that have not generated distributions by querying the AP_EXPENSE_FEED_DISTS_ALL child table on FEED_LINE_ID.

Related Objects

• AP_CARDS_ALL — joined on CARD_ID; supplies corporate card definitions.
• AP_CARD_PROGRAMS_ALL — joined on CARD_PROGRAM_ID; defines the issuer program.
• AP_CARD_CODES_ALL — joined on CODE_ID; provides expense code classification.
• FND_CURRENCIES — joined on ORIGINAL_CURRENCY_CODE and POSTED_CURRENCY_CODE.
• PSB_EMPLOYEES — joined on EMPLOYEE_ID; identifies the cardholder.
• AP_EXPENSE_FEED_DISTS_ALL — child table referencing FEED_LINE_ID; holds generated accounting distributions for each line.