Search Results cust_acct




Overview
Explore in AI Chat

Overview

AR_TA_ESS_CREDIT_V is a Receivables module view in Oracle E-Business Suite 12.1.1 and 12.2.2 that consolidates customer credit information for use by the Territory Assignment (TA) engine and ESS-based credit processing. The view exposes organization, set of books, customer account, credit hold, and overall credit limit data in a single denormalized result set. In the ETRM documentation for 12.2.2 the object is listed without a documented owner and with no referenced base objects recorded, and the implementation notes state that it is not implemented in the reference database. Its role is therefore primarily definitional: it describes the shape of credit data expected by Receivables credit-checking and territory assignment logic rather than a physical table that DBAs tune directly.

Underlying Base Objects

Although no base objects are documented in the ETRM metadata, the view text reveals its construction. It is a UNION of two queries built over five tables:

The first branch of the UNION returns customers that have a matching profile amount row in the set of books currency. The second branch returns customers that exist at the account level but have no matching profile amount, using the SITE_USE_ID in place of a calculated limit and excluding combinations already returned by the first branch.

Key Columns

  • ORG_ID — the operating unit identifier sourced from AR_SYSTEM_PARAMETERS_ALL, used for multi-org filtering.
  • SET_OF_BOOKS_ID — the ledger/set of books associated with the operating unit.
  • ACCOUNT_NUMBER / CUSTOMER_NUMBER — the customer account number from HZ_CUST_ACCOUNTS, matching the user search term "cust_acct".
  • CREDIT_HOLD — the credit hold flag from HZ_CUSTOMER_PROFILES, indicating whether the account is on credit hold.
  • OVERALL_CREDIT_LIMIT (CL) — derived via DECODE: where a profile amount exists it is divided by 1000; where it is NULL, CP.SITE_USE_ID is substituted.

Common Use Cases and Queries

The view is typically queried for credit exposure reporting and for validating the credit data consumed by Territory Assignment and ESS credit jobs. A representative query retrieves credit status for a single customer account:

  • SELECT account_number, credit_hold, overall_credit_limit FROM ar_ta_ess_credit_v WHERE account_number = :cust_acct;
  • SELECT org_id, set_of_books_id, account_number, credit_hold FROM ar_ta_ess_credit_v WHERE credit_hold = 'Y';

Because the definition is not implemented in the base database, references to AR_TA_ESS_CREDIT_V should be treated as documentation of the expected credit data interface rather than a guaranteed runtime object. In 12.1.1 and 12.2.2 environments where it is absent, equivalent logic must be reproduced from the underlying HZ and AR tables shown in the view text.