Search Results ap_distribution_set_lines_all




Overview
Explore in AI Chat

Overview

The AP_DISTRIBUTION_SET_LINES_ALL table is a core data object within the Oracle E-Business Suite Payables (AP) module, specifically for versions 12.1.1 and 12.2.2. It stores the individual line-level definitions that constitute a Distribution Set. A Distribution Set is a predefined template of accounting distributions (e.g., expense, liability, asset clearing accounts) that can be automatically applied to an invoice during entry, streamlining data input and ensuring consistent accounting. This table holds the detailed chart of accounts combinations and associated project accounting details for each line, while the header information, such as the set name, is stored in the parent table AP_DISTRIBUTION_SETS_ALL. Its role is critical for the automated and accurate generation of accounting distributions for supplier invoices.

Key Information Stored

The table's structure is defined by its primary key, a composite of DISTRIBUTION_SET_ID and DISTRIBUTION_SET_LINE_NUMBER, which uniquely identifies each line within a set. Key columns include DISTRIBUTION_SET_ID, which links to the parent header; DIST_CODE_COMBINATION_ID, which holds the foreign key to the specific General Ledger (GL) account from GL_CODE_COMBINATIONS; and SET_OF_BOOKS_ID, linking to the accounting ledger. For organizations using Oracle Projects, critical columns include TASK_ID, EXPENDITURE_TYPE, and EXPENDITURE_ORGANIZATION_ID, which allow the Distribution Set to allocate invoice costs directly to specific project tasks and expenditure categories. The table also typically includes columns for line amounts or percentages, though these are not explicitly listed in the provided metadata.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting the accounting distributions generated on invoices. Analysts can trace the applied distributions back to the source template lines. Common reporting needs include listing all distribution sets and their component account codes for a given ledger, or validating project-related setups. A sample query to retrieve this information would join to the related header and code combination tables:

  • SELECT ds.distribution_set_name,
           dsl.distribution_set_line_number,
           gcc.segment1, gcc.segment2, gcc.segment3
    FROM ap_distribution_set_lines_all dsl
    JOIN ap_distribution_sets_all ds ON dsl.distribution_set_id = ds.distribution_set_id
    JOIN gl_code_combinations gcc ON dsl.dist_code_combination_id = gcc.code_combination_id
    WHERE dsl.set_of_books_id = :ledger_id
    ORDER BY 1, 2;

Another critical scenario is during the creation or modification of Distribution Sets via the Payables user interface, where data is inserted or updated in this table.

Related Objects

As indicated by its foreign key constraints, AP_DISTRIBUTION_SET_LINES_ALL has integral relationships with several fundamental EBS tables. Its primary relationship is with AP_DISTRIBUTION_SETS_ALL, the header table. For accounting integrity, it references GL_CODE_COMBINATIONS for the specific account and GL_SETS_OF_BOOKS_11I for the ledger context. When configured for use with Oracle Projects, it depends on PA_TASKS, PA_EXPENDITURE_TYPES, and PA_EXP_ORGS_IT to define project-specific charge allocations. In application processing, this table is read by the invoice distribution engine, and its definitions are ultimately realized as actual invoice distributions stored in tables such as AP_INVOICE_DISTRIBUTIONS_ALL.