Search Results subscription_detail_id

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.