Results for “ap_distribution_set_lines_all”

28 results




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

Overview

AP_DISTRIBUTION_SET_LINES_ALL is the Oracle Payables (AP) table that stores the individual line definitions belonging to an AP Distribution Set. A distribution set is a reusable template that determines how an invoice or expense distribution is allocated across accounts, and this table holds one row for each allocation line within that template. It resides in the AP schema and is classified as VALID in Oracle E-Business Suite releases 12.1.1 and 12.2.2.

Because each line references a parent distribution set header while also pointing outward to accounting, project, and award entities, the table functions as a junction-style object. Using the heuristic Data Vault classification mined from its foreign-key structure, it is best modeled as a link — it connects the distribution set header to GL code combinations and to Oracle Projects and Grants constructs. Its primary key is AP_DISTRIBUTION_SET_LINES_PK, composed of DISTRIBUTION_SET_ID and DISTRIBUTION_SET_LINE_NUMBER.

Key Information Stored

The table contains 36 documented columns. The most significant are summarized below.

The surrogate primary key is AP_DISTRIBUTION_SET_LINES_PK (DISTRIBUTION_SET_ID, DISTRIBUTION_SET_LINE_NUMBER). The unique index AP_DISTRIBUTION_SET_LINES_U1 additionally incorporates ORG_ID, making the combination of set, line number, and operating unit the business-key candidate.

Common Use Cases and Queries

Typical reporting needs include listing the accounts and percentages that make up a named distribution set, verifying that a set's percentages total correctly, and tracing which invoices reuse a given template. A common join pattern links the header and line tables:

  • SELECT l.distribution_set_id, l.distribution_set_line_number, l.percent_distribution, g.concatenated_segments FROM ap.ap_distribution_set_lines_all l, ap.ap_distribution_sets_all s, gl.gl_code_combinations_kfv g WHERE l.distribution_set_id = s.distribution_set_id AND l.dist_code_combination_id = g.code_combination_id;
  • Filter by ORG_ID to restrict results to a single operating unit, consistent with the U1 unique index.
  • Sum PERCENT_DISTRIBUTION grouped by DISTRIBUTION_SET_ID to validate that each set reconciles to 100 percent.
  • Join to PA_TASKS, PA_EXPENDITURE_TYPES, and IGF_AW_AWARD_ALL to report project- and award-charged distributions.

Related Objects

The following objects are most significant to this table, joined on the documented foreign keys:

  • AP_DISTRIBUTION_SETS_ALL — Parent header table; join on DISTRIBUTION_SET_ID.
  • GL_CODE_COMBINATIONS — Account definitions; join on DIST_CODE_COMBINATION_ID.
  • GL_SETS_OF_BOOKS_11I — Ledger definition; join on SET_OF_BOOKS_ID.
  • PA_TASKS — Project tasks; join on TASK_ID.
  • PA_EXPENDITURE_TYPES — Project expenditure types; join on EXPENDITURE_TYPE.
  • PA_EXP_ORGS_IT — Expenditure organizations; join on EXPENDITURE_ORGANIZATION_ID.
  • IGF_AW_AWARD_ALL — Grants awards; join on AWARD_ID.

AP Distribution Sets are consumed by the Payables invoice and expense workbenches, and the corresponding OAF/Forms and public APIs that create or apply distribution sets read and write these lines during invoice entry and validation.