Search Results zx_srvc_typ_params




Overview
Explore in AI Chat

Overview

The ZX_SRVC_TYP_PARAMS table is a core data repository within the ZX (E-Business Tax) module of Oracle E-Business Suite releases 12.1.1 and 12.2.2. It functions as a parameter store for service types, which are configurations within the E-Business Tax engine that define how tax is calculated for specific kinds of services or transactions. The table's primary role is to provide a flexible, key-value pair mechanism to attach additional, configurable attributes to a service type definition. This extensibility is crucial for supporting complex, jurisdiction-specific tax rules that require more granular control beyond the base service type setup.

Key Information Stored

The table stores parameter definitions linked to specific service types. Its structure is defined by a composite primary key, ensuring unique parameter names per service type. The critical columns include:

  • SERVICE_TYPE_ID: A foreign key column that uniquely identifies the parent service type definition in the ZX_SERVICE_TYPES table. This establishes the core relationship.
  • PARAMETER_NAME: The name or key of the configurable parameter associated with the service type. Together with SERVICE_TYPE_ID, this forms the table's primary key.
  • While the provided metadata does not list all columns, typical parameter tables in this context would also include a PARAMETER_VALUE column to store the setting for the named parameter and potentially columns for data type, enabled flags, and creation/modification audit information.

Common Use Cases and Queries

This table is primarily accessed for tax rule configuration and diagnostic reporting. A common use case involves reviewing or updating the specific parameters that influence tax calculation for a particular service. For instance, an implementation team might query all parameters for a service type related to digital goods to verify correct setup for a new tax regime. A typical diagnostic query would join to the parent service types table:

SELECT s.service_type_code, p.parameter_name, p.parameter_value
FROM zx_srvc_typ_params p, zx_service_types s
WHERE p.service_type_id = s.service_type_id
AND s.service_type_code = 'DIGITAL_SERVICES'
ORDER BY p.parameter_name;

Data in this table is typically maintained through the E-Business Tax Manager or related setup forms, not via direct SQL manipulation. Reporting use cases often involve joining this table through ZX_SERVICE_TYPES to transaction lines or tax determination results to analyze how specific parameters affected a final tax calculation.

Related Objects

The ZX_SRVC_TYP_PARAMS table has a direct, documented foreign key relationship with the ZX_SERVICE_TYPES table, which is its primary parent object.

  • ZX_SERVICE_TYPES: This table contains the master definition of service types. The relationship is defined as ZX_SRVC_TYP_PARAMS.SERVICE_TYPE_ID → ZX_SERVICE_TYPES (SERVICE_TYPE_ID). All parameters stored in ZX_SRVC_TYP_PARAMS must reference a valid, existing record in this parent table.
  • While not explicitly listed in the provided metadata, ZX_SRVC_TYP_PARAMS is a foundational table that is likely referenced by various E-Business Tax engine programs, tax determination APIs, and potentially by summary or reporting views within the ZX schema that expose service type configurations.