Search Results fv_interim_cash_receipts_all

Overview

The AR_RECEIPT_METHODS table is a core master data table within Oracle E-Business Suite Receivables (AR) that defines and stores all valid payment methods for receiving customer payments. It serves as the central reference for how cash, checks, credit cards, wire transfers, and other forms of remittance are processed throughout the order-to-cash cycle. Each receipt method is linked to a receipt class, which determines the fundamental processing steps (such as whether the receipt requires remittance, confirmation, or clearance), making this table critical for configuring the system's cash application and reconciliation workflows in both versions 12.1.1 and 12.2.2.

Key Information Stored

The table's primary identifier is the RECEIPT_METHOD_ID. The NAME column is also a unique key, holding the user-defined name of the receipt method (e.g., 'CHECK', 'CREDIT CARD', 'WIRE'). Key relational columns include RECEIPT_CLASS_ID, which links to AR_RECEIPT_CLASSES to define the processing type, and PAYMENT_CHANNEL_CODE, which links to IBY_FNDCPT_PMT_CHNNLS_B for electronic payment processing via Oracle Payments (IBY). Other significant columns include AUTO_PRINT_PROGRAM_ID for linking to an AutoInvoice program and BR_CUST_TRX_TYPE_ID for associating a billing/remittance transaction type. The table's structure ensures that each payment method is properly categorized and integrated with downstream financial processes.

Common Use Cases and Queries

This table is primarily queried for configuration validation, reporting, and data integrity checks. A common use case is to list all active receipt methods for a given receipt class to set up transaction types or customer profiles. For example, a report to show all receipt methods with their associated classes can be generated using: SELECT arm.name, arc.name FROM ar_receipt_methods arm, ar_receipt_classes arc WHERE arm.receipt_class_id = arc.receipt_class_id ORDER BY 2,1;. Another frequent scenario involves troubleshooting, such as identifying all transactions or cash receipts that used a specific receipt method slated for deactivation by joining to AR_CASH_RECEIPTS_ALL or RA_CUSTOMER_TRX_ALL on the RECEIPT_METHOD_ID.

Related Objects

As indicated by the extensive foreign key relationships, AR_RECEIPT_METHODS is a pivotal reference for numerous transactional and setup tables. Key dependent transactional tables include AR_CASH_RECEIPTS_ALL (recorded receipts), AR_INTERIM_CASH_RECEIPTS_ALL, and RA_CUSTOMER_TRX_ALL (invoices). Setup and interface tables that reference it include RA_CUST_RECEIPT_METHODS (customer payment method assignments), AR_LOCKBOXES_ALL, and AR_PAYMENTS_INTERFACE_ALL. Its integration extends to other modules, evidenced by links to Cash Management (CE_FORECAST_ROWS, CE_TRANSACTION_CODES) and Payments (IBY_TRXN_SUMMARIES_ALL). This wide integration underscores its role as a master definition for payment processing across the EBS suite.