Search Results ar_payment_schedules_all




The AR_PAYMENT_SCHEDULES_ALL table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical component of the Accounts Receivable (AR) module, serving as the central repository for tracking payment schedules associated with customer transactions. This table stores detailed information about payment terms, due dates, amounts, and statuses for invoices, debit memos, credit memos, and other AR-related documents. Below is a detailed breakdown of its structure, functionality, and significance within Oracle EBS.

Key Attributes of AR_PAYMENT_SCHEDULES_ALL

  • CUSTOMER_TRX_ID: Links to RA_CUSTOMER_TRX_ALL, associating payment schedules with transactions.
  • PAYMENT_SCHEDULE_ID: Primary key uniquely identifying each payment schedule.
  • DUE_DATE: The date by which payment is expected.
  • AMOUNT_DUE_REMAINING: Tracks unpaid amounts, adjusted for partial payments or adjustments.
  • STATUS: Indicates the payment status (e.g., OP for open, CL for closed).
  • CLASS: Classifies the schedule (e.g., INV for invoice, DM for debit memo).
  • ACTUAL_DATE_CLOSED: Records when the schedule was fully paid or resolved.
  • GL_DATE_CLOSED: The GL date when the schedule was closed.
  • TERMS_ID: References payment terms from RA_TERMS.

Functional Role in Oracle EBS

The table plays a pivotal role in:
  1. Payment Tracking: Maintains real-time updates on outstanding balances, supporting aging reports and collections.
  2. Cash Management: Integrates with the Cash Management module to reconcile payments against schedules.
  3. Revenue Recognition: Works with the Revenue Recognition engine to align revenue with payment milestones.
  4. Adjustments & Write-offs: Logs adjustments (e.g., discounts, write-offs) via AR_ADJUSTMENTS_ALL.

Integration with Other Modules

  • General Ledger (GL): Payment schedules feed into GL entries via the AR accounting engine.
  • Order Management (OM): Links invoices to sales orders through RA_CUSTOMER_TRX_ALL.
  • Collections: Provides data for delinquency tracking and dunning letters.

Technical Considerations

  • Multi-Org Structure: Includes ORG_ID to support multi-org deployments.
  • Indexing: Key indexes include AR_PAYMENT_SCHEDULES_N1 (on CUSTOMER_TRX_ID) and AR_PAYMENT_SCHEDULES_U1 (on PAYMENT_SCHEDULE_ID).
  • Audit Columns: CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE track changes.

Example Use Case

When a partial payment is received:
  1. The AMOUNT_DUE_REMAINING is reduced in AR_PAYMENT_SCHEDULES_ALL.
  2. A corresponding entry is made in AR_CASH_RECEIPTS_ALL.
  3. If fully paid, the STATUS updates to CL and ACTUAL_DATE_CLOSED is populated.

Conclusion

The AR_PAYMENT_SCHEDULES_ALL table is indispensable for AR operations in Oracle EBS, ensuring accurate payment tracking, financial reporting, and integration across modules. Its design supports scalability, compliance, and real-time financial visibility, making it a cornerstone of the AR lifecycle.