Search Results zx_party_tax_profile




The ZX_PARTY_TAX_PROFILE table is a critical component within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically designed to manage tax-related information for trading partners, including customers, suppliers, and legal entities. This table is part of the Oracle E-Business Tax module, which provides comprehensive tax calculation, reporting, and compliance capabilities. Below is a detailed analysis of its structure, purpose, and integration within Oracle EBS.

Overview of ZX_PARTY_TAX_PROFILE

The ZX_PARTY_TAX_PROFILE table stores tax profile information for parties (entities) involved in transactions. It acts as a central repository for tax-related attributes, such as tax registration numbers, tax classifications, and jurisdictional details. This table is essential for determining the correct tax treatment during transactions, ensuring compliance with regional and global tax regulations.

Key Columns and Their Significance

The table consists of several important columns, each serving a specific purpose:
  • PARTY_TAX_PROFILE_ID: A unique identifier for each tax profile record.
  • PARTY_ID: References the party (customer, supplier, or legal entity) in the HZ_PARTIES table.
  • PARTY_TYPE_CODE: Specifies the type of party (e.g., 'CUSTOMER', 'SUPPLIER', 'LEGAL_ENTITY').
  • ROUNDING_LEVEL_CODE: Defines the level at which tax amounts are rounded (e.g., 'LINE', 'INVOICE').
  • ROUNDING_RULE_CODE: Determines the rounding rule (e.g., 'NEAREST', 'UP', 'DOWN').
  • TAX_CLASSIFICATION_CODE: Stores the tax classification code assigned to the party, which influences tax calculations.
  • SELF_ASSESSMENT_FLAG: Indicates whether the party is responsible for self-assessing taxes.
  • TAX_REGISTRATION_NUMBER: Stores the party's tax registration number (e.g., VAT/GST number).
  • START_DATE and END_DATE: Define the validity period of the tax profile.

Integration with Other Modules

The ZX_PARTY_TAX_PROFILE table integrates with several Oracle EBS modules, including:
  • Accounts Receivable (AR): Used to determine tax applicability for customer invoices.
  • Accounts Payable (AP): Helps in calculating taxes on supplier invoices.
  • Order Management (OM): Ensures accurate tax calculations for sales orders.
  • General Ledger (GL): Supports tax reporting and reconciliation.

Functional Importance

The table plays a pivotal role in:
  • Tax Determination: Provides the necessary attributes to determine the correct tax rate and rules for transactions.
  • Compliance: Ensures adherence to tax regulations by maintaining accurate party tax details.
  • Reporting: Facilitates the generation of tax reports for auditing and statutory requirements.

Customization and Extensions

Organizations can extend the functionality of the ZX_PARTY_TAX_PROFILE table by:
  • Adding custom columns to capture additional tax attributes.
  • Creating triggers or workflows to automate tax profile updates.
  • Integrating with third-party tax engines for enhanced compliance.

Conclusion

The ZX_PARTY_TAX_PROFILE table is a foundational element in Oracle EBS for managing tax-related data. Its well-defined structure and integration with core modules ensure accurate tax calculations, compliance, and reporting. Proper configuration and maintenance of this table are essential for organizations to meet their tax obligations efficiently.

  • Table: ZX_PARTY_TAX_PROFILE 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE , 

  • Table: ZX_PARTY_TAX_PROFILE 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE , 

  • Table: ZX_LINES_DET_FACTORS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_DET_FACTORS,  object_name:ZX_LINES_DET_FACTORS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. ,  implementation_dba_data: ZX.ZX_LINES_DET_FACTORS , 

  • Table: ZX_LINES_DET_FACTORS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_DET_FACTORS,  object_name:ZX_LINES_DET_FACTORS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. ,  implementation_dba_data: ZX.ZX_LINES_DET_FACTORS , 

  • Table: ZX_REGISTRATIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGISTRATIONS,  object_name:ZX_REGISTRATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax registrations. ,  implementation_dba_data: ZX.ZX_REGISTRATIONS , 

  • Table: ZX_REGISTRATIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGISTRATIONS,  object_name:ZX_REGISTRATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax registrations. ,  implementation_dba_data: ZX.ZX_REGISTRATIONS , 

  • Table: ZX_TAXES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_B,  object_name:ZX_TAXES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. ,  implementation_dba_data: ZX.ZX_TAXES_B , 

  • Table: ZX_LINES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES , 

  • Table: ZX_TAXES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_B,  object_name:ZX_TAXES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. ,  implementation_dba_data: ZX.ZX_TAXES_B , 

  • Table: ZX_LINES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES , 

  • Table: ZX_SUBSCRIPTION_DETAILS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SUBSCRIPTION_DETAILS,  object_name:ZX_SUBSCRIPTION_DETAILS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the detailed interpretations for each enabled content subscription option defined in ZX_SUBSCRIPTION_OPTIONS table. ,  implementation_dba_data: ZX.ZX_SUBSCRIPTION_DETAILS , 

  • Table: ZX_SUBSCRIPTION_DETAILS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SUBSCRIPTION_DETAILS,  object_name:ZX_SUBSCRIPTION_DETAILS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the detailed interpretations for each enabled content subscription option defined in ZX_SUBSCRIPTION_OPTIONS table. ,  implementation_dba_data: ZX.ZX_SUBSCRIPTION_DETAILS , 

  • Table: ZX_LINES_SUMMARY 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_SUMMARY,  object_name:ZX_LINES_SUMMARY,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the summarized tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES_SUMMARY , 

  • Table: ZX_LINES_SUMMARY 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_SUMMARY,  object_name:ZX_LINES_SUMMARY,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the summarized tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES_SUMMARY , 

  • Table: ZX_REGIMES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Table: ZX_REGIMES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Lookup Type: ZX_REPORTING_TABLE_USE 12.1.1

    product: ZX - E-Business Tax ,  meaning: Reporting Types Table uses , 

  • Table: ZX_REGIMES_USAGES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_USAGES,  object_name:ZX_REGIMES_USAGES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of regimes for each first party organization, where the transactions of that first party organization can have tax implications. ,  implementation_dba_data: ZX.ZX_REGIMES_USAGES , 

  • Table: ZX_STATUS_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_STATUS_B,  object_name:ZX_STATUS_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner. ,  implementation_dba_data: ZX.ZX_STATUS_B , 

  • Table: ZX_TRX_LINE_APP_REGIMES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TRX_LINE_APP_REGIMES,  object_name:ZX_TRX_LINE_APP_REGIMES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the applicable regimes for transactions. Each row stores one applicable regime for a specific transaction line. ,  implementation_dba_data: ZX.ZX_TRX_LINE_APP_REGIMES , 

  • Lookup Type: ZX_REPORTING_TABLE_USE 12.2.2

    product: ZX - E-Business Tax ,  meaning: Reporting Types Table uses , 

  • Table: ZX_SRVC_SUBSCRIPTIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SRVC_SUBSCRIPTIONS,  object_name:ZX_SRVC_SUBSCRIPTIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of service subscriptions for each regime of a first party organization defined in ZX_REGIMES_USAGE table. ,  implementation_dba_data: ZX.ZX_SRVC_SUBSCRIPTIONS , 

  • Table: ZX_REGIMES_USAGES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_USAGES,  object_name:ZX_REGIMES_USAGES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of regimes for each first party organization, where the transactions of that first party organization can have tax implications. ,  implementation_dba_data: ZX.ZX_REGIMES_USAGES , 

  • Table: ZX_CONTENT_SOURCES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_CONTENT_SOURCES,  object_name:ZX_CONTENT_SOURCES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores multiple sources from which tax configuration content can be loaded. Each row stores details about a content source for a specific regime. ,  implementation_dba_data: ZX.ZX_CONTENT_SOURCES , 

  • Table: ZX_SRVC_SUBSCRIPTIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SRVC_SUBSCRIPTIONS,  object_name:ZX_SRVC_SUBSCRIPTIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of service subscriptions for each regime of a first party organization defined in ZX_REGIMES_USAGE table. ,  implementation_dba_data: ZX.ZX_SRVC_SUBSCRIPTIONS , 

  • Table: ZX_TRX_LINE_APP_REGIMES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TRX_LINE_APP_REGIMES,  object_name:ZX_TRX_LINE_APP_REGIMES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the applicable regimes for transactions. Each row stores one applicable regime for a specific transaction line. ,  implementation_dba_data: ZX.ZX_TRX_LINE_APP_REGIMES , 

  • Table: ZX_SUBSCRIPTION_OPTIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SUBSCRIPTION_OPTIONS,  object_name:ZX_SUBSCRIPTION_OPTIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of date effective content subscription options for each regime of a first party organization defined in ZX_REGIMES_USAGES table. ,  implementation_dba_data: ZX.ZX_SUBSCRIPTION_OPTIONS , 

  • Table: ZX_SUBSCRIPTION_OPTIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SUBSCRIPTION_OPTIONS,  object_name:ZX_SUBSCRIPTION_OPTIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of date effective content subscription options for each regime of a first party organization defined in ZX_REGIMES_USAGES table. ,  implementation_dba_data: ZX.ZX_SUBSCRIPTION_OPTIONS , 

  • Table: ZX_CONTENT_SOURCES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_CONTENT_SOURCES,  object_name:ZX_CONTENT_SOURCES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores multiple sources from which tax configuration content can be loaded. Each row stores details about a content source for a specific regime. ,  implementation_dba_data: ZX.ZX_CONTENT_SOURCES , 

  • Table: ZX_STATUS_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_STATUS_B,  object_name:ZX_STATUS_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner. ,  implementation_dba_data: ZX.ZX_STATUS_B , 

  • Table: ZX_API_REGISTRATIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_API_REGISTRATIONS,  object_name:ZX_API_REGISTRATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the registration of a set of APIs required to support third party tax service providers. Each record represents registration of one API for a third party service provider or a first party organization. ,  implementation_dba_data: ZX.ZX_API_REGISTRATIONS , 

  • Table: ZX_API_REGISTRATIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_API_REGISTRATIONS,  object_name:ZX_API_REGISTRATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the registration of a set of APIs required to support third party tax service providers. Each record represents registration of one API for a third party service provider or a first party organization. ,  implementation_dba_data: ZX.ZX_API_REGISTRATIONS , 

  • Table: ZX_RULES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RULES_B,  object_name:ZX_RULES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. ,  implementation_dba_data: ZX.ZX_RULES_B , 

  • Table: ZX_RULES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RULES_B,  object_name:ZX_RULES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. ,  implementation_dba_data: ZX.ZX_RULES_B , 

  • Table: ZX_PROCESS_RESULTS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PROCESS_RESULTS,  object_name:ZX_PROCESS_RESULTS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. ,  implementation_dba_data: ZX.ZX_PROCESS_RESULTS , 

  • Table: ZX_REC_NREC_DIST 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_REC_NREC_DIST 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_PROCESS_RESULTS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PROCESS_RESULTS,  object_name:ZX_PROCESS_RESULTS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. ,  implementation_dba_data: ZX.ZX_PROCESS_RESULTS ,