Search Results project accounting

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:

Payment Accounting: Tracks GL account combinations (CODE_CONCATENATED) for each payment distribution, ensuring accurate financial postings.
Audit and Reconciliation: Provides traceability from payments back to invoices and their distributions, aiding in dispute resolution and audits.
Tax and Compliance: Stores tax-related attributes (e.g., TAX_CODE), supporting tax reporting and regulatory requirements.
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

Payment Inquiry: Querying AP_PAYMENT_HIST_DISTS alongside AP_PAYMENT_HISTORY to drill into payment details.
GL Reconciliation: Matching GL entries (GL_JE_LINES) to payment distributions using ACCOUNTING_EVENT_ID.
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.

Lookup Type: SECONDARY ACCOUNTING METHOD 12.2.2
product: AP - Payables , meaning: Secondary Accounting Method , description: Selects the secondary method of accounting ,
Lookup Type: SECONDARY ACCOUNTING METHOD 12.1.1
product: AP - Payables , meaning: Secondary Accounting Method , description: Selects the secondary method of accounting ,
Lookup Type: ACCOUNTING BASIS METHOD 12.1.1
product: AP - Payables , meaning: Accounting Basis Method , description: Selects the method of accounting ,
Lookup Type: ACCOUNTING BASIS METHOD 12.2.2
product: AP - Payables , meaning: Accounting Basis Method , description: Selects the method of accounting ,
Lookup Type: ACCOUNTING ERROR TYPE 12.1.1
product: AP - Payables , meaning: Accounting Error Type , description: Types of Accounting Errors ,
Lookup Type: ACCOUNTING ERROR TYPE 12.2.2
product: AP - Payables , meaning: Accounting Error Type , description: Types of Accounting Errors ,
Lookup Type: INVOICE IMPORT SOURCES 12.1.1
product: AP - Payables , meaning: Invoice Import Sources , description: Translation of the seeded invoice import sources ,
Lookup Type: INVOICE IMPORT SOURCES 12.2.2
product: AP - Payables , meaning: Invoice Import Sources , description: Translation of the seeded invoice import sources ,
Lookup Type: SOURCE 12.2.2
product: AP - Payables , meaning: Source , description: Source of invoice data to import from the Payables Open Interface ,
Lookup Type: SOURCE 12.1.1
product: AP - Payables , meaning: Source , description: Source of invoice data to import from the Payables Open Interface ,
Lookup Type: HOLD CODE 12.2.2
product: AP - Payables , meaning: Hold Code , description: The hold codes are also stored as lookups for NLS translations ,
Lookup Type: TRANSFER STATUS 12.1.1
product: AP - Payables , meaning: Transfer Status , description: Transfer Status ,
Lookup Type: TRANSFER STATUS 12.2.2
product: AP - Payables , meaning: Transfer Status , description: Transfer Status ,
Lookup Type: REJECT CODE 12.1.1
product: AP - Payables , meaning: Reject Code , description: Reject Codes for AP Open Interface ,
Lookup Type: POSTING EXCEPTIONS 12.2.2
product: AP - Payables , meaning: Posting Exceptions , description: Posting exceptions for the invoices ,
Lookup Type: VIEW_ACCOUNTING 12.1.1
product: AP - Payables , meaning: View Accounting , description: lookup codes used for NLS translation strings ,
Lookup Type: VIEW_ACCOUNTING 12.2.2
product: AP - Payables , meaning: View Accounting , description: lookup codes used for NLS translation strings ,
Lookup Type: POSTING EXCEPTIONS 12.1.1
product: AP - Payables , meaning: Posting Exceptions , description: Posting exceptions for the invoices ,
Concurrent Program: APAEREP 12.1.1
execution_filename: APXAECTR , product: AP - Payables , user_name: APAEREP , description: Payables Accounting Entries Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: APXBCACN 12.2.2
execution_filename: APXBCACN , product: AP - Payables , user_name: APXBCACN , description: Bank Charge Accounting Upon Notification Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXBCACP 12.1.1
execution_filename: APXBCACP , product: AP - Payables , user_name: APXBCACP , description: Bank Charge Accounting Upon Payment Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXBCACN 12.1.1
execution_filename: APXBCACN , product: AP - Payables , user_name: APXBCACN , description: Bank Charge Accounting Upon Notification Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APAEREP 12.2.2
execution_filename: APXAECTR , product: AP - Payables , user_name: APAEREP , description: Payables Accounting Entries Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Table: AP_PAYMENT_HIST_DISTS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PAYMENT_HIST_DISTS, object_name:AP_PAYMENT_HIST_DISTS, status:VALID, product: AP - Payables , description: The APHD table is populated during the pre-processing of the accounting extract that occurs when the Payables user launches the accounting process. Payment distributions are associated with payment accounting events referenced in each row , implementation_dba_data: AP.AP_PAYMENT_HIST_DISTS ,
Concurrent Program: APXBCACP 12.2.2
execution_filename: APXBCACP , product: AP - Payables , user_name: APXBCACP , description: Bank Charge Accounting Upon Payment Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Table: AP_PAYMENT_HIST_DISTS 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PAYMENT_HIST_DISTS, object_name:AP_PAYMENT_HIST_DISTS, status:VALID, product: AP - Payables , description: The APHD table is populated during the pre-processing of the accounting extract that occurs when the Payables user launches the accounting process. Payment distributions are associated with payment accounting events referenced in each row , implementation_dba_data: AP.AP_PAYMENT_HIST_DISTS ,
Lookup Type: BANK ACCOUNT OPTIONS 12.1.1
product: AP - Payables , meaning: Bank Account Options , description: Navigation Option in Set Up Banks Form ,
Lookup Type: BANK ACCOUNT OPTIONS 12.2.2
product: AP - Payables , meaning: Bank Account Options , description: Navigation Option in Set Up Banks Form ,
Lookup Type: FINANCIALS OPTIONS 12.1.1
product: AP - Payables , meaning: Financials Options , description: Financials system options ,
Lookup Type: FINANCIALS OPTIONS 12.2.2
product: AP - Payables , meaning: Financials Options , description: Financials system options ,
Lookup Type: INV DIST ACCOUNT TYPES 12.2.2
product: AP - Payables , meaning: Inv Dist Account Types , description: Lists the 3 different account types on dists ,
Concurrent Program: APACCENG 12.2.2
execution_filename: APXAEREP , product: AP - Payables , user_name: APACENG , description: Payables Accounting Process , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: APACCENG 12.1.1
execution_filename: APXAEREP , product: AP - Payables , user_name: APACENG , description: Payables Accounting Process , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Lookup Type: INV DIST ACCOUNT TYPES 12.1.1
product: AP - Payables , meaning: Inv Dist Account Types , description: Lists the 3 different account types on dists ,
Lookup Type: SYSTEM OPTIONS 12.1.1
product: AP - Payables , meaning: System Options , description: Payables system options ,
Lookup Type: REJECT CODE 12.2.2
product: AP - Payables , meaning: Reject Code , description: Reject Codes for AP Open Interface ,
Lookup Type: SYSTEM OPTIONS 12.2.2
product: AP - Payables , meaning: System Options , description: Payables system options ,
Lookup Type: CONC_PROCESS_ACCTG 12.2.2
product: AP - Payables , meaning: Conc Process Acctg , description: Report for Concurrent Program ,
Lookup Type: CONC_PROCESS_ACCTG 12.1.1
product: AP - Payables , meaning: Conc Process Acctg , description: Report for Concurrent Program ,
Lookup Type: VENDOR INQUIRY 12.2.2
product: AP - Payables , meaning: Vendor Inquiry , description: VENDOR INQUIRY OPTION ,
Lookup Type: OIE_LINE_LEVEL_ACCOUNTING 12.2.2
product: AP - Payables , meaning: Enable Line Level Accounting , description: Enable Line Level Accounting ,
Lookup Type: EXCHANGE RATE TYPE 12.1.1
product: AP - Payables , meaning: Exchange Rate Type , description: Foreign currency exchange rate types ,
Lookup Type: VENDOR INQUIRY 12.1.1
product: AP - Payables , meaning: Vendor Inquiry , description: VENDOR INQUIRY OPTION ,
Lookup Type: OIE_LINE_LEVEL_ACCOUNTING 12.1.1
product: AP - Payables , meaning: Enable Line Level Accounting , description: Enable Line Level Accounting ,
Lookup Type: EXCHANGE RATE TYPE 12.2.2
product: AP - Payables , meaning: Exchange Rate Type , description: Foreign currency exchange rate types ,
Lookup Type: EVENT STATUS 12.1.1
product: AP - Payables , meaning: Event Status , description: Statuses of AP Accounting Events ,
Lookup Type: EVENT STATUS 12.2.2
product: AP - Payables , meaning: Event Status , description: Statuses of AP Accounting Events ,
Lookup Type: OIE_ALLOCATION_VIEWS 12.1.1
product: AP - Payables , meaning: Allocation Views ,
Lookup Type: OIE_ALLOCATION_VIEWS 12.2.2
product: AP - Payables , meaning: Allocation Views ,
View: PA_PROJECTS_AP_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.PA_PROJECTS_AP_V, object_name:PA_PROJECTS_AP_V, status:VALID, product: AP - Payables , description: (Release 10SC Only) , implementation_dba_data: APPS.PA_PROJECTS_AP_V ,