Search Results bill_level_meaning

Overview

The view APPS.AR_CUSTOMER_PROFILE_CLASSES_V is a denormalized reporting and integration interface over the Oracle Receivables customer profile class entity, physically stored in HZ_CUST_PROFILE_CLASSES. A customer profile class defines a reusable set of collections, credit, statement, dunning, and consolidated billing defaults that can be assigned to a customer account and inherited through the customer hierarchy. The view exposes the full attribute set of the profile class together with resolved descriptive names for its foreign key references, allowing report writers and interface developers to present user-meaningful values without writing additional joins.

The view is the canonical source for profile-class-driven behavior in Oracle E-Business Suite 12.1.1 and 12.2.2. It is referenced by Receivables collections, credit management, statements, dunning, AutoCash, and consolidated billing configuration. Because it translates internal codes into display values, it is widely used in customer setup extracts, data-migration validations, and audit reports.

Underlying Base Objects

The view joins the customer profile class table to several reference objects to resolve names:

• HZ_CUST_PROFILE_CLASSES — the driving table, aliased CPC, supplying all profile class attributes.
• AR_COLLECTORS — resolves COLLECTOR_ID to COLLECTOR_NAME.
• AR_STATEMENT_CYCLES — resolves STATEMENT_CYCLE_ID to STATEMENT_CYCLE_NAME.
• RA_TERMS — resolves STANDARD_TERMS to STANDARD_TERMS_NAME.
• AR_DUNNING_LETTER_SETS — resolves DUNNING_LETTER_SET_ID to DUNNING_LETTER_SET_NAME.
• AR_AUTOCASH_HIERARCHIES — resolves AUTOCASH_HIERARCHY_ID to AUTOCASH_HIERARCHY_NAME.
• RA_GROUPING_RULES — resolves GROUPING_RULE_ID to GROUPING_RULE_NAME.
• HZ_PARTIES, AR_STANDARD_TEXT — supporting reference objects in the extended definition.
• ARPT_SQL_FUNC_UTIL — a package supplying the lookup-meanings function used for code translation.

These are exposed as APPS synonyms, so the view can be queried directly from the APPS schema without qualifying the underlying owner. The joins are outer-style in practice, since collectors, statement cycles, terms, dunning sets, hierarchies, and grouping rules are all optional on a profile class.

Key Columns

• CUSTOMER_PROFILE_CLASS_ID, PROFILE_CLASS_NAME, PROFILE_CLASS_DESCRIPTION, STATUS — identity and lifecycle of the class.
• CREDIT_CHECKING, TOLERANCE, INTEREST_CHARGES, INTEREST_PERIOD_DAYS, CHARGE_ON_FINANCE_CHARGE_FLAG — credit and finance-charge controls.
• DISCOUNT_TERMS, DISCOUNT_GRACE_DAYS, STANDARD_TERMS, STANDARD_TERMS_NAME, OVERRIDE_TERMS, PAYMENT_GRACE_DAYS — payment and discount term defaults.
• STATEMENTS, STATEMENT_CYCLE_ID, STATEMENT_CYCLE_NAME, CREDIT_BALANCE_STATEMENTS — statement generation settings.
• DUNNING_LETTERS, DUNNING_LETTER_SET_ID, DUNNING_LETTER_SET_NAME — dunning configuration.
• AUTOCASH_HIERARCHY_ID, AUTOCASH_HIERARCHY_NAME, COPY_METHOD, AUTO_REC_INCL_DISPUTED_FLAG — AutoCash and receipt application behavior.
• TAX_PRINTING_OPTION and TAX_PRINTING_OPTION_MEANING — code plus resolved lookup meaning.
• CONS_INV_FLAG, CONS_INV_TYPE, CONS_INV_TYPE_MEANING — consolidated invoicing indicators.
• CONS_BILL_LEVEL and BILL_LEVEL_MEANING — the consolidated billing level, where BILL_LEVEL_MEANING is derived as initcap(CPC.CONS_BILL_LEVEL). This is the column most commonly searched by users investigating consolidated billing behavior.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield context and segments.
• Standard ROW_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN audit columns.

Common Use Cases and Queries

Typical scenarios include listing active profile classes with their collector and term assignments, validating consolidated billing configuration, and extracting profile class defaults for migration. To retrieve the consolidated billing level meaning for a class:

SELECT profile_class_name, cons_bill_level, bill_level_meaning, cons_inv_flag, cons_inv_type_meaning FROM ar_customer_profile_classes_v WHERE status = 'A';

To audit AutoCash and credit settings by collector:

SELECT profile_class_name, collector_name, credit_checking, tolerance, autocash_hierarchy_name, auto_rec_incl_disputed_flag FROM ar_customer_profile_classes_v ORDER BY collector_name;

Because BILL_LEVEL_MEANING is produced with initcap rather than a lookup function, it is a presentation convenience only; applications should still key on CONS_BILL_LEVEL for logic. Column meanings for tax printing and consolidated invoice type, by contrast, are resolved through ARPT_SQL_FUNC_UTIL.get_lookup_meaning and should be treated as authoritative display values.