Search Results dun_set

Overview

APPS.AR_CUSTOMER_PROFILES_V is a reporting and integration view in the Oracle E-Business Suite Receivables (AR) module. It presents customer profile information by denormalizing the underlying customer profile records stored in the Oracle Trading Community Architecture (TCA) tables and enriching them with descriptive names resolved from Receivables reference entities. The view combines customer profile attributes, such as credit checking, dunning, statements, interest charges, and collections assignments, with human-readable lookup meanings and related entity names to provide a comprehensive, query-friendly representation of customer profile configuration.

The view resides in the APPS schema and is available in both EBS 12.1.1 and 12.2.2. It is commonly consumed by reports, concurrent programs, and integrations that require customer profile settings without having to join multiple TCA and AR tables directly. Because it exposes translated or resolved values such as lookup meanings, collector names, dunning letter set names, statement cycle names, and terms names, it is particularly useful in reporting contexts where code values alone would be insufficient.

Underlying Base Objects

The view is defined over the customer profile entity and a set of synonymous references to related master and reference entities. The primary driving object is HZ_CUSTOMER_PROFILES (referenced through a synonym), which supplies the core profile columns such as CUST_ACCOUNT_PROFILE_ID, CUST_ACCOUNT_ID, SITE_USE_ID, PROFILE_CLASS_ID, STATUS, and the various profile flags and identifiers. The profile class description is resolved from HZ_CUST_PROFILE_CLASSES, while HZ_CUST_SITE_USES and HZ_PARTIES provide supporting context for site use and party associations.

Several reference lookups and master entities are joined to enrich the profile. AR_COLLECTORS supplies the collector name, AR_DUNNING_LETTER_SETS supplies the dunning letter set name, AR_STATEMENT_CYCLES supplies the statement cycle name, RA_TERMS supplies the standard terms name, and AR_AUTOCASH_HIERARCHIES supplies the AutoCash hierarchy name. RA_GROUPING_RULES is also referenced. The package ARPT_SQL_FUNC_UTIL is invoked to translate coded values into lookup meanings for attributes such as CREDIT_RATING, RISK_CODE, ACCOUNT_STATUS, and TAX_PRINTING_OPTION. All underlying tables are accessed through synonyms owned by APPS.

Key Columns

• CUSTOMER_PROFILE_ID, CUSTOMER_ID, SITE_USE_ID, CUSTOMER_PROFILE_CLASS_ID — Identifiers linking the profile to its customer account, site use, and profile class.
• PROFILE_CLASS_NAME, PROFILE_CLASS_DESCRIPTION — Descriptive attributes of the assigned profile class.
• COLLECTOR_ID, COLLECTOR_NAME — The assigned collections agent and their resolved name.
• CREDIT_CHECKING, TOLERANCE, CREDIT_HOLD, CREDIT_RATING, CREDIT_RATING_MEANING, RISK_CODE, RISK_MEANING — Credit management settings and their lookup meanings.
• DISCOUNT_TERMS, STANDARD_TERMS, STANDARD_TERMS_NAME, OVERRIDE_TERMS — Payment terms configuration and the resolved standard terms name.
• DUNNING_LETTERS, DUNNING_LETTER_SET_ID, DUNNING_LETTER_SET_NAME — Dunning configuration, where DUNNING_LETTER_SET_NAME corresponds to the "dun_set" attribute frequently sought by users querying this view.
• INTEREST_CHARGES, INTEREST_PERIOD_DAYS, PAYMENT_GRACE_DAYS, DISCOUNT_GRACE_DAYS — Interest and grace period settings.
• SEND_STATEMENTS (STATEMENTS), CREDIT_BALANCE_STATEMENTS, STATEMENT_CYCLE_ID, STATEMENT_CYCLE_NAME — Statement generation settings and the resolved cycle name.
• ACCOUNT_STATUS, ACCOUNT_STATUS_MEANING — Account status code and its lookup meaning.
• AUTOCASH_HIERARCHY_ID, AUTOCASH_HIERARCHY_NAME, AUTO_REC_INCL_DISPUTED_FLAG — AutoCash and automatic receipt application settings.
• TAX_PRINTING_OPTION, TAX_PRINTING_OPTION_MEANING — Tax printing configuration and its lookup meaning.
• Standard WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION.

Common Use Cases and Queries

The view is typically used to report on customer profile configuration, validate collections and dunning setup, and drive integrations that require resolved profile attributes. A frequent scenario involves retrieving the dunning letter set assigned to customer profiles, which the user searching for "dun_set" is likely pursuing.

To list profiles alongside their dunning letter set names:

• SELECT CUSTOMER_ID, CUSTOMER_PROFILE_ID, DUNNING_LETTERS, DUNNING_LETTER_SET_ID, DUNNING_LETTER_SET_NAME FROM APPS.AR_CUSTOMER_PROFILES_V;

To filter by a specific dunning letter set or collector:

• SELECT CUSTOMER_ID, COLLECTOR_NAME, DUNNING_LETTER_SET_NAME FROM APPS.AR_CUSTOMER_PROFILES_V WHERE DUNNING_LETTER_SET_NAME IS NOT NULL;

To report credit and statements configuration with resolved meanings:

• SELECT CUSTOMER_ID, CREDIT_RATING_MEANING, RISK_MEANING, ACCOUNT_STATUS_MEANING, STATEMENT_CYCLE_NAME FROM APPS.AR_CUSTOMER_PROFILES_V WHERE CREDIT_HOLD = 'Y';

Because the view joins several master entities, queries should include selective predicates on CUSTOMER_ID, SITE_USE_ID, or profile class to limit result sets and improve performance in high-volume environments.