Results for “ar_lc_cust_sites_u1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_LC_CUST_SITES_T is a transactional configuration table in the Oracle E-Business Suite Receivables (AR) schema. It stores the set of customers and customer Bill-To sites that are eligible for late charge processing, together with the calculation parameters that the Late Charges program applies when generating interest invoices, debit memos, or penalty documents against overdue transactions. In the 12.1.1 and 12.2.2 data models it is owned by AR, resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and carries FND Design Data reference AR.AR_LC_CUST_SITES_T. The object is documented with a VALID status and 47 columns in the 12.2.2 physical schema.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as standalone. That heuristic suggests it is best treated as a reference or configuration satellite keyed by its own surrogate identifier rather than as a traditional hub or link, since its foreign keys (collector, customer account profile amount, interest schedule) reference descriptive or reference entities rather than forming a resolvable business-key composite.

Key Information Stored

The surrogate primary key is LC_CUST_SITES_ID, defined by the primary key constraint AR_LC_CUST_SITES_PK and enforced through the unique index AR_LC_CUST_SITES_U1 (NORMAL, UNIQUE, APPS_TS_TX_IDX). The business context is carried by CUSTOMER_ID and CUSTOMER_SITE_USE_ID, the latter identifying the Bill-To site use to which the late charge rule applies; CURRENCY_CODE scopes the rule to a specific currency.

• CUSTOMER_PROFILE_ID / COLLECTOR_ID — links the configuration to a customer profile and to the collector responsible for the account.
• LATE_CHARGE_CALCULATION_TRX — the eligibility criteria by which transactions are selected for late charge processing.
• CREDIT_ITEMS_FLAG / DISPUTED_TRANSACTIONS_FLAG — boolean-style flags controlling whether credit items and disputed transactions participate in the calculation.
• PAYMENT_GRACE_DAYS — the maximum number of overdue days tolerated before charges are applied.
• LATE_CHARGE_TYPE / LATE_CHARGE_TERM_ID — the document the program creates (interest invoice, debit memo) and the payment term used to build it.
• INTEREST_CALCULATION_PERIOD, INTEREST_PERIOD_DAYS, INTEREST_RATE, INTEREST_TYPE, CHARGE_ON_FINANCE_CHARGE_FLAG — define whether interest is calculated daily or monthly and whether simple, compound, or flat formulas apply.
• MIN_INTEREST_CHARGE / MAX_INTEREST_CHARGE — bounds applied to the calculated charge.
• HOLD_CHARGED_INVOICES_FLAG, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, ORG_ID, REQUEST_ID — operational controls, currency conversion, multi-org security, and the concurrent request that last populated the row.

A secondary nonunique index AR_LC_CUST_SITES_N1 covers REQUEST_ID and CUSTOMER_SITE_USE_ID, supporting concurrent-program lookups and site-level queries.

Common Use Cases and Queries

Typical scenarios include verifying which customers are enrolled in late charges, auditing the parameters driving an interest run, and reconciling the concurrent request that generated or refreshed configuration rows.

• Retrieve all active site-level configurations for a given customer: SELECT lc_cust_sites_id, customer_site_use_id, currency_code, late_charge_type FROM ar.ar_lc_cust_sites_t WHERE customer_id = :p_customer_id;
• Identify rows produced by a specific Late Charges concurrent request using the N1 index: SELECT * FROM ar.ar_lc_cust_sites_t WHERE request_id = :p_request_id;
• Report on grace periods and calculation methods for interest exception analysis: SELECT customer_site_use_id, payment_grace_days, interest_calculation_period, interest_type FROM ar.ar_lc_cust_sites_t;
• Join to AR_COLLECTORS to review collector assignment for late-charge-eligible sites.

Related Objects

The documented foreign keys and primary key definition establish the principal relationships for this table:

• AR.AR_LC_CUST_SITES_T.COLLECTOR_ID → AR.AR_COLLECTORS — resolves the collector assigned to the site configuration.
• AR.AR_LC_CUST_SITES_T.CUST_ACCT_PROFILE_AMT_ID → HZ.HZ_CUST_PROFILE_AMTS — ties the rule to a customer account profile amount definition.
• AR.AR_LC_CUST_SITES_T.INTEREST_SCHEDULE_ID → CE.CE_INTEREST_SCHEDULES — links to the interest schedule used for rate derivation.
• AR_LC_CUST_SITES_U1 and AR_LC_CUST_SITES_N1 — the unique and nonunique indexes that enforce and support access paths.
• The Late Charges concurrent program and related AR interest processing logic, which consume these rows during charge generation.