Search Results charges_schedule

Overview

APPS.AR_CUST_PROF_CLASS_AMTS is a reporting and integration view in Oracle EBS Receivables (AR) that exposes customer profile class amount and charge configuration data. It is defined in the APPS schema and is closely related to the Oracle Advanced Collections / Receivables credit and collections setup, presenting currency-specific credit limits, minimum overdue balance and overdue invoice rules, interest and penalty charges, and charge schedules associated with a customer profile class. In the context of the Oracle EBS 12.1.1 and 12.2.2 releases, the view is primarily consumed by reporting tools, transactional inquiry forms, and integration interfaces that need to resolve profile-class-level amounts into a single readable projection without directly joining the underlying setup tables.

The view is particularly significant when users search for "charges_schedule." The term maps to the INTEREST_TYPE lookup value CHARGES_SCHEDULE, which the view explicitly decodes to derive the associated interest schedule identifier and schedule name. This makes the view the natural access point for any report or interface that must determine whether a profile class uses a charge schedule for interest and penalty calculation.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects for this view:

• HZ_CUST_PROF_CLASS_AMTS (SYNONYM) — the primary base table supplying the profile class amount rows, aliased as a in the view text. Columns such as OVERALL_CREDIT_LIMIT, TRX_CREDIT_LIMIT, and the interest and penalty attributes originate here.
• AR_CHARGE_SCHEDULES (SYNONYM) — joined via the interest schedule identifier to supply SCHEDULE_NAME for charge-schedule-based interest types.
• GL_DAILY_CONVERSION_TYPES (SYNONYM) — joined to resolve the exchange rate type into its user-facing conversion type name.
• ARPT_SQL_FUNC_UTIL (PACKAGE) — a Receivables utility package whose GET_LOOKUP_MEANING function is called to translate lookup codes into descriptive meanings.

The view therefore consolidates a transactional setup table with reference and lookup resolution logic, producing a denormalized, user-oriented result set.

Key Columns

• PROFILE_CLASS_AMOUNT_ID, PROFILE_CLASS_ID, CURRENCY_CODE — identify the profile class amount row and the currency to which the limits and thresholds apply.
• OVERALL_CREDIT_LIMIT, TRX_CREDIT_LIMIT — overall and per-transaction credit limits.
• AUTO_REC_MIN_RECEIPT_AMOUNT — minimum receipt amount for automatic receipt application.
• EXCHANGE_RATE_TYPE and EXCHANGE_RATE_TYPE_M — the rate type code and its resolved conversion type name.
• MIN_FC_BALANCE_OVERDUE_TYPE / _PERCENT / _AMOUNT and MIN_FC_BALANCE_VALUE — rules and computed value for minimum overdue foreign currency balance.
• MIN_FC_INVOICE_* columns — equivalent rules and computed value for minimum overdue foreign currency invoices.
• MAX_INTEREST_CHARGE, MIN_INTEREST_CHARGE, INTEREST_TYPE, INTEREST_RATE, INTEREST_FIXED_AMOUNT, INTEREST_VALUE — interest charging configuration and the decoded interest value.
• INTEREST_SCHEDULE_ID and INTEREST_SCHEDULE_NAME — decoded only when INTEREST_TYPE is CHARGES_SCHEDULE or CHARGE_PER_TIER, linking the profile class to AR_CHARGE_SCHEDULES.
• PENALTY_TYPE and related lookup meanings — penalty configuration resolved through AR_INTEREST_PENALTY_TYPE.

Common Use Cases and Queries

Typical use cases include credit limit reporting, collections setup review, and interfaces that must resolve charge schedule assignment per profile class. A representative query to locate profile classes using a charge schedule is:

• SELECT profile_class_id, currency_code, interest_type, interest_schedule_id, interest_schedule_name FROM apps.ar_cust_prof_class_amts WHERE interest_type = 'CHARGES_SCHEDULE';

The view is also used to list credit limits by currency and to audit interest and penalty thresholds. Because it joins a maintenance package function for lookup meaning, queries should be treated as read-only reference lookups rather than high-volume transactional extracts.