Search Results po_distributions_all
The PO_DISTRIBUTIONS_ALL table is a critical entity in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, serving as the foundation for procurement and financial distribution tracking within the Purchasing module. This table stores detailed distribution-level information for purchase orders (POs), requisitions, and blanket agreements, linking procurement transactions to accounting entries in the General Ledger (GL). Below is a detailed analysis of its structure, purpose, key columns, and integration points.
Purpose and Functional Overview
The PO_DISTRIBUTIONS_ALL table captures financial and operational data for each distribution line associated with a PO document. It enables:- Cost Allocation: Distributes PO line amounts across multiple accounts, projects, or tasks.
- Budgetary Control: Tracks encumbrances and expenditures for funds checking.
- GL Integration: Generates accounting entries via the Create Accounting process.
- Multi-Org Support: Stores data for all operating units (indicated by
ORG_ID
).
Key Columns and Relationships
Column | Description | Related Tables |
---|---|---|
PO_DISTRIBUTION_ID | Primary key, unique identifier | - |
PO_HEADER_ID | Links to PO_HEADERS_ALL | PO_HEADERS_ALL |
PO_LINE_ID | Links to PO_LINES_ALL | PO_LINES_ALL |
QUANTITY_ORDERED | Ordered quantity at distribution level | - |
AMOUNT_ORDERED | Distribution amount in transaction currency | - |
DESTINATION_TYPE_CODE | Indicates expense/inventory/asset etc. | - |
CODE_COMBINATION_ID | GL account (links to GL_CODE_COMBINATIONS) | GL_CODE_COMBINATIONS |
ENCUMBERED_FLAG | Indicates if funds are reserved | - |
Integration Points
1. Financial Modules: Distributes amounts to GL via Subledger Accounting (XLA tables).2. Projects: Links to
PA_EXPENDITURE_ITEMS_ALL
for project costing.3. Inventory: Tracks distributions for inventory receipts via
RCV_TRANSACTIONS
.4. Assets: Asset distributions flow to FA tables during capitalization.
Technical Considerations
- Multi-Org Access Control (MOAC): Queries must filter by
ORG_ID
. - Indexes: Key indexes exist on
PO_HEADER_ID
,PO_LINE_ID
, andCODE_COMBINATION_ID
. - Audit Columns: Includes
CREATION_DATE
,LAST_UPDATE_DATE
, andLAST_UPDATED_BY
.
Common Use Cases
1. Custom Reporting: Extracting detailed PO spend by account/department.2. Data Fixes: Correcting misaligned distributions before GL posting.
3. Interface Development: Feeding PO data to external systems.
4. Audit Trails: Tracing historical changes to distributions. This table's centrality in procurement-to-pay processes makes it indispensable for customization, reporting, and troubleshooting in Oracle EBS implementations.
-
Table: PO_DISTRIBUTIONS_ALL
12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_DISTRIBUTIONS_ALL, object_name:PO_DISTRIBUTIONS_ALL, status:VALID, product: PO - Purchasing , description: Purchase order distributions , implementation_dba_data: PO.PO_DISTRIBUTIONS_ALL ,
-
Table: PO_DISTRIBUTIONS_ALL
12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_DISTRIBUTIONS_ALL, object_name:PO_DISTRIBUTIONS_ALL, status:VALID, product: PO - Purchasing , description: Purchase order distributions , implementation_dba_data: PO.PO_DISTRIBUTIONS_ALL ,
-
APPS.GMS_COST_PLUS_EXTN dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.WIP_WF_UPDATE_DATE dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.RCV_HXT_GRP dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PA_PROJ_TSK_UTILS dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PA_WORK_TYPE_UPGRADE dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.RCV_DEFAULT_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_PERIOD_CLOSE_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.CSTPMECS dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_LINES_UPGRADE_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_RCO_VALIDATION_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.RCV_QUANTITIES_S dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_POAPPROVAL_INIT1 dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.WMS_RULES_WORKBENCH_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_POXPOBPS_XMLP_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_TAX_SV dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_MASS_UPDATE_PO_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_WORKFLOW_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PA_CONTROL_API_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.ZX_TAX_RECOVERY_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PSA_BC_XLA_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_INTG_DOCUMENT_FUNDS_GRP dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.INV_DIAG_RCV_IPROC dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.WIP_OSP dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.CST_ACCRUAL_LOAD dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_CANCEL_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.CSE_FA_STAGE_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JAI_CMN_ST_FORMS_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_DISTRIBUTIONS_SV dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.IGC_CC_PO_DIST_ALL_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.CST_ACCRUAL_REC_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.WMS_XDOCK_PEGGING_PUB dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PA_PO_INTEGRATION_UTILS dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.FII_AP_INV_B_C dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_AUTOSOURCE_SV dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.POR_CHANGE_REQUEST_PKG dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_DISTRIBUTIONS_PKG2 dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.INV_UI_PROJECT_LOVS dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.POS_TOTALS_PO_SV dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.GML_PO_INTERFACE dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_DISTRIBUTIONS_PKG1 dependencies on PO_DISTRIBUTIONS_ALL
12.1.1
-
APPS.EAM_DIRECT_ITEMS_VALIDATE_PVT dependencies on PO_DISTRIBUTIONS_ALL
12.1.1