Search Results cust_profile




Overview
Explore in AI Chat

Overview

APPS.CSC_CUST_PROFILE_CREDIT_V is a reporting view in the Oracle E-Business Suite Receivables and Credit Management schema. It consolidates customer credit profile and credit account attributes into a single denormalized row per customer profile record, joining the profile, the associated customer account, standard payment terms, and the assigned collector. The view is owned by the APPS schema and is exposed for inquiry, reporting, and integration consumers that require credit-related customer information without navigating the underlying normalized tables directly. Because it draws simultaneously from credit profile tables and trading community (HZ) customer account tables, it is particularly useful for read-only credit analysis, collections reporting, and downstream extract processes.

Underlying Base Objects

The view is defined over a mix of synonyms and one view, reflecting both the Credit Management and Trading Community architectures present in Release 12:

  • HZ_CUSTOMER_PROFILES (synonym) — the primary driver table, aliased as cust_profile; supplies credit rating, status, limits, and DFF attributes.
  • HZ_CUST_ACCOUNTS (synonym) — aliased as cust_acct; joined on cust_account_id and supplies write-off amounts and payment terms.
  • AR_COLLECTORS (synonym) — aliased as c; joined on collector_id with the filter c.status = 'A', restricting results to active collectors.
  • RA_TERMS (synonym) — aliased as std_terms; an outer join on standard_terms, additionally date-bounded by start_date_active/end_date_active.
  • RA_TERMS_VL (view) — aliased as pay_terms; an outer join on the customer account's payment_term_id.

The outer joins on both term sources ensure that profiles are returned even when term definitions are absent or inactive.

Key Columns

  • cust_profile.rowid — row identifier of the underlying profile record.
  • cust_account_profile_id / cust_account_id — keys linking the profile to its customer account.
  • risk_code, profile_class_id, credit_rating — credit risk and classification indicators.
  • restriction_limit_amount, tolerance, clearing_days — credit limit and clearing parameters.
  • standard_terms, std_terms.name, payment_term_id, pay_terms.name — standard and account-level payment terms with descriptions.
  • override_terms, discount_terms, interest_charges, credit_checking — decoded Y/N flags returning 'Yes'/'No'.
  • next_credit_review_date, interest_period_days, payment_grace_days, discount_grace_days — review and grace period attributes.
  • collector_id, c.name, credit_analyst_id — assigned collector and credit analyst.
  • write_off_payment_amount, write_off_amount, deposit_refund_method, credit_classification_code — sourced from the customer account.
  • credit_hold, site_use_id — hold status and site usage context.
  • attribute1–attribute15, attribute_category — descriptive flexfield segments.
  • Audit columns — creation/last-update date, user, and login fields.

Common Use Cases and Queries

The view supports credit exposure reporting, collector workload analysis, and credit review scheduling. A typical query listing active profiles with limits and collectors:

  • SELECT cust_account_id, credit_rating, restriction_limit_amount, tolerance, std_terms.name, c_name FROM APPS.CSC_CUST_PROFILE_CREDIT_V WHERE credit_hold = 'Y';
  • SELECT collector_id, c.name, COUNT(*) FROM APPS.CSC_CUST_PROFILE_CREDIT_V WHERE status = 'A' GROUP BY collector_id, c.name; — collector workload.
  • SELECT cust_account_id, next_credit_review_date FROM APPS.CSC_CUST_PROFILE_CREDIT_V WHERE next_credit_review_date <= SYSDATE; — overdue credit reviews.

Because the view applies activity and date filters internally, consumers should expect only profiles linked to an active collector and, for standard terms, only currently effective term definitions.