Search Results ar_autocash_hierarchies




Overview
Explore in AI Chat

Overview

The AR_AUTOCASH_HIERARCHIES table is a core setup table within Oracle E-Business Suite Receivables (AR) that defines AutoCash Rule Sets. An AutoCash Rule Set is an ordered sequence of rules that the system follows to automatically apply receipts and credit memos to outstanding transactions during the AutoInvoice and AutoCash processes. This table stores the master definition of these rule sets, which are then assigned to customers via their profile classes or individual profiles, or set as the system default. Its role is central to automating and standardizing the cash application logic, a critical component of the order-to-cash cycle.

Key Information Stored

While the provided metadata does not list specific columns, the primary and foreign key relationships indicate the essential data structure. The table's primary key is AUTOCASH_HIERARCHY_ID, a unique identifier for each rule set. Other columns typically include NAME and DESCRIPTION for the rule set, along with CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing. The table's core function is to serve as a parent record for the ordered list of rules defined in the AR_AUTOCASH_RULES table, which is linked via the AUTOCASH_HIERARCHY_ID foreign key.

Common Use Cases and Queries

The primary use case is configuring and reporting on AutoCash Rule Sets. Administrators create and maintain hierarchies here, which are then referenced throughout the application. Common queries involve listing all defined rule sets, identifying which customers or profile classes use a specific rule set, and finding the default system rule set. For example, to list all rule sets with their assigned rules in order, a query would join AR_AUTOCASH_HIERARCHIES to AR_AUTOCASH_RULES. To find the default rule set for a given operating unit, one would query AR_SYSTEM_PARAMETERS_ALL, joining on AUTOCASH_HIERARCHY_ID. Troubleshooting cash application issues often involves verifying the rule set assigned to a customer's profile and the sequence of its constituent rules.

Related Objects

As per the foreign key metadata, AR_AUTOCASH_HIERARCHIES has direct relationships with several key Receivables tables. AR_AUTOCASH_RULES is a critical child table, storing the individual rules (like "Apply to the oldest invoice first") that make up the hierarchy. AR_CUSTOMER_PROFILES and AR_CUSTOMER_PROFILE_CLASSES reference it to assign a rule set at the customer or class level. AR_SYSTEM_PARAMETERS_ALL references it to define the default AutoCash Rule Set for an operating unit. These relationships ensure the rule set defined in this master table governs the automatic cash application behavior across the entire Receivables module.