Search Results icx_cart_distributions




Overview
Explore in AI Chat

Overview

The ICX_CART_DISTRIBUTIONS table is a core data object within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the distribution table for web requisition headers, storing the detailed accounting and project-based distribution lines associated with items in a shopping cart. Each record in this table represents a single distribution line, allowing a single requisition line item to be split across multiple accounting codes, projects, tasks, or organizations. This structure is fundamental for accurate financial accounting and project costing from the point of requisition creation, ensuring that procurement commitments are recorded against the correct budgetary controls.

Key Information Stored

The table's primary purpose is to hold distribution-level details for requisition lines. While the full column list is extensive, the critical fields include the composite primary key of CART_ID and DISTRIBUTION_ID, which uniquely identifies each distribution line. Other significant columns typically store the distribution quantity and amount, the accounting code (comprising CODE_COMBINATION_ID for the general ledger account), and references to project accounting entities like PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE. Additional columns often capture expenditure organization (EXPENDITURE_ORGANIZATION_ID), destination type (e.g., inventory, expense), and the associated requisition line identifier (CART_LINE_ID) to link back to the specific item in the cart.

Common Use Cases and Queries

This table is central to reporting and troubleshooting the financial distribution of procurement requests. Common use cases include auditing requisition accounting before approval, reconciling projected expenditures against budgets, and extracting data for custom spend analysis reports. A typical query joins this table to the header (ICX_SHOPPING_CARTS) and lines tables to analyze distributions.

  • Sample Query Pattern: To retrieve all distributions for a specific requisition (cart), a developer might use: SELECT d.* FROM icx_cart_distributions d, icx_shopping_carts c WHERE d.cart_id = c.cart_id AND c.req_number = 'REQ123456';
  • Reporting Use Case: Generating a report showing the total requisition amount distributed to each general ledger account by joining to GL_CODE_COMBINATIONS on CODE_COMBINATION_ID.
  • Troubleshooting: Identifying requisition lines with invalid or missing accounting distributions by checking for NULL or invalid CODE_COMBINATION_ID values.

Related Objects

As documented in the provided ETRM metadata, ICX_CART_DISTRIBUTIONS has a direct and critical foreign key relationship with the iProcurement shopping cart header table.

  • ICX_SHOPPING_CARTS: This is the primary parent table. The foreign key ICX_CART_DISTRIBUTIONS.CART_ID references ICX_SHOPPING_CARTS.CART_ID. Every distribution must belong to a valid shopping cart/requisition header. This relationship is enforced by the ICX_CART_DISTRIBUTIONS_PK primary key constraint which includes CART_ID.
  • ICX_CART_LINES: While not explicitly listed in the provided metadata, in practice, a foreign key relationship often exists from ICX_CART_DISTRIBUTIONS.CART_LINE_ID to ICX_CART_LINES.CART_LINE_ID, linking each distribution to its specific requisition line item.
  • Financial and Project Tables: The table is extensively joined to reference tables such as GL_CODE_COMBINATIONS, PA_PROJECTS_ALL, and PA_TASKS to resolve the IDs stored in its distribution columns into meaningful descriptions for reporting.