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:

Payment Tracking: Maintains real-time updates on outstanding balances, supporting aging reports and collections.
Cash Management: Integrates with the Cash Management module to reconcile payments against schedules.
Revenue Recognition: Works with the Revenue Recognition engine to align revenue with payment milestones.
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:

The AMOUNT_DUE_REMAINING is reduced in AR_PAYMENT_SCHEDULES_ALL.
A corresponding entry is made in AR_CASH_RECEIPTS_ALL.
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.

Table: AR_PAYMENT_SCHEDULES_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_PAYMENT_SCHEDULES_ALL, object_name:AR_PAYMENT_SCHEDULES_ALL, status:VALID, product: AR - Receivables , description: All transactions except adjustments and miscellaneous cash receipts , implementation_dba_data: AR.AR_PAYMENT_SCHEDULES_ALL ,
Table: AR_PAYMENT_SCHEDULES_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_PAYMENT_SCHEDULES_ALL, object_name:AR_PAYMENT_SCHEDULES_ALL, status:VALID, product: AR - Receivables , description: All transactions except adjustments and miscellaneous cash receipts , implementation_dba_data: AR.AR_PAYMENT_SCHEDULES_ALL ,
Table: AR_CASH_RECEIPTS_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CASH_RECEIPTS_ALL, object_name:AR_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: Detailed receipt information , implementation_dba_data: AR.AR_CASH_RECEIPTS_ALL ,
Table: AR_CASH_RECEIPTS_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CASH_RECEIPTS_ALL, object_name:AR_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: Detailed receipt information , implementation_dba_data: AR.AR_CASH_RECEIPTS_ALL ,
Table: AR_RECEIVABLE_APPLICATIONS_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_RECEIVABLE_APPLICATIONS_ALL, object_name:AR_RECEIVABLE_APPLICATIONS_ALL, status:VALID, product: AR - Receivables , description: Accounting information for cash and credit memo applications , implementation_dba_data: AR.AR_RECEIVABLE_APPLICATIONS_ALL ,
Table: AR_RECEIVABLE_APPLICATIONS_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_RECEIVABLE_APPLICATIONS_ALL, object_name:AR_RECEIVABLE_APPLICATIONS_ALL, status:VALID, product: AR - Receivables , description: Accounting information for cash and credit memo applications , implementation_dba_data: AR.AR_RECEIVABLE_APPLICATIONS_ALL ,
Table: AR_ADJUSTMENTS_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_ADJUSTMENTS_ALL, object_name:AR_ADJUSTMENTS_ALL, status:VALID, product: AR - Receivables , description: Pending and approved invoice adjustments , implementation_dba_data: AR.AR_ADJUSTMENTS_ALL ,
Table: AR_ADJUSTMENTS_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_ADJUSTMENTS_ALL, object_name:AR_ADJUSTMENTS_ALL, status:VALID, product: AR - Receivables , description: Pending and approved invoice adjustments , implementation_dba_data: AR.AR_ADJUSTMENTS_ALL ,
Table: AR_BPA_PRINT_REQUESTS 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_BPA_PRINT_REQUESTS, object_name:AR_BPA_PRINT_REQUESTS, status:VALID, product: AR - Receivables , description: Release 11i: Used by Bill Presentment Architecture , implementation_dba_data: AR.AR_BPA_PRINT_REQUESTS ,
Table: AR_BPA_PRINT_REQUESTS 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_BPA_PRINT_REQUESTS, object_name:AR_BPA_PRINT_REQUESTS, status:VALID, product: AR - Receivables , description: Release 11i: Used by Bill Presentment Architecture , implementation_dba_data: AR.AR_BPA_PRINT_REQUESTS ,
Table: AR_AUDIT_DATA 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_AUDIT_DATA, object_name:AR_AUDIT_DATA, status:VALID, product: AR - Receivables , description: Temporary table used in the rollforward process , implementation_dba_data: AR.AR_AUDIT_DATA ,
Table: AR_AUDIT_DATA 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_AUDIT_DATA, object_name:AR_AUDIT_DATA, status:VALID, product: AR - Receivables , description: Temporary table used in the rollforward process , implementation_dba_data: AR.AR_AUDIT_DATA ,
Table: AR_DISPUTE_HISTORY 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_DISPUTE_HISTORY, object_name:AR_DISPUTE_HISTORY, status:VALID, product: AR - Receivables , description: A history of invoice disputes for each payment schedule , implementation_dba_data: AR.AR_DISPUTE_HISTORY ,
Table: AR_DISPUTE_HISTORY 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_DISPUTE_HISTORY, object_name:AR_DISPUTE_HISTORY, status:VALID, product: AR - Receivables , description: A history of invoice disputes for each payment schedule , implementation_dba_data: AR.AR_DISPUTE_HISTORY ,
Table: AR_CORR_PAY_SCHED_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CORR_PAY_SCHED_ALL, object_name:AR_CORR_PAY_SCHED_ALL, status:VALID, product: AR - Receivables , description: Intersection table to show invoices referenced in a dunning letter , implementation_dba_data: AR.AR_CORR_PAY_SCHED_ALL ,
Table: AR_CORR_PAY_SCHED_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CORR_PAY_SCHED_ALL, object_name:AR_CORR_PAY_SCHED_ALL, status:VALID, product: AR - Receivables , description: Intersection table to show invoices referenced in a dunning letter , implementation_dba_data: AR.AR_CORR_PAY_SCHED_ALL ,
Table: AR_MC_PAYMENT_SCHEDULES 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_MC_PAYMENT_SCHEDULES, object_name:AR_MC_PAYMENT_SCHEDULES, status:VALID, product: AR - Receivables , description: Currency-related information about all transactions except adjustments and miscellaneous cash receipts , implementation_dba_data: AR.AR_MC_PAYMENT_SCHEDULES ,
Table: AR_COLLECTORS 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_COLLECTORS, object_name:AR_COLLECTORS, status:VALID, product: AR - Receivables , description: Information about collectors , implementation_dba_data: AR.AR_COLLECTORS ,
Table: AR_COLLECTORS 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_COLLECTORS, object_name:AR_COLLECTORS, status:VALID, product: AR - Receivables , description: Information about collectors , implementation_dba_data: AR.AR_COLLECTORS ,
Table: AR_MC_PAYMENT_SCHEDULES 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_MC_PAYMENT_SCHEDULES, object_name:AR_MC_PAYMENT_SCHEDULES, status:VALID, product: AR - Receivables , description: Currency-related information about all transactions except adjustments and miscellaneous cash receipts , implementation_dba_data: AR.AR_MC_PAYMENT_SCHEDULES ,
Table: AR_AUTOREC_EXCEPTIONS 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_AUTOREC_EXCEPTIONS, object_name:AR_AUTOREC_EXCEPTIONS, status:VALID, product: AR - Receivables , description: Temporary table used to store exceptions found by Automatic Receipts and its related programs , implementation_dba_data: AR.AR_AUTOREC_EXCEPTIONS ,
Table: AR_INTERIM_CASH_RCPT_LINES_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RCPT_LINES_ALL, object_name:AR_INTERIM_CASH_RCPT_LINES_ALL, status:VALID, product: AR - Receivables , description: Temporary table used to store QuickCash payment applications , implementation_dba_data: AR.AR_INTERIM_CASH_RCPT_LINES_ALL ,
Table: AR_MC_RECEIVABLE_APPS 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_MC_RECEIVABLE_APPS, object_name:AR_MC_RECEIVABLE_APPS, status:VALID, product: AR - Receivables , description: Cash and credit memo applications for each reporting set of books , implementation_dba_data: AR.AR_MC_RECEIVABLE_APPS ,
Table: AR_INTERIM_CASH_RCPT_LINES_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RCPT_LINES_ALL, object_name:AR_INTERIM_CASH_RCPT_LINES_ALL, status:VALID, product: AR - Receivables , description: Temporary table used to store QuickCash payment applications , implementation_dba_data: AR.AR_INTERIM_CASH_RCPT_LINES_ALL ,
Table: AR_MC_RECEIVABLE_APPS 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_MC_RECEIVABLE_APPS, object_name:AR_MC_RECEIVABLE_APPS, status:VALID, product: AR - Receivables , description: Cash and credit memo applications for each reporting set of books , implementation_dba_data: AR.AR_MC_RECEIVABLE_APPS ,
Table: AR_CUSTOMER_CALL_TOPICS_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CUSTOMER_CALL_TOPICS_ALL, object_name:AR_CUSTOMER_CALL_TOPICS_ALL, status:VALID, product: AR - Receivables , description: Topic of a customer call , implementation_dba_data: AR.AR_CUSTOMER_CALL_TOPICS_ALL ,
Table: AR_CUSTOMER_CALL_TOPICS_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CUSTOMER_CALL_TOPICS_ALL, object_name:AR_CUSTOMER_CALL_TOPICS_ALL, status:VALID, product: AR - Receivables , description: Topic of a customer call , implementation_dba_data: AR.AR_CUSTOMER_CALL_TOPICS_ALL ,
Table: AR_MC_CASH_BASIS_DISTS_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_MC_CASH_BASIS_DISTS_ALL, object_name:AR_MC_CASH_BASIS_DISTS_ALL, status:VALID, product: AR - Receivables , description: Distribution of payments over revenue accounts, used in Cash Basis Accounting for MRC , implementation_dba_data: AR.AR_MC_CASH_BASIS_DISTS_ALL ,
Table: AR_MC_CASH_BASIS_DISTS_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_MC_CASH_BASIS_DISTS_ALL, object_name:AR_MC_CASH_BASIS_DISTS_ALL, status:VALID, product: AR - Receivables , description: Distribution of payments over revenue accounts, used in Cash Basis Accounting for MRC , implementation_dba_data: AR.AR_MC_CASH_BASIS_DISTS_ALL ,
Table: AR_AUTOREC_EXCEPTIONS 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_AUTOREC_EXCEPTIONS, object_name:AR_AUTOREC_EXCEPTIONS, status:VALID, product: AR - Receivables , description: Temporary table used to store exceptions found by Automatic Receipts and its related programs , implementation_dba_data: AR.AR_AUTOREC_EXCEPTIONS ,
Table: AR_CASH_BASIS_DISTS_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CASH_BASIS_DISTS_ALL, object_name:AR_CASH_BASIS_DISTS_ALL, status:VALID, product: AR - Receivables , description: Distribution of payments over revenue accounts, used in Cash Basis Accounting , implementation_dba_data: AR.AR_CASH_BASIS_DISTS_ALL ,
Table: AR_CASH_BASIS_DISTS_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CASH_BASIS_DISTS_ALL, object_name:AR_CASH_BASIS_DISTS_ALL, status:VALID, product: AR - Receivables , description: Distribution of payments over revenue accounts, used in Cash Basis Accounting , implementation_dba_data: AR.AR_CASH_BASIS_DISTS_ALL ,
Table: AR_BATCHES_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_BATCHES_ALL, object_name:AR_BATCHES_ALL, status:VALID, product: AR - Receivables , description: Receipt batch information , implementation_dba_data: AR.AR_BATCHES_ALL ,
Table: AR_INTERIM_CASH_RECEIPTS_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RECEIPTS_ALL, object_name:AR_INTERIM_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: QuickCash payments processed by the PostBatch program , implementation_dba_data: AR.AR_INTERIM_CASH_RECEIPTS_ALL ,
Table: AR_INTERIM_CASH_RECEIPTS_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RECEIPTS_ALL, object_name:AR_INTERIM_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: QuickCash payments processed by the PostBatch program , implementation_dba_data: AR.AR_INTERIM_CASH_RECEIPTS_ALL ,
Table: RA_TERMS_B 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_TERMS_B, object_name:RA_TERMS_B, status:VALID, product: AR - Receivables , description: Payment Term information , implementation_dba_data: AR.RA_TERMS_B ,
Table: RA_CUST_TRX_TYPES_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_CUST_TRX_TYPES_ALL, object_name:RA_CUST_TRX_TYPES_ALL, status:VALID, product: AR - Receivables , description: Transaction type for invoices, commitments and credit memos , implementation_dba_data: AR.RA_CUST_TRX_TYPES_ALL ,
View: AR_OEX_INVOICE_VIEW 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_OEX_INVOICE_VIEW, object_name:AR_OEX_INVOICE_VIEW, status:VALID, product: AR - Receivables , description: (Invoice view for Oracle Exchange Invoices) , implementation_dba_data: APPS.AR_OEX_INVOICE_VIEW ,
View: AR_PAYMENT_TERM_S_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_PAYMENT_TERM_S_V, object_name:AR_PAYMENT_TERM_S_V, status:VALID, product: AR - Receivables , description: payment term shared extract , implementation_dba_data: APPS.AR_PAYMENT_TERM_S_V ,
Table: RA_TERMS_B 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_TERMS_B, object_name:RA_TERMS_B, status:VALID, product: AR - Receivables , description: Payment Term information , implementation_dba_data: AR.RA_TERMS_B ,
View: AR_OEX_INVOICE_VIEW 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_OEX_INVOICE_VIEW, object_name:AR_OEX_INVOICE_VIEW, status:VALID, product: AR - Receivables , description: (Invoice view for Oracle Exchange Invoices) , implementation_dba_data: APPS.AR_OEX_INVOICE_VIEW ,
View: AR_PAYMENT_TERM_S_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_PAYMENT_TERM_S_V, object_name:AR_PAYMENT_TERM_S_V, status:VALID, product: AR - Receivables , description: payment term shared extract , implementation_dba_data: APPS.AR_PAYMENT_TERM_S_V ,
Table: RA_CUST_TRX_TYPES_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_CUST_TRX_TYPES_ALL, object_name:RA_CUST_TRX_TYPES_ALL, status:VALID, product: AR - Receivables , description: Transaction type for invoices, commitments and credit memos , implementation_dba_data: AR.RA_CUST_TRX_TYPES_ALL ,
View: ARFV_CASH_APPLICATIONS_OLD1 12.1.1
product: AR - Receivables , description: - Retrofitted , implementation_dba_data: Not implemented in this database ,
View: AR_OEX_CM_VIEW 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_OEX_CM_VIEW, object_name:AR_OEX_CM_VIEW, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_OEX_CM_VIEW ,
View: AR_OEX_CM_VIEW 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_OEX_CM_VIEW, object_name:AR_OEX_CM_VIEW, status:VALID, product: AR - Receivables , implementation_dba_data: APPS.AR_OEX_CM_VIEW ,
View: ARFV_CASH_APPLICATIONS_OLD1 12.2.2
product: AR - Receivables , description: - Retrofitted , implementation_dba_data: Not implemented in this database ,
Table: HZ_CUST_ACCOUNTS 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCOUNTS, object_name:HZ_CUST_ACCOUNTS, status:VALID, product: AR - Receivables , description: Stores information about customer accounts. , implementation_dba_data: AR.HZ_CUST_ACCOUNTS ,
View: ARFV_AR_PAYMENT_SCHEDULES_OLD1 12.2.2
product: AR - Receivables , description: - Retrofitted , implementation_dba_data: Not implemented in this database ,
Table: HZ_CUST_ACCOUNTS 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCOUNTS, object_name:HZ_CUST_ACCOUNTS, status:VALID, product: AR - Receivables , description: Stores information about customer accounts. , implementation_dba_data: AR.HZ_CUST_ACCOUNTS ,