Search Results zx_det_factor_templ_b




Overview
Explore in AI Chat

Overview

The ZX_DET_FACTOR_TEMPL_B table is a core repository within the Oracle E-Business Tax (ZX) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master definition table for determining factor templates. These templates are critical configuration components that define the logic and sequence of conditions, or "determining factors," used by the E-Business Tax engine to calculate the applicable tax regime, tax, tax status, and tax rate for a given transaction. Each record in this table represents a unique, reusable template that can be associated with various tax setup entities, providing a centralized and consistent method for controlling complex tax determination logic across the application.

Key Information Stored

The primary data stored in ZX_DET_FACTOR_TEMPL_B is the template definition itself. The central column is the DET_FACTOR_TEMPL_CODE, which serves as the unique identifier (Primary Key) for each template. This code is referenced throughout the tax setup. While the provided metadata does not list all columns, standard practice for such definition tables in the ZX schema includes columns for controlling the template's lifecycle and context, such as LEDGER_ID (a foreign key to GL_LEDGERS), which ties the template to a specific legal entity or ledger. Other typical columns would include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and START_DATE/END_DATE for enabling and disabling the template.

Common Use Cases and Queries

The primary use case for this table is during the implementation and maintenance of tax determination rules. A tax consultant would create determining factor templates via the E-Business Tax Manager UI, which writes records to this table. Common queries involve auditing and reporting on the setup. For instance, to list all active determining factor templates for a specific ledger, a query might be: SELECT DET_FACTOR_TEMPL_CODE FROM ZX.ZX_DET_FACTOR_TEMPL_B WHERE LEDGER_ID = :p_ledger_id AND (END_DATE IS NULL OR END_DATE > SYSDATE);. Another critical scenario is troubleshooting tax determination errors, where a developer might trace a specific template code used in a rule back to its master definition. Data fixes or mass updates, though rare, would also target this table directly, often requiring coordination with the referenced foreign key tables.

Related Objects

As indicated by the foreign key relationships, ZX_DET_FACTOR_TEMPL_B is a foundational object referenced by numerous other key tax setup tables. Its primary key (DET_FACTOR_TEMPL_CODE) is referenced by:

This extensive referencing underscores the template's role as a shared component across the entire tax determination framework.