Search Results statement_cycle_name

Overview

The AR_CUSTOMER_PROFILE_CLASSES_V view is an Oracle Applications (APPS) dictionary object owned by the APPS schema and classified under the Oracle Receivables (AR) product family. It exposes customer profile class definitions as maintained in the Receivables customer profile class setup, presented as a denormalized, user-facing view suitable for reporting, integration, and inquiry. Customer profile classes drive default collection, credit, statement, dunning, interest, and payment term behavior for customer accounts, so the view is the principal reference point for extracting the configured profile class attributes in a readable form.

The ETRM metadata explicitly flags this object as Release 12.0 Only. In Oracle EBS 12.1.1 and 12.2.2 environments, this view may be absent, may be superseded by a differently named profile class view, or may persist as a legacy compatibility wrapper depending on the patch level and upgrade history of the instance. The reference documentation notes the view text ends mid-column (CPC.ATTRIBUTE_CATEGO), confirming the excerpt is truncated and that additional descriptive flexfield columns follow. Because of this, consultants should validate object existence and column definitions against the live data dictionary before relying on the view in the target release.

Underlying Base Objects

The view is defined primarily over HZ_CUST_PROFILE_CLASSES (aliased CPC), the TCA-backed base table that stores customer profile class records. It joins several related setup and lookup objects to resolve coded identifiers into descriptive names:

• AR_COLLECTORS (COL) — resolves COLLECTOR_ID to COLLECTOR_NAME.
• AR_STATEMENT_CYCLES (CYC) — resolves STATEMENT_CYCLE_ID to STATEMENT_CYCLE_NAME.
• RA_TERMS (TERM) — resolves STANDARD_TERMS to STANDARD_TERMS_NAME.
• AR_DUNNING_LETTER_SETS (DUN_SET) — resolves DUNNING_LETTER_SET_ID to DUNNING_LETTER_SET_NAME.
• AR_AUTOCASH_HIERARCHIES (HIER) — resolves AUTOCASH_HIERARCHY_ID to AUTOCASH_HIERARCHY_NAME.
• RA_GROUPING_RULES (GRP) — resolves GROUPING_RULE_ID to GROUPING_RULE_NAME.
• ARPT_SQL_FUNC_UTIL (PACKAGE) — provides GET_LOOKUP_MEANING for translating lookup codes.
• HZ_PARTIES, AR_STANDARD_TEXT — supporting TCA/standard text references.

The view therefore consolidates TCA profile class data with Receivables-specific reference data, shielding the caller from the individual foreign-key relationships.

Key Columns

Columns expose identifying, descriptive, and configuration attributes. ROW_ID, CUSTOMER_PROFILE_CLASS_ID, PROFILE_CLASS_NAME, and PROFILE_CLASS_DESCRIPTION identify the record. Audit columns include CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Collections and credit behavior are governed by COLLECTOR_ID/COLLECTOR_NAME, CREDIT_CHECKING, TOLERANCE, and CREDIT_BALANCE_STATEMENTS. Interest processing is controlled by INTEREST_CHARGES, CHARGE_ON_FINANCE_CHARGE_FLAG, and INTEREST_PERIOD_DAYS — the last being the column most closely associated with the search term "interest_calculation_period." Statements and dunning are represented by STATEMENTS, STATEMENT_CYCLE_ID/STATEMENT_CYCLE_NAME, DUNNING_LETTERS, and DUNNING_LETTER_SET_ID/DUNNING_LETTER_SET_NAME. Payment terms appear through STANDARD_TERMS/STANDARD_TERMS_NAME, OVERRIDE_TERMS, DISCOUNT_TERMS, DISCOUNT_GRACE_DAYS, and PAYMENT_GRACE_DAYS. Consolidation billing is reflected by CONS_INV_FLAG, CONS_INV_TYPE, and CONS_BILL_LEVEL, with meanings derived via INITCAP. Tax printing uses TAX_PRINTING_OPTION and its lookup meaning, while AUTOCASH_HIERARCHY_NAME, COPY_METHOD, and AUTO_REC_INCL_DISPUTED_FLAG cover AutoCash configuration.

Common Use Cases and Queries

Typical uses include reviewing collection and credit configuration per profile class, auditing interest settings, and driving downstream reporting or integration extracts. A representative query enumerating profile classes with their interest and collection settings follows:

• SELECT CUSTOMER_PROFILE_CLASS_ID, PROFILE_CLASS_NAME, INTEREST_CHARGES, INTEREST_PERIOD_DAYS, COLLECTOR_NAME, CREDIT_CHECKING FROM AR_CUSTOMER_PROFILE_CLASSES_V;
• SELECT PROFILE_CLASS_NAME, STANDARD_TERMS_NAME, STATEMENT_CYCLE_NAME, DUNNING_LETTER_SET_NAME FROM AR_CUSTOMER_PROFILE_CLASSES_V WHERE STATUS = 'A';
• SELECT PROFILE_CLASS_NAME, TAX_PRINTING_OPTION_MEANING, CONS_INV_TYPE_MEANING, BILL_LEVEL_MEANING FROM AR_CUSTOMER_PROFILE_CLASSES_V;

Because the object is documented as Release 12.0 Only, each query should be preceded by verification of the view's existence in the specific 12.1.1 or 12.2.2 instance, with DBA_VIEWS and DBA_TAB_COLUMNS consulted to confirm availability and column inventory.