Search Results restriction_limit_amount




Overview
Explore in AI Chat

Overview

XNC_CUST_PROFILE_CREDIT_V is a view shipped with the Oracle E-Business Suite product XNC — Sales for Communications. The product is documented as obsolete in the ETRM reference set for EBS 12.1.1 and 12.2.2, and the view itself carries the annotation "Not implemented in this database" in the reference documentation. Despite this status, the view definition remains useful as a reference artifact because it illustrates how credit profile information for customer accounts was assembled by the XNC module.

The view retrieves credit profiles for customer accounts. It joins customer profile data held in the JTF customer profile interface views with customer account attributes, payment terms, collectors, and statement cycles from the Oracle Receivables schema. Its principal role was to present a single denormalized row per customer account profile, combining credit risk classification, credit limits, tolerance and clearing rules, and both standard and override payment terms. The presence of the OVERRIDE_TERMS column is significant for users searching on that term: it exposes the alternate terms identifier that takes precedence over standard terms for a specific customer account profile, alongside the resolved name of the standard terms set.

Underlying Base Objects

The ETRM metadata documents no base objects for this view, but the embedded view text identifies the underlying sources unambiguously. The primary driving objects are the interface views JTF_CUSTOMER_PROFILES_V (aliased CUST_PROFILE) and JTF_CUST_ACCOUNTS_V (aliased CUST_ACCT), joined on CUST_ACCOUNT_ID. These interface views in turn resolve to the customer profile and customer account entities in the TCA/JTF model.

Supporting lookup tables are outer-joined to enrich the profile row. RA_TERMS provides the standard terms definition, with an active-date predicate applied through NVL on START_DATE_ACTIVE and END_DATE_ACTIVE. RA_TERMS_VL supplies the payment term name assigned at the customer account level via PAYMENT_TERM_ID. AR_COLLECTORS supplies the active collector name, constrained by C.STATUS = 'A'. AR_STATEMENT_CYCLES supplies the statement cycle name through STATEMENT_CYCLE_ID. All of these joins except the profile-to-account join are outer joins, so a profile row survives even when no active collector, statement cycle, or matching terms record exists.

Key Columns

The view exposes the row identifier and keys CUST_ACCOUNT_PROFILE_ID and CUST_ACCOUNT_ID, along with separate last-update timestamps for the account and the profile. Credit attributes include RISK_CODE, CREDIT_RATING, PROFILE_CLASS_ID, STATUS, RESTRICTION_LIMIT_AMOUNT, TOLERANCE, and CLEARING_DAYS.

Common Use Cases and Queries

Typical usage centers on credit review reporting and on determining which terms apply to a customer account. A credit analyst report might list profile class, risk code, restriction limit, and next review date, while a collections report emphasizes collector name and clearing days. Because the view surfaces OVERRIDE_TERMS directly, it was also used to reconcile standard versus override terms assignments per account.

A representative query selecting the credit profile for a specific account is:

  • SELECT cust_account_id, credit_rating, risk_code, standard_terms_name, override_terms, restriction_limit_amount, collector_name FROM xnc_cust_profile_credit_v WHERE cust_account_id = :p_account_id;
  • SELECT cust_account_id, override_terms FROM xnc_cust_profile_credit_v WHERE override_terms IS NOT NULL;
  • SELECT profile_class_id, COUNT(*) FROM xnc_cust_profile_credit_v GROUP BY profile_class_id;

Because XNC is obsolete and the view is not implemented in the documented database, these queries should be treated as reference patterns; equivalent credit profile reporting in supported releases is generally sourced from the current TCA and Receivables credit management tables.