Search Results jl_zz_ar_tx_cus_cls_all




Overview
Explore in AI Chat

Overview

JL_ZZ_AR_TX_CUS_CLS_ALL is a Latin America Localizations (JL) table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. Its documented description is "Latin Tax Customer Site Profile Information." The table stores tax-relevant configuration and classification attributes that ETRM (E-Business Tax / Latin Tax) associates with a specific customer site, keyed by the customer account site address. It effectively functions as the customer-site counterpart to supplier and item tax profiles, allowing tax determination rules to be tailored at the level of an individual receivables site rather than at the customer account header.

The physical object is owned by the JL schema and, per the ETRM 12.2.2 metadata, contains 13 columns with a primary key named JL_ZZ_AR_TX_CUS_CLS_ALL_PK on the surrogate column CUS_CLASS_ID. The table is status VALID and falls under the Latin America Localizations product family. Because the table carries descriptive profile values that are keyed to an external master (the customer site) and changes over time, the metadata's heuristic Data Vault classification is satellite-leaning: it is best modeled as a satellite attached to the customer-site hub/link, rather than as an independent hub or a pure relationship link. This classification is offered as a modeling suggestion and does not affect the underlying relational structure, which remains a standard EBS transactional-configuration table.

Key Information Stored

The most significant columns documented for this table are the following. The surrogate primary key is CUS_CLASS_ID, which uniquely identifies each customer site profile row and is enforced by JL_ZZ_AR_TX_CUS_CLS_ALL_PK. The business-key candidates, captured through the unique indexes JL_ZZ_AR_TX_CUS_CLS_U1 and JL_ZZ_AR_TX_CUS_CLS_U2, are CUS_CLASS_ID with ORG_ID, and the composite of ADDRESS_ID, TAX_ATTR_CLASS_CODE, TAX_ATTRIBUTE_NAME, TAX_CATEGORY_ID, and ORG_ID. These unique definitions confirm that a profile entry is unique per customer site address, tax attribute, and tax category within an operating unit.

ADDRESS_ID links the profile to the customer account site in HZ_CUST_ACCT_SITES_ALL (see the Foreign Keys section). TAX_ATTR_CLASS_CODE and TAX_ATTRIBUTE_NAME identify the class and name of the tax attribute being profiled, while TAX_ATTRIBUTE_VALUE stores the value assigned to that attribute for the site. TAX_CATEGORY_ID ties the attribute to the applicable tax category used during tax determination. ENABLED_FLAG controls whether the profile row is active for tax processing. ORG_ID is the multi-org operating unit discriminator, and it participates in both unique indexes. Standard EBS audit columns are also present: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY.

Common Use Cases and Queries

This table is typically queried to report or troubleshoot how tax attributes are configured for a given customer site. A common pattern joins the profile to the customer site to resolve the site's identity and to the trading-partner name for reporting:

  • Retrieving all active tax attributes for a customer address: SELECT cus_class_id, tax_attr_class_code, tax_attribute_name, tax_attribute_value FROM jl_zz_ar_tx_cus_cls_all WHERE address_id = :p_address_id AND enabled_flag = 'Y' AND org_id = :p_org_id;
  • Auditing changes to a profile row over time using LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.
  • Diagnosing tax calculation discrepancies by verifying that the expected TAX_CATEGORY_ID entries exist for the site and operating unit.
  • Bulk reporting of site profiles by operating unit, filtered on ORG_ID and ENABLED_FLAG, for configuration review or migration.
  • Verifying uniqueness assumptions during data conversion by checking the JL_ZZ_AR_TX_CUS_CLS_U1 business key.

Related Objects

The following objects are most significant in relation to this table, based on the documented foreign key and key structure:

  • HZ_CUST_ACCT_SITES_ALL — referenced via JL_ZZ_AR_TX_CUS_CLS_ALL.ADDRESS_ID, providing the customer account site to which each profile row belongs.
  • JL_ZZ_AR_TX_CUS_CLS_ALL_PK — the primary key constraint on CUS_CLASS_ID.
  • JL_ZZ_AR_TX_CUS_CLS_U1 — unique index on ADDRESS_ID, TAX_ATTR_CLASS_CODE, TAX_ATTRIBUTE_NAME, TAX_CATEGORY_ID, ORG_ID.
  • JL_ZZ_AR_TX_CUS_CLS_U2 — unique index on CUS_CLASS_ID, ORG_ID.
  • Tax category and tax attribute reference data used by TAX_CATEGORY_ID, TAX_ATTR_CLASS_CODE, and TAX_ATTRIBUTE_NAME during E-Business Tax determination.
  • Customer and trading-partner views (HZ_CUST_ACCOUNTS, HZ_PARTIES) for reporting the site owner.