Search Results penalty_schedule_id

Overview

AR_CUST_PROF_CLASS_AMTS is an APPS-owned database view in the Oracle E-Business Suite Receivables (AR) module. It presents the monetary and interest/penalty configuration stored at the customer profile class level. A profile class in Receivables is the template that governs default credit, collection, statement, and dunning behavior for a group of customers; the amount-related attributes of that template are surfaced through this view. The view exists in both 12.1.1 and 12.2.2 and carries a VALID status in the ETRM repository.

The object is a reporting and integration convenience layer. Rather than forcing consumers to join raw profile-class amount rows to lookup tables and conversion-type tables directly, the view resolves coded values into their display meanings and derives consolidated amount figures. Because it exposes decoded columns alongside the underlying identifiers, it is equally usable by BI Publisher reports, custom concurrent programs, and inbound/outbound interfaces that need a flattened, human-readable image of profile class credit and interest settings.

Underlying Base Objects

The view is defined over the following documented objects:

• HZ_CUST_PROF_CLASS_AMTS (synonym, aliased A) — the primary base table holding one row per profile class per currency, including credit limits, minimum overdue balances and invoices, and interest/penalty attributes.
• AR_CHARGE_SCHEDULES (synonym, aliased I) — supplies the schedule name for profile classes whose interest type is a charge schedule or per-tier charge.
• GL_DAILY_CONVERSION_TYPES (synonym, aliased GDC) — supplies the user-facing conversion type name for the exchange rate type assigned to the profile class.
• ARPT_SQL_FUNC_UTIL (package) — a Receivables utility package whose GET_LOOKUP_MEANING function decodes lookup codes into their meanings at query time.

The join to HZ_CUST_PROF_CLASS_AMTS is the driving relationship; AR_CHARGE_SCHEDULES, GL_DAILY_CONVERSION_TYPES, and the lookup decodes are applied to enrich each profile-class-amount row. No additional filtering predicates restrict the result set, so the view returns all profile class amount rows visible to the querying user.

Key Columns

• PROFILE_CLASS_AMOUNT_ID / PROFILE_CLASS_ID — primary key of the amount row and the parent profile class identifier.
• CURRENCY_CODE — the currency in which the profile class amounts are expressed.
• OVERALL_CREDIT_LIMIT / TRX_CREDIT_LIMIT — the aggregate credit limit for the profile class and the per-transaction credit limit.
• AUTO_REC_MIN_RECEIPT_AMOUNT — minimum receipt amount used by AutoReceipts for the class.
• EXCHANGE_RATE_TYPE / EXCHANGE_RATE_TYPE_M — the assigned conversion type code and its decoded name.
• MIN_FC_BALANCE_* and MIN_FC_INVOICE_* — the minimum overdue balance/invoice thresholds, exposed as type, decoded type meaning, percent, amount, and a consolidated _VALUE column that resolves to the amount or percent depending on the selected type.
• MAX_INTEREST_CHARGE / MIN_INTEREST_CHARGE — caps and floors applied to calculated interest.
• INTEREST_TYPE / INTEREST_TYPE_M — the interest or penalty method (for example fixed amount, fixed rate, charges schedule, charge per tier) and its decoded meaning.
• INTEREST_RATE / INTEREST_FIXED_AMOUNT / INTEREST_VALUE — the rate, fixed amount, and the resolved interest value.
• INTEREST_SCHEDULE_ID / INTEREST_SCHEDULE_NAME — populated from AR_CHARGE_SCHEDULES only when the interest type is CHARGES_SCHEDULE or CHARGE_PER_TIER; otherwise NULL.

Common Use Cases and Queries

The view is typically used to audit or report credit and interest policy per profile class, to feed downstream collections or dunning processes, and to validate configuration during implementations. A common query retrieves credit limits and interest settings for a specific currency:

• SELECT profile_class_id, currency_code, overall_credit_limit, trx_credit_limit, interest_type_m, interest_value, interest_schedule_name FROM ar_cust_prof_class_amts WHERE currency_code = 'USD';

To locate profile classes that use a charge schedule rather than a fixed rate:

• SELECT profile_class_id, currency_code, interest_type_m, interest_schedule_id, interest_schedule_name FROM ar_cust_prof_class_amts WHERE interest_schedule_id IS NOT NULL;

To review overdue threshold configuration in resolved form:

• SELECT profile_class_id, min_fc_invoice_overdue_type_m, min_fc_invoice_value, min_fc_balance_overdue_type_m, min_fc_balance_value FROM ar_cust_prof_class_amts;

Because the view decodes lookups through ARPT_SQL_FUNC_UTIL at runtime, reports should reference the _M and _VALUE columns instead of reimplementing lookup joins. Note that penalty or interest scheduling information is only present where INTEREST_TYPE indicates a schedule-based method; for fixed-rate or fixed-amount classes the schedule columns are NULL by design.