Search Results jai_cmn_mtax_hdrs_all




Overview
Explore in AI Chat

Overview

The JAI_CMN_MTAX_HDRS_ALL table is a core data object within the JA (Asia/Pacific Localizations) product of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the primary header repository for Mass Tax Changes requests. This table is integral to localization-specific functionality, enabling the bulk update of tax-related information across transactional data. It stores the complete set of input parameters and control information submitted when a user initiates a mass tax update process, providing an audit trail and defining the scope for the detailed changes executed by the associated concurrent program.

Key Information Stored

The table's primary key is the BATCH_ID, which uniquely identifies each mass tax change request. Key columns define the scope and parameters of the update. These include ORG_ID for the operating unit, and identifiers for the specific entities targeted by the change: SUPPLIER_ID, SUPPLIER_SITE_ID, CUSTOMER_ID, and CUSTOMER_SITE_ID. The core tax change is defined by OLD_TAX_CATEGORY and NEW_TAX_CATEGORY, which reference valid tax categories. The table also tracks the execution context via REQUEST_ID (linking to the concurrent request), and PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_LOGIN_ID for programmatic invocation details. Additional columns typically store status flags, creation dates, and the user who submitted the request.

Common Use Cases and Queries

The primary use case is auditing and reviewing historical mass tax updates. Administrators can query this table to understand what changes were requested, their scope, and when they were run. Common reporting queries involve joining to referenced tables for meaningful descriptions.

  • Tracking Request Status: SELECT h.batch_id, h.request_id, r.request_date, r.phase_code, r.status_code FROM jai_cmn_mtax_hdrs_all h, fnd_concurrent_requests r WHERE h.request_id = r.request_id;
  • Reviewing Change Parameters: SELECT h.batch_id, ou.name org, hz1.party_name old_category, hz2.party_name new_category FROM jai_cmn_mtax_hdrs_all h, hr_all_organization_units ou, jai_cmn_tax_ctgs_all hz1, jai_cmn_tax_ctgs_all hz2 WHERE h.org_id = ou.organization_id AND h.old_tax_category = hz1.tax_category_id AND h.new_tax_category = hz2.tax_category_id;
  • Identifying Updates for a Specific Supplier: SELECT * FROM jai_cmn_mtax_hdrs_all WHERE supplier_id = <party_id>;

Related Objects

JAI_CMN_MTAX_HDRS_ALL has extensive foreign key relationships, highlighting its central role in the mass tax process.