Search Results ap_payment_hist_dists




The AP_PAYMENT_HIST_DISTS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for payment distribution history, capturing detailed accounting entries associated with supplier payments. It serves as an audit trail for payment distributions, linking them to invoices, accounting events, and general ledger (GL) entries. This table is part of the Accounts Payable (AP) module and is essential for financial reporting, reconciliation, and compliance.

Key Attributes of AP_PAYMENT_HIST_DISTS

The table stores distribution-level details for payments, including:
  • PAYMENT_HIST_DIST_ID: Primary key, uniquely identifying each payment distribution record.
  • PAYMENT_HISTORY_ID: Foreign key linking to AP_PAYMENT_HISTORY, associating distributions with a payment.
  • INVOICE_ID: References AP_INVOICES_ALL, tying the distribution to an invoice.
  • INVOICE_DISTRIBUTION_ID: Links to AP_INVOICE_DISTRIBUTIONS_ALL, connecting to the original invoice distribution.
  • ACCOUNTING_EVENT_ID: Ties the distribution to GL accounting events in XLA_EVENTS.
  • AMOUNT: The monetary value of the distribution, in the payment currency.
  • ACCOUNTING_DATE: The date used for GL period validation.
  • GL_POSTED_DATE: Timestamp when the distribution was posted to the GL.
  • DIST_CODE_CONCATENATED: Concatenated segment values for the accounting flexfield.

Functional Role in Oracle EBS

The table supports:
  1. Payment Accounting: Tracks GL account combinations (CODE_CONCATENATED) for each payment distribution, ensuring accurate financial postings.
  2. Audit and Reconciliation: Provides traceability from payments back to invoices and their distributions, aiding in dispute resolution and audits.
  3. Tax and Compliance: Stores tax-related attributes (e.g., TAX_CODE), supporting tax reporting and regulatory requirements.
  4. Integration with Subledger Accounting (SLA): Works with SLA to generate accounting entries, with ACCOUNTING_EVENT_ID linking to XLA_EVENTS.

Technical Considerations

  • Indexing: Key columns like PAYMENT_HISTORY_ID and INVOICE_DISTRIBUTION_ID are indexed for performance.
  • Partitioning: In high-volume environments, partitioning by ACCOUNTING_DATE may improve query performance.
  • Purge Considerations: Records are retained for audit purposes but may be archived via AP_PURGE utilities.

Common Use Cases

  1. Payment Inquiry: Querying AP_PAYMENT_HIST_DISTS alongside AP_PAYMENT_HISTORY to drill into payment details.
  2. GL Reconciliation: Matching GL entries (GL_JE_LINES) to payment distributions using ACCOUNTING_EVENT_ID.
  3. Custom Reporting: Extracting payment accounting data for internal or regulatory reports.

Differences Between 12.1.1 and 12.2.2

While the core structure remains consistent, Oracle 12.2.2 may introduce:
  • Enhanced integration with SLA and Financial Reporting.
  • Additional columns for cloud-ready features in hybrid deployments.
In summary, AP_PAYMENT_HIST_DISTS is a foundational table for payment accounting in Oracle EBS, ensuring financial integrity and compliance across procure-to-pay processes.