Search Results ar_receipt_classes

Overview

The AR_RECEIPT_CLASSES table is a core reference table within Oracle E-Business Suite Receivables (AR) that defines the fundamental categorization of all incoming receipts. It stores the master list of receipt classes, which are high-level templates that control the default behavior, processing rules, and accounting for different types of cash receipts. Every receipt entered into the system must be associated with a valid receipt class. This table is central to the configuration of the Receipts Management workflow, as it links to receipt methods and dictates the subsequent processing steps, such as remittance, application, and clearance.

Key Information Stored

While the provided metadata does not list specific columns, based on its documented role and standard Oracle EBS structure, the table typically contains the following key attributes. The primary key is RECEIPT_CLASS_ID, a unique internal identifier. The most critical user-facing column is usually NAME, which holds the descriptive name of the receipt class (e.g., "Standard Receipts," "Miscellaneous Receipts," "Bill of Exchange"). Other significant columns often include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY for auditing, and various flags controlling class behavior, such as whether it requires remittance, allows on-account applications, or is active for use.

Common Use Cases and Queries

This table is primarily referenced for setup validation, troubleshooting, and reporting on receipt configuration. Common scenarios include verifying the active receipt classes available for assignment to a new receipt method or identifying all receipt methods linked to a specific class. A typical query retrieves the basic setup information:

• SELECT receipt_class_id, name, creation_date FROM ar_receipt_classes WHERE enabled_flag = 'Y' ORDER BY name;

Another frequent use case is joining to AR_RECEIPT_METHODS to analyze the complete receipt processing hierarchy for support or audit purposes:

• SELECT rc.name AS class_name, rm.name AS method_name FROM ar_receipt_classes rc, ar_receipt_methods rm WHERE rc.receipt_class_id = rm.receipt_class_id ORDER BY 1, 2;

Related Objects

As indicated by the foreign key metadata, AR_RECEIPT_CLASSES has direct relationships with several key transactional and setup tables. The AR_RECEIPT_METHODS table is its primary child; each receipt method must be assigned a valid RECEIPT_CLASS_ID from this table. The FV_AR_BATCHES_ALL table (related to Funds Capture) also references it, linking payment batches to a receipt class. Furthermore, receipt classes are integral to the AutoLockbox and Receipts API processes, where the class determines the validation and posting rules for imported or programmatically created receipts.