Results for “ap_exp_report_dists_all”

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

Overview

AP_EXP_REPORT_DISTS_ALL is the Oracle Payables (AP) transaction table that stores expense distributions for expense reports entered through Oracle Internet Expenses and processed in Payables. Each row represents one accounting distribution line — the coding combination, amount, project and award attributes, and preparer-entered detail — that is generated for an expense report line before the report is audited, approved, and ultimately interfaced to Oracle Payables as an invoice. The table resides in the AP schema and is a core child object of the expense report entry model in Oracle E-Business Suite 12.1.1 and 12.2.2.

From a modeling perspective, the metadata's Data Vault classification heuristic identifies this object as a link. That classification is a suggestion: the table's high dependency on adjacent expense report headers and lines, combined with its numerous foreign key relationships to Projects, Tasks, Awards, and HR organizations, places it at the intersection of several business entities rather than at the center of a single descriptive hub.

Key Information Stored

The table contains 52 documented columns. The surrogate primary key is REPORT_DISTRIBUTION_ID, defined by unique index AP_EXP_REPORT_DISTS_U1 and by the AP_EXP_REPORT_DISTS_PK constraint. This is a system-generated identifier with no business meaning.

• REPORT_HEADER_ID — foreign key to AP_EXPENSE_REPORT_HEADERS_ALL, tying the distribution to the parent expense report.
• REPORT_LINE_ID — foreign key to AP_EXPENSE_REPORT_LINES_ALL, identifying the specific expense line being distributed.
• ORG_ID — the operating unit that owns the distribution, the basis for multi-org security filtering.
• CODE_COMBINATION_ID — the accounting flexfield combination to which the expense is charged; SEGMENT1 through SEGMENT30 carry the individual segment values described by that combination.
• AMOUNT — the distributed amount for this distribution line in the report currency.
• SEQUENCE_NUM — ordering of distribution lines within a report line, relevant for multi-distribution and tax allocation scenarios.
• PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_ORGANIZATION_ID — Projects-related attributes referencing PA_PROJECTS_ALL, PA_TASKS, IGF_AW_AWARD_ALL, and HR_ALL_ORGANIZATION_UNITS respectively.
• COST_CENTER — the cost center associated with the expenditure.
• PREPARER_MODIFIED_FLAG — indicates whether the distribution was manually altered by the preparer versus system-generated.
• RECEIPT_CURRENCY_CODE, RECEIPT_CONVERSION_RATE, RECEIPT_CURRENCY_AMOUNT — original receipt currency information retained for reimbursement and audit.
• WEB_PARAMETER_ID — links to the web entry context under which the distribution was created.
• WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN provide standard audit trail tracking.

Common Use Cases and Queries

AP_EXP_REPORT_DISTS_ALL supports expense distribution reporting, audit reconstruction, and interface troubleshooting to Payables. Typical scenarios include determining the accounting charged for a given report line, validating project and award coding, and reconciling amounts that flow into the AP invoice created by the Expense Report Import process.

Common SQL patterns join distributions to their header, line, and accounting flexfield structures. For example, filtering by ORG_ID and REPORT_HEADER_ID retrieves all distributions for a report; joining CODE_COMBINATION_ID to GL_CODE_COMBINATIONS resolves the concatenated account; and joining PROJECT_ID or TASK_ID to Projects tables validates project setup. Analysts also aggregate AMOUNT by CODE_COMBINATION_ID or COST_CENTER to produce spend-by-account reporting.

Related Objects

The following are the most significant related objects, based on documented foreign key relationships:

• AP_EXPENSE_REPORT_HEADERS_ALL — parent report header; join on REPORT_HEADER_ID.
• AP_EXPENSE_REPORT_LINES_ALL — report expense line; join on REPORT_LINE_ID.
• PA_PROJECTS_ALL — project definition; join on PROJECT_ID.
• PA_TASKS — project task; join on TASK_ID.
• HR_ALL_ORGANIZATION_UNITS — expenditure organization; join on EXPENDITURE_ORGANIZATION_ID.
• IGF_AW_AWARD_ALL — award for grants-enabled implementations; join on AWARD_ID.
• GL_CODE_COMBINATIONS — accounting flexfield validation; join on CODE_COMBINATION_ID (a reference implied by the distribution structure rather than a documented FK).

Together these objects form the expense report distribution model that feeds downstream invoice creation and accounting in Oracle Payables.