Search Results zx_subscription_details




Overview
Explore in AI Chat

Overview

The ZX_SUBSCRIPTION_DETAILS table is a core repository within the Oracle E-Business Tax (ZX) module for Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as the detailed configuration table for tax content subscriptions. Its primary role is to store the specific interpretations and granular application rules for each enabled subscription option. These options, defined at a higher level in the ZX_SUBSCRIPTION_OPTIONS table, are made operational through the detailed records in this table. It is a critical component for managing and applying third-party or custom tax content, enabling precise control over tax determination logic based on legal entity, tax regime, and organizational hierarchy.

Key Information Stored

The table's structure is designed to link subscription options to specific entities and tax regimes, defining the scope of their application. The primary key, SUBSCRIPTION_DETAIL_ID, uniquely identifies each detailed interpretation. Key foreign key columns establish critical relationships: SUBSCRIPTION_OPTION_ID links to the parent option in ZX_SUBSCRIPTION_OPTIONS; FIRST_PTY_ORG_ID references the primary legal entity (party tax profile) to which the detail applies; TAX_REGIME_CODE ties the subscription to a specific tax regime; and PARENT_FIRST_PTY_ORG_ID allows for hierarchical configuration by referencing a parent legal entity. This combination of keys ensures that subscription logic is correctly scoped and applied during the tax calculation process.

Common Use Cases and Queries

This table is primarily accessed for configuration analysis, troubleshooting, and audit reporting related to tax content subscriptions. A common use case involves verifying all active subscription details for a specific legal entity to understand its tax content footprint. A typical diagnostic query would join to ZX_SUBSCRIPTION_OPTIONS to get the option name and to ZX_REGIMES_B for the regime description.

SELECT zsd.SUBSCRIPTION_DETAIL_ID, zso.OPTION_NAME, zsd.TAX_REGIME_CODE, zsd.FIRST_PTY_ORG_ID
FROM ZX_SUBSCRIPTION_DETAILS zsd,
     ZX_SUBSCRIPTION_OPTIONS zso
WHERE zsd.SUBSCRIPTION_OPTION_ID = zso.SUBSCRIPTION_OPTION_ID
AND zsd.FIRST_PTY_ORG_ID = :p_legal_entity_id;

Another critical scenario is identifying the source of a specific tax rule applied during a transaction, which may require tracing back through subscription details. Reporting on subscription coverage across the enterprise is also a key administrative function enabled by this table.

Related Objects

The ZX_SUBSCRIPTION_DETAILS table is centrally connected to other fundamental E-Business Tax tables through documented foreign key relationships. It is a child table of ZX_SUBSCRIPTION_OPTIONS, referencing it via the SUBSCRIPTION_OPTION_ID column. It establishes two distinct relationships with the ZX_PARTY_TAX_PROFILE table: one for the applying legal entity (FIRST_PTY_ORG_ID) and one for a potential parent entity (PARENT_FIRST_PTY_ORG_ID). Furthermore, it references the ZX_REGIMES_B table via the TAX_REGIME_CODE column to define the applicable tax jurisdiction. These relationships are essential for the integrated functioning of the subscription model within the E-Business Tax engine.

  • 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_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_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_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_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 , 

  • 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 ,