Search Results pay_us_rpt_totals details of ebs query in project object




The PO_DISTRIBUTIONS_ALL_EBS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical entity within the Purchasing (PO) module, serving as the foundational repository for purchase order distribution data. This table stores detailed distribution-level information for purchase orders, requisitions, and blanket agreements, enabling organizations to track financial accounting, budgetary control, and expense allocation across multiple projects, tasks, and general ledger accounts. Below is a detailed analysis of its structure, purpose, and integration within Oracle EBS. ### **Key Attributes of PO_DISTRIBUTIONS_ALL_EBS** 1. **Primary Key & Core Columns** - PO_DISTRIBUTION_ID: Unique identifier for each distribution line. - PO_HEADER_ID: References the parent purchase order in PO_HEADERS_ALL. - PO_LINE_ID: Links to the purchase order line in PO_LINES_ALL. - DESTINATION_TYPE_CODE: Defines whether the distribution is for inventory ('INVENTORY'), expense ('EXPENSE'), or a shop floor ('SHOP FLOOR'). 2. **Financial & Accounting Attributes** - CODE_COMBINATION_ID: GL account combination from GL_CODE_COMBINATIONS. - QUANTITY_ORDERED & QUANTITY_DELIVERED: Tracks item quantities. - RATE & AMOUNT: Stores unit price and extended cost. - CHARGE_ACCOUNT_ID: Used for project-related distributions. 3. **Project & Budget Controls** - PROJECT_ID, TASK_ID: Integrates with Oracle Projects. - BUDGET_ACCOUNT_ID: Enforces budgetary compliance. 4. **Tax & Multi-Org Attributes** - TAX_RECOVERABLE_FLAG: Indicates if tax is recoverable. - ORG_ID: Supports multi-org deployments. ### **Functional Role in Oracle EBS** 1. **Purchase Order Processing** - Distributes costs across GL accounts, projects, or inventory locations. - Enables matching with invoices in AP_INVOICE_DISTRIBUTIONS_ALL. 2. **Integration with Other Modules** - General Ledger (GL): Posting accounting entries via GL_INTERFACE. - Inventory (INV): Updates item costs for inventory destinations. - Projects (PA): Allocates expenses to project tasks. 3. **Budgetary Control** - Validates funds availability via ENCUMBRANCE_ACCOUNTING. - Tracks commitments before invoice matching. ### **Technical Considerations** 1. **Indexes & Performance** - Key indexes: PO_DISTRIBUTIONS_N1 (PO_HEADER_ID), PO_DISTRIBUTIONS_N2 (PO_LINE_ID). - High-volume transactions may require partitioning in 12.2.2. 2. **Custom Extensions** - Custom columns can be added via AD_ZD in 12.2.2 for zero-downtime patching. 3. **Data Flow** - Populated during PO creation or requisition conversion. - Updated during goods receipt (RCV_TRANSACTIONS) and invoice matching. ### **Conclusion** The PO_DISTRIBUTIONS_ALL_EBS table is indispensable for financial accountability, multi-org compliance, and cross-module integration in Oracle EBS. Its design ensures accurate cost distribution, auditability, and seamless interoperability with GL, AP, and Projects, making it a cornerstone of procurement and financial operations.