Results for “primary_inventory_category_set”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ZX_FC_COUNTRY_DEFAULTS is a configuration table in the Oracle E-Business Tax (ZX) module of Oracle EBS 12.1.1 and 12.2.2. It stores tax defaults and controls at the country level, providing one authoritative record of tax configuration behavior per country. Each row defines the regime, tax, registration, and authority defaults that E-Business Tax applies automatically when transactions are entered, calculated, and reported for that country. Because the table drives the defaulting engine rather than storing transactional tax results, it is populated primarily during country-specific tax setup and thereafter maintained by tax administrators.

Under the heuristic Data Vault classification derived from the foreign key and uniqueness structure, this object is satellite-leaning. Its grain is one row per country, keyed by a surrogate identifier, with a natural business key defined by COUNTRY_CODE. That orientation suggests it is best modeled as a reference or dimension-style satellite that describes country-level defaults, subordinate to the territory hub represented by FND_TERRITORIES.

Key Information Stored

The table contains 46 documented columns. The most significant for functional and reporting purposes are:

• COUNTRY_DEFAULTS_ID — surrogate primary key (ZX_FC_COUNTRY_DEFAULTS_PK); also a business-key candidate via ZX_FC_COUNTRY_DEFAULTS_U1.
• COUNTRY_CODE — the natural business key, unique via ZX_FC_COUNTRY_DEFAULTS_U2 and the foreign key to FND_TERRITORIES. Determines which country's defaults apply.
• TRANS_CATEG_CTRL_LEVEL_CODE and PRODUCT_CATEG_CTRL_LEVEL_CODE — control levels governing transaction and product category defaults.
• DEFAULT_INVENTORY_CATEGORY_SET and PRODUCT_CATEG_DEFAULT — inventory category set and default product category used in tax determination.
• INTENDED_USE_DEFAULT — default intended-use classification for tax driver derivation.
• TAX_REGIME_CODE — default tax regime associated with the country.
• DEF_REGIME_FOR_INVOICE_FLAG, DEF_REGIME_FOR_LE_TR_FLAG, DEF_TAX_FOR_INVOICE_FLAG, DEF_TAX_FOR_LE_TR_FLAG — flags controlling whether regime and tax defaults apply at invoice or legal entity/transaction level.
• TAX, ROUNDING_RULE_CODE — default tax and rounding rule applied to calculations.
• REGISTRATION_TYPE_CODE, REGISTRATION_STATUS_CODE — default registration type and status used in party tax profile and registration defaulting.
• COLLECT_TAX_AUTHORITY_ID, REPORT_TAX_AUTHORITY_ID, ISSUE_TAX_AUTHORITY_ID — tax authority identifiers used for collection, reporting, and document issuance.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID — standard concurrency, audit, and concurrent-program context columns.

Common Use Cases and Queries

Typical uses include validating that a country has been configured before transaction entry, auditing the defaulting behavior for a territory, and driving reports on registration and authority assignments.

Retrieve all defaults for a country:

• SELECT * FROM zx.zx_fc_country_defaults WHERE country_code = 'US';

List countries with their default regime and tax:

• SELECT country_code, tax_regime_code, tax FROM zx.zx_fc_country_defaults ORDER BY country_code;

Identify countries where regime or tax defaults apply at invoice level:

• SELECT country_code FROM zx.zx_fc_country_defaults WHERE def_regime_for_invoice_flag = 'Y' OR def_tax_for_invoice_flag = 'Y';

Join to territory names for reporting:

• SELECT d.country_code, t.territory_short_name, d.registration_type_code FROM zx.zx_fc_country_defaults d, fnd_territories t WHERE d.country_code = t.territory_code;

Configuration completeness checks against registration and authority defaults support pre-implementation verification and post-patch regression testing.

Related Objects

The primary relationship is to FND_TERRITORIES on the join column ZX_FC_COUNTRY_DEFAULTS.COUNTRY_CODE = FND_TERRITORIES.TERRITORY_CODE, which ties each row to a valid territory. Other significant related objects include the ZX regime and registration tables (ZX_REGIMES, ZX_REGISTRATIONS, ZX_REGISTRATION_TYPES), which define the regimes, taxes, and registration types referenced by the default columns; ZX_TAX_AUTHORITIES, which supplies the collect, report, and issue authority identifiers; and the E-Business Tax configuration and defaulting logic that reads this table when deriving tax drivers. In query design, join COUNTRY_CODE to FND_TERRITORIES for descriptive context and validate TAX_REGIME_CODE against ZX_REGIMES to confirm that referenced regimes are enabled.