Search Results zx_det_factor_templ_b

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:

ZX_RULES_B: The main tax rules table, linking rules to their determination logic.
ZX_EVNT_CLS_MAPPINGS & ZX_EVNT_CLS_OPTIONS: Tables governing event class mappings and options.
ZX_EXCEPTIONS & ZX_EXEMPTIONS: Tables defining tax exceptions and exemptions.
ZX_REGIMES_B & ZX_TAXES_B: Referenced via the THRSHLD_CHK_TMPLT_CODE column for threshold checking logic within tax regimes and taxes.

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

Table: ZX_DET_FACTOR_TEMPL_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_B, object_name:ZX_DET_FACTOR_TEMPL_B, status:VALID, product: ZX - E-Business Tax , description: This table stores templates for usage of determining factors. Each record represents one determining factor template. , implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_B ,
Table: ZX_DET_FACTOR_TEMPL_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_B, object_name:ZX_DET_FACTOR_TEMPL_B, status:VALID, product: ZX - E-Business Tax , description: This table stores templates for usage of determining factors. Each record represents one determining factor template. , implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_B ,
Table: ZX_DET_FACTOR_TEMPL_DTL 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_DTL, object_name:ZX_DET_FACTOR_TEMPL_DTL, status:VALID, product: ZX - E-Business Tax , description: This table stores a set of determining factors for each determining factor template defined in ZX_DET_FACTOR_TEMPL_B. Each record represents one determining factor in the determining factor template. , implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_DTL ,
Table: ZX_EVNT_CLS_OPTIONS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVNT_CLS_OPTIONS, object_name:ZX_EVNT_CLS_OPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax options for application event classes. Each row contains tax options defined by a first party organization for an application event class. , implementation_dba_data: ZX.ZX_EVNT_CLS_OPTIONS ,
Table: ZX_EXEMPTIONS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EXEMPTIONS, object_name:ZX_EXEMPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax exemptions for parties, party sites and items. Each record contains an exemption percentage of a specific tax rate for a party, party site or an item. , implementation_dba_data: ZX.ZX_EXEMPTIONS ,
Table: ZX_EVNT_CLS_MAPPINGS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVNT_CLS_MAPPINGS, object_name:ZX_EVNT_CLS_MAPPINGS, status:VALID, product: ZX - E-Business Tax , description: ZX_EVNT_CLS_MAPPINGS stores mappings of tax event classes to event classes of Oracle Applications. , implementation_dba_data: ZX.ZX_EVNT_CLS_MAPPINGS ,
Table: ZX_DET_FACTOR_TEMPL_DTL 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_DTL, object_name:ZX_DET_FACTOR_TEMPL_DTL, status:VALID, product: ZX - E-Business Tax , description: This table stores a set of determining factors for each determining factor template defined in ZX_DET_FACTOR_TEMPL_B. Each record represents one determining factor in the determining factor template. , implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_DTL ,
Table: ZX_TAXES_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_TAXES_B, object_name:ZX_TAXES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. , implementation_dba_data: ZX.ZX_TAXES_B ,
Table: ZX_EVNT_CLS_OPTIONS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVNT_CLS_OPTIONS, object_name:ZX_EVNT_CLS_OPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax options for application event classes. Each row contains tax options defined by a first party organization for an application event class. , implementation_dba_data: ZX.ZX_EVNT_CLS_OPTIONS ,
Table: ZX_EVNT_CLS_MAPPINGS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EVNT_CLS_MAPPINGS, object_name:ZX_EVNT_CLS_MAPPINGS, status:VALID, product: ZX - E-Business Tax , description: ZX_EVNT_CLS_MAPPINGS stores mappings of tax event classes to event classes of Oracle Applications. , implementation_dba_data: ZX.ZX_EVNT_CLS_MAPPINGS ,
Table: ZX_EXCEPTIONS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EXCEPTIONS, object_name:ZX_EXCEPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax rate exceptions for items and product fiscal classifications.Each row specifies the percentage of original tax rate to be treated as an exception for an item or a product fiscal classification during tax calculation. , implementation_dba_data: ZX.ZX_EXCEPTIONS ,
Table: ZX_EXEMPTIONS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EXEMPTIONS, object_name:ZX_EXEMPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax exemptions for parties, party sites and items. Each record contains an exemption percentage of a specific tax rate for a party, party site or an item. , implementation_dba_data: ZX.ZX_EXEMPTIONS ,
Table: ZX_RULES_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_RULES_B, object_name:ZX_RULES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. , implementation_dba_data: ZX.ZX_RULES_B ,
Table: ZX_RULES_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_RULES_B, object_name:ZX_RULES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. , implementation_dba_data: ZX.ZX_RULES_B ,
Table: ZX_TAXES_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_TAXES_B, object_name:ZX_TAXES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. , implementation_dba_data: ZX.ZX_TAXES_B ,
Table: ZX_EXCEPTIONS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_EXCEPTIONS, object_name:ZX_EXCEPTIONS, status:VALID, product: ZX - E-Business Tax , description: This table stores tax rate exceptions for items and product fiscal classifications.Each row specifies the percentage of original tax rate to be treated as an exception for an item or a product fiscal classification during tax calculation. , implementation_dba_data: ZX.ZX_EXCEPTIONS ,
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 ,