Results for “po_req_distributions_u1”

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

Overview

PO.PO_REQ_DISTRIBUTIONS_ALL is the requisition distribution table in Oracle E-Business Suite, storing the accounting distributions associated with each requisition line. Every requisition line must have at least one accounting distribution, and one row is created for each distribution defined through the Distributions window of the Requisitions form. Each row carries the Accounting Flexfield identifier and the requisition line quantity allocated to that distribution. The table is one of three core requisition tables in the Purchasing module, alongside PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL, and it is central to encumbrance accounting, budgetary control, and project charge-back processing.

The documented physical schema in ETRM 12.2.2 shows 86 columns, a primary key constraint PO_REQ_DISTRIBUTIONS_PK on DISTRIBUTION_ID, and a unique index PO_REQ_DISTRIBUTIONS_U1 on DISTRIBUTION_ID. Data is stored in the APPS_TS_TX_DATA tablespace with PCT Free of 5, and indexes reside in APPS_TS_TX_IDX. Based on foreign key topology, the mined Data Vault classification is satellite-leaning: the table primarily holds descriptive, mutable attributes and accounting context keyed to parent requisition lines rather than acting as a pure hub or link.

Key Information Stored

The surrogate primary key is DISTRIBUTION_ID, which uniquely identifies each distribution row and is also the sole column of the unique index PO_REQ_DISTRIBUTIONS_U1. The most significant columns include:

• DISTRIBUTION_ID — Surrogate primary key and requisition distribution unique identifier.
• REQUISITION_LINE_ID — Foreign key to PO_REQUISITION_LINES_ALL; ties the distribution to its parent line.
• CODE_COMBINATION_ID — Unique identifier for the General Ledger charge account, referencing GL_CODE_COMBINATIONS.
• SET_OF_BOOKS_ID — Set of Books identifier, referencing GL_SETS_OF_BOOKS.
• REQ_LINE_QUANTITY — Quantity allocated to this distribution.
• ENCUMBERED_FLAG / ENCUMBERED_AMOUNT / GL_ENCUMBERED_DATE / GL_ENCUMBERED_PERIOD_NAME — Encumbrance state, amount, and the GL date and period in which funds were encumbered.
• BUDGET_ACCOUNT_ID / ACCRUAL_ACCOUNT_ID / VARIANCE_ACCOUNT_ID — Additional accounting flexfield references for budgetary, accrual, and variance postings.
• PROJECT_ID / TASK_ID / EXPENDITURE_TYPE / EXPENDITURE_ORGANIZATION_ID — Project accounting context for project-charged requisitions.
• SOURCE_REQ_DISTRIBUTION_ID — Self-referencing link to an originating distribution.
• REQ_LINE_AMOUNT / REQ_LINE_CURRENCY_AMOUNT — Distribution amount and its currency-denominated value.
• ORG_ID — Operating unit identifier supporting multi-org access control.
• Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY.

Common Use Cases and Queries

Typical reporting scenarios include retrieving the accounting distributions for a requisition line, analyzing encumbrance balances by charge account, and validating project and award funding. A representative query joins distributions to lines and headers:

• List distributions for a line: SELECT DISTRIBUTION_ID, CODE_COMBINATION_ID, REQ_LINE_QUANTITY, ENCUMBERED_AMOUNT FROM PO_REQ_DISTRIBUTIONS_ALL WHERE REQUISITION_LINE_ID = :line_id;
• Reconcile encumbrances to GL: filter on GL_ENCUMBERED_PERIOD_NAME and join CODE_COMBINATION_ID to GL_CODE_COMBINATIONS.
• Project charge analysis: join PROJECT_ID and TASK_ID to PA_PROJECTS_ALL and PA_TASKS, grouping REQ_LINE_AMOUNT by expenditure type.
• Funds checking audit: inspect FAILED_FUNDS_LOOKUP_CODE and PREVENT_ENCUMBRANCE_FLAG for distributions that failed budgetary validation.

Related Objects

The following tables reference or are referenced by PO_REQ_DISTRIBUTIONS_ALL through documented foreign keys:

• PO_REQUISITION_LINES_ALL — parent line via REQUISITION_LINE_ID.
• GL_CODE_COMBINATIONS — via CODE_COMBINATION_ID, BUDGET_ACCOUNT_ID, ACCRUAL_ACCOUNT_ID, and VARIANCE_ACCOUNT_ID.
• GL_SETS_OF_BOOKS — via SET_OF_BOOKS_ID.
• PO_DISTRIBUTIONS_ALL — references this table through REQ_DISTRIBUTION_ID when a requisition distribution is copied to a purchase order distribution.
• PO_REQUISITIONS_INTERFACE_ALL — references REQ_DISTRIBUTION_ID during requisition import.
• RCV_SHIPMENT_LINES and RCV_TRANSACTIONS — reference REQ_DISTRIBUTION_ID for receiving and delivery accounting.
• PA_PROJECTS_ALL and PA_TASKS — via PROJECT_ID and TASK_ID for project charging.
• IGF_AW_AWARD_ALL — via AWARD_ID for grant-funded requisitions.
• PA_BC_COMMITMENTS_ALL and GMS_AWARD_DISTRIBUTIONS — reference DISTRIBUTION_ID for commitment and award reporting.