Search Results jai_cmn_mtax_hdrs_all
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.
- Referenced By (Child Table):
- JAI_CMN_MTAX_UPD_DTLS: Links via BATCH_ID. This detail table stores the individual transaction lines updated by the mass tax request.
- References (Parent Tables):
- HR_ALL_ORGANIZATION_UNITS: Via ORG_ID.
- FND_CONCURRENT_REQUESTS: Via REQUEST_ID.
- HZ_PARTIES: Via SUPPLIER_ID and CUSTOMER_ID.
- HZ_PARTY_SITES: Via SUPPLIER_SITE_ID and CUSTOMER_SITE_ID.
- JAI_CMN_TAX_CTGS_ALL: Via OLD_TAX_CATEGORY and NEW_TAX_CATEGORY.
- FND_CONCURRENT_PROGRAMS: Via PROGRAM_APPLICATION_ID and PROGRAM_ID.
- FND_LOGINS: Via PROGRAM_LOGIN_ID.
-
Table: JAI_CMN_MTAX_HDRS_ALL
12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_MTAX_HDRS_ALL, object_name:JAI_CMN_MTAX_HDRS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores Mass Tax Changes requests with all inputs submitted , implementation_dba_data: JA.JAI_CMN_MTAX_HDRS_ALL ,
-
Table: JAI_CMN_MTAX_HDRS_ALL
12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_MTAX_HDRS_ALL, object_name:JAI_CMN_MTAX_HDRS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores Mass Tax Changes requests with all inputs submitted , implementation_dba_data: JA.JAI_CMN_MTAX_HDRS_ALL ,
-
Table: JAI_CMN_TAX_CTGS_ALL
12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_TAX_CTGS_ALL, object_name:JAI_CMN_TAX_CTGS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores tax categories and their link to excise ITEM classes. , implementation_dba_data: JA.JAI_CMN_TAX_CTGS_ALL ,
-
Table: JAI_CMN_TAX_CTGS_ALL
12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_TAX_CTGS_ALL, object_name:JAI_CMN_TAX_CTGS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores tax categories and their link to excise ITEM classes. , implementation_dba_data: JA.JAI_CMN_TAX_CTGS_ALL ,
-
Table: JAI_CMN_MTAX_UPD_DTLS
12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_MTAX_UPD_DTLS, object_name:JAI_CMN_MTAX_UPD_DTLS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the lines processed by Mass Tax Changes with details along with errors , implementation_dba_data: JA.JAI_CMN_MTAX_UPD_DTLS ,
-
Table: JAI_CMN_MTAX_UPD_DTLS
12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_MTAX_UPD_DTLS, object_name:JAI_CMN_MTAX_UPD_DTLS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the lines processed by Mass Tax Changes with details along with errors , implementation_dba_data: JA.JAI_CMN_MTAX_UPD_DTLS ,