Results for “tax_hier_system”

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

Overview

IGC.IGC_CC_SYSTEM_PARAMETERS is a setup and control table within the Oracle E-Business Suite IGC – Contract Commitment product family. It stores organization-level system parameters that govern how the Contract Commitment module processes contracts, particularly with respect to default rate types, vendor and vendor site holds, and tax determination logic. Because Oracle EBS is a multi-organization (multi-org) application, the parameters are keyed by ORG_ID, allowing each operating unit or inventory organization to maintain its own behavioral configuration for contract commitments.

Under a heuristic Data Vault classification derived from its foreign key structure, this table is satellite-leaning. In Data Vault modeling terms, a satellite records descriptive, time-variant attributes that describe a business key. The single foreign key to HR_ALL_ORGANIZATION_UNITS suggests that the organization identifier acts as the effective business key, while the remaining configuration columns (rate type defaults, hold and tax flags, and tax hierarchies) behave as descriptive attributes belonging to that organization. This classification should be treated as a modeling suggestion rather than a definitive architectural assertion, since the table also carries a configuration/parameter role rather than a pure transactional one.

Key Information Stored

The table contains 14 documented columns in the ETRM 12.2.2 schema, owned by the IGC schema. The most significant columns are:

• ORG_ID – The organization (operating unit) identifier. This is the primary foreign key to HR_ALL_ORGANIZATION_UNITS and the principal business-key candidate that scopes a parameter row to a specific organization.
• DEFAULT_RATE_TYPE – Specifies the default rate type applied to contract commitments when a specific rate type is not explicitly supplied, governing currency conversion behavior.
• ENFORCE_VENDOR_HOLD_FLAG – A flag controlling whether vendor hold status is enforced when processing contracts.
• TAX_FROM_VENDOR_FLAG – Determines whether tax attributes are derived from the vendor party (supplier).
• TAX_FROM_VENDOR_SITE_FLAG – Determines whether tax attributes are derived from the vendor site rather than the vendor header.
• TAX_FROM_SYSTEM_FLAG – Controls whether the system's own tax defaults take precedence in tax determination.
• TAX_HIER_VENDOR, TAX_HIER_VENDOR_SITE, TAX_HIER_SYSTEM – Define the tax hierarchy or precedence applied when resolving taxes from the vendor, the vendor site, or the system respectively.

The remaining columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY) constitute standard Oracle EBS WHO-column audit attributes that track row creation and modification. The documented metadata identifies no dedicated surrogate primary key column beyond the organization foreign key, and no unique indexes are documented in the excerpt.

Common Use Cases and Queries

This table is primarily consulted during the initialization and processing of contract commitments to determine default rate types and tax/hold rules. Typical scenarios include auditing which organizations enforce vendor holds, troubleshooting unexpected tax derivation behavior, and reporting configuration consistency across multiple operating units.

Sample query to inspect parameters for a given organization:

• SELECT org_id, default_rate_type, enforce_vendor_hold_flag, tax_from_vendor_flag, tax_from_system_flag FROM igc.igc_cc_system_parameters WHERE org_id = :p_org_id;

For an organization-wide configuration report joining to the organization definition:

• SELECT p.org_id, o.name, p.default_rate_type, p.tax_hier_system FROM igc.igc_cc_system_parameters p, hr_all_organization_units o WHERE p.org_id = o.organization_id;

Audit-oriented queries can use last_update_date and last_updated_by to identify when parameter changes were made and by which user, supporting change-control reporting.

Related Objects

The principal related object is the foreign key target:

• HR_ALL_ORGANIZATION_UNITS – joined via IGC_CC_SYSTEM_PARAMETERS.ORG_ID to the organization's identifier column to resolve organization names and attributes.

Because this is a setup table, dependent IGC Contract Commitment objects—contract headers, contract lines, commitment records, and the module's concurrent programs and forms—reference these parameter values at runtime to apply defaulting and validation rules. The standard EBS WHO columns further link to user and session audit information. Practitioners should consult the broader set of IGC module tables alongside this one for complete contract-commitment configuration analysis.