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
(onCUSTOMER_TRX_ID
) andAR_PAYMENT_SCHEDULES_U1
(onPAYMENT_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 inAR_PAYMENT_SCHEDULES_ALL
. - A corresponding entry is made in
AR_CASH_RECEIPTS_ALL
. - If fully paid, the
STATUS
updates to CL andACTUAL_DATE_CLOSED
is populated.
Conclusion
TheAR_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 ,
-
APPS.XTR_HEDGE_PROCESS_P dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.FII_AR_FACTS_AGING_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.IEX_DUNNING_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.OZF_FUND_UTILIZED_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.ARP_DET_DIST_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.OKL_VENDOR_REFUND_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.ARP_PS_UTIL dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.AR_TRX_SUMMARY_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.JA_JAINARDR_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.IEX_DELINQUENCY_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.JA_JAINTSLS_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.IEX_WRITEOFFOBJ_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.ARP_PROCESS_HEADER_POST_COMMIT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.PA_PWP_INVOICE_REL dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.ARP_PS_UTIL dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.AR_IREC_PAYMENTS dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.AR_BUS_EVENT_COVER dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.OKL_BILL_STATUS_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.OKL_CASH_APPL_RULES dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.OKL_VENDOR_REFUND_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.CE_CSH_FCST_POP dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.OKL_CS_WF dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.ASP_INVOICE_ALERT_AGENT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.PV_ENRL_REQUEST_ORDER_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.OZF_FUND_UTILIZED_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.JAI_AR_PROCESSING_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.ARP_PROCESS_HEADER_POST_COMMIT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.ARP_DEDUCTION dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.ARP_COLL_IND dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.ARP_DET_DIST_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.JL_BR_AR_LOG_VALIDATION dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.AR_LATE_CHARGE_UPG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.IEX_DELINQUENCY_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.OZF_AR_PAYMENT_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.JA_JAINDTBR_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.2.2
-
APPS.OKL_UPDT_CASH_DTLS dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.PV_ENRL_REQUEST_ORDER_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.ARP_DEDUCTION dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.OKL_CREATE_ADJST_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.JA_JAINARDR_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.OKL_AM_BAL_WRITEOFF_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1
-
APPS.ARP_COLL_IND dependencies on AR_PAYMENT_SCHEDULES_ALL
12.1.1