Search Results zx_srvc_typ_params_u3

Overview

The ZX.ZX_SRVC_TYP_PARAMS table is a core repository within the Oracle E-Business Suite Tax (ZX) module, specifically for Oracle EBS 12.1.1 and 12.2.2. It functions as a parameter definition table for service types, which are configurations used in the tax determination engine. The table's primary role is to define the specific parameters (or attributes) that can be associated with a given service type, controlling how tax rules are applied to different kinds of transactions. It establishes the metadata for the inputs that the tax engine expects for a particular service, enabling flexible and configurable tax logic.

Key Information Stored

The table stores metadata that links service types to their configurable parameters. The most critical columns include the SERVICE_TYPE_ID, which is a foreign key to the service type definition, and the PARAMETER_NAME, which identifies the specific parameter. The POSITION column dictates the order of parameters. The PARAM_USAGE_CODE defines how the parameter is utilized within the tax engine's logic. Crucially, the MAP_GLOBAL_VAR_CODE and MAP_GBL_VAR_DATA_TYPE columns specify the mapping between this service type parameter and a global variable used by the tax engine's procedural logic, effectively bridging configuration data to executable code. The SRVC_TYP_PARAM_ID serves as the primary key. Standard WHO columns (CREATED_BY, LAST_UPDATE_DATE, etc.) track audit information.

Common Use Cases and Queries

This table is central to diagnosing tax determination issues, validating configurations, and generating documentation for custom tax setups. A common use case involves identifying all parameters defined for a specific service type, which is essential for understanding the data requirements for a given tax calculation. Developers and functional consultants query this table to verify parameter mappings or to troubleshoot errors where a required parameter is missing or incorrectly mapped. A typical query retrieves the full parameter list for a service type:

• SELECT PARAMETER_NAME, POSITION, PARAM_USAGE_CODE, MAP_GLOBAL_VAR_CODE, MAP_GBL_VAR_DATA_TYPE FROM ZX.ZX_SRVC_TYP_PARAMS WHERE SERVICE_TYPE_ID = <id> ORDER BY POSITION;

Another critical query pattern is to find a service type by a known parameter or global variable name, useful for reverse-engineering tax setups:

• SELECT SERVICE_TYPE_ID FROM ZX.ZX_SRVC_TYP_PARAMS WHERE PARAMETER_NAME = '<Parameter_Name>' OR MAP_GLOBAL_VAR_CODE = '<Global_Variable>';

Related Objects

Based on the dependency information, the ZX.ZX_SRVC_TYP_PARAMS table is referenced by the APPS synonym ZX_SRVC_TYP_PARAMS, which is the standard access point for all application code. The table's structure implies a relationship with a parent table storing service type definitions (likely keyed by SERVICE_TYPE_ID), though this specific foreign key is not detailed in the provided metadata. The three unique indexes enforce critical business rules: ZX_SRVC_TYP_PARAMS_U1 on the primary key (SRVC_TYP_PARAM_ID), ZX_SRVC_TYP_PARAMS_U2 on SERVICE_TYPE_ID and POSITION (ensuring unique ordering per service type), and ZX_SRVC_TYP_PARAMS_U3 on SERVICE_TYPE_ID and PARAMETER_NAME (ensuring unique parameter names per service type).