Search Results ar_customer_profiles_v




Overview
Explore in AI Chat

Overview

The AR_CUSTOMER_PROFILES_V view is an APPS-owned database object in the Oracle E-Business Suite Receivables (AR) module. It exposes customer profile information used by Receivables for credit management, collections, dunning, statements, and payment terms defaulting. The view is documented in the ETRM repository with a status of VALID. Its original documentation notes that the object was defined for Release 11.5; however, the object remains referenced in the 12.2.2 metadata, where its owning schema and dependency footprint continue to be tracked.

Functionally, the view presents one row per customer account profile (and, where applicable, one row per site use), consolidating profile class attributes, credit checking parameters, collector assignment, dunning and statement configuration, and administrative columns into a single queryable structure. Its name is a legacy artifact: the view text selects from Receivables profile storage but resolves to the trading community (HZ) customer model in later releases, making it a compatibility surface for reporting and integration rather than a purely transactional entity.

Underlying Base Objects

The 12.2.2 metadata documents the following referenced base objects, all reached through APPS synonyms:

Key Columns

The view exposes identifiers (CUSTOMER_PROFILE_ID, CUSTOMER_ID, SITE_USE_ID), the owning profile class (CUSTOMER_PROFILE_CLASS_ID, PROFILE_CLASS_NAME), status, and audit columns (LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION). Credit-related columns include CREDIT_CHECKING, TOLERANCE, CREDIT_HOLD, CREDIT_RATING with its translated CREDIT_RATING_MEANING, and RISK_CODE with its translated RISK_MEANING. Collections columns include COLLECTOR_ID and COLLECTOR_NAME. Terms and dunning are represented by STANDARD_TERMS/STANDARD_TERMS_NAME, OVERRIDE_TERMS, and DUNNING_LETTER_SET_ID/DUNNING_LETTER_SET_NAME. Statement behavior is captured by SEND_STATEMENTS, CREDIT_BALANCE_STATEMENTS, and STATEMENT_CYCLE_ID/STATEMENT_CYCLE_NAME. ACCOUNT_STATUS and ACCOUNT_STATUS_MEANING reflect the profile's account status.

Common Use Cases and Queries

Reports and integrations commonly query this view to report credit exposure, review risk classification, and confirm collections or statement settings. Because the user searched for risk_code, the following query returns profile-level risk and credit data with decoded meanings:

SELECT customer_id,
       customer_profile_id,
       site_use_id,
       profile_class_name,
       risk_code,
       risk_meaning,
       credit_rating_meaning,
       credit_hold,
       account_status_meaning,
       collector_name,
       standard_terms_name
FROM   apps.ar_customer_profiles_v
WHERE  risk_code = :p_risk_code;

Additional scenarios include joining to customer and party tables to build credit review extracts, filtering by COLLECTOR_ID for collections workload reports, and auditing profiles where CREDIT_HOLD is enabled. Query authors should confirm column availability in their target release, since the object's documentation originates in Release 11.5 and it remains a compatibility view within the 12.x data model.