Search Results JAI_CMN_CUS_ADDRESSES

Overview

The JAI_CMN_CUS_ADDRESSES table is a core data object within the Oracle E-Business Suite (EBS) Asia/Pacific Localizations module, specifically designed for implementations in India. Its primary role is to store and manage customer-specific information required for compliance with Indian excise and sales tax regimes. This table acts as a critical junction, linking standard Oracle Trading Community Architecture (TCA) customer and address entities with localization-specific attributes. It is essential for ensuring that transactional data, such as sales orders and invoices, incorporates the legally mandated tax and excise details based on the customer's location and registration status.

Key Information Stored

The table's structure centers on linking a customer site to specific localization data. Its primary key is the surrogate CUSTOMER_ADDRESS_ID. The most significant columns are the foreign keys that establish critical relationships: CUSTOMER_ID links to HZ_PARTIES to identify the customer, and ADDRESS_ID links to HZ_PARTY_SITES to identify the specific ship-to or bill-to location. Furthermore, the table references pricing lists for standard and VAT purposes via PRICE_LIST_ID and VAT_PRICE_LIST_ID, which both link to QP_LIST_HEADERS_B. While the provided metadata does not list all columns, typical data stored includes excise registration numbers (like CENVAT, Service Tax, or VAT numbers), customer classifications (e.g., Manufacturer, Trader), and flags governing the applicability of various tax and excise rules at that specific address.

Common Use Cases and Queries

This table is primarily accessed during order entry, invoice generation, and tax calculation processes within the Indian localization. A common use case is validating a customer site's excise eligibility before creating a transaction. For reporting, analysts often query this table to audit customer tax registrations. A typical SQL pattern involves joining to TCA tables to retrieve a customer's excise details for a given address:

• SELECT hzp.party_name, hzps.party_site_name, jca.* FROM jai_cmn_cus_addresses jca, hz_parties hzp, hz_party_sites hzps WHERE jca.customer_id = hzp.party_id AND jca.address_id = hzps.party_site_id AND hzp.party_number = 'CUST123';

Another critical query retrieves the assigned price list for VAT calculations for a specific customer site, which is vital for accurate pricing engine configuration.

Related Objects

JAI_CMN_CUS_ADDRESSES has integral dependencies on several foundational EBS objects. Its two core foreign keys tie it directly to the Trading Community Architecture: HZ_PARTIES (for the customer entity) and HZ_PARTY_SITES (for the address entity). The links to QP_LIST_HEADERS_B integrate it with the Advanced Pricing module to determine applicable pricing. This table is also a likely parent or reference point for numerous other localization-specific tables (e.g., JAI_CMN_INVENTORY_ITEMS, transaction tax tables) that require customer-site context for excise and sales tax determination. It is central to the data model supporting the JA_IN_* APIs and forms that manage Indian tax setup and processing.