Results for “igc_cc_system_parameters_v”

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

Overview

IGC_CC_SYSTEM_PARAMETERS_V is an APPS-owned reporting view in the Oracle E-Business Suite IGC (Contract Commitment) product family. It exposes the organization-level setup parameters that govern how Contract Commitment processes vendor holds, tax determination hierarchies, and currency conversion behavior. Because the underlying table is keyed by ORG_ID and carries WHO-style audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), the view is multi-org aware and is intended to be queried under a valid operating unit context. In 12.1.1 and 12.2.2 the object reports STATUS = VALID, and it is typically consumed by contract commitment inquiry screens, concurrent programs, and integration extracts that must resolve a transaction's effective tax or hold policy.

Underlying Base Objects

The view text is a two-table outer join. The driving table is IGC_CC_SYSTEM_PARAMETERS, aliased CSP, which stores the actual parameter values per operating unit. The second table is GL_DAILY_CONVERSION_TYPES, aliased GLD, joined on CSP.DEFAULT_RATE_TYPE = GLD.CONVERSION_TYPE with the Oracle outer-join operator (+). Because the join is outer, an organization row is still returned when its DEFAULT_RATE_TYPE does not match a defined daily conversion type; in that case GLD.USER_CONVERSION_TYPE is null. This correlation also means the view can surface duplicate rows if more than one daily conversion type matches the same conversion type name, a condition normally prevented by the GL unique key on CONVERSION_TYPE.

Key Columns

• ROW_ID / ROWID — the base-table row identifier from IGC_CC_SYSTEM_PARAMETERS, used for direct row access.
• ORG_ID — the operating unit that owns the parameter record; drives multi-org security (MOAC).
• DEFAULT_RATE_TYPE — the stored rate type code from the parameter table.
• CURRENCY_RATE_TYPE — the description of the conversion type retrieved from GL_DAILY_CONVERSION_TYPES.USER_CONVERSION_TYPE; this is the human-readable form of DEFAULT_RATE_TYPE.
• ENFORCE_VENDOR_HOLD_FLAG — the flag that determines whether vendor-level holds are enforced during Contract Commitment processing. It is the parameter most frequently searched for when diagnosing why a contract or commitment line was blocked for a held supplier.
• TAX_FROM_VENDOR_FLAG / TAX_FROM_VENDOR_SITE_FLAG / TAX_FROM_SYSTEM_FLAG — mutually relevant flags controlling which tax defaulting source takes precedence.
• TAX_HIER_VENDOR / TAX_HIER_VENDOR_SITE / TAX_HIER_SYSTEM — the tax hierarchy codes applied for the vendor, vendor site, and system levels respectively.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY for change tracking and support diagnostics.

Common Use Cases and Queries

Typical uses include confirming the effective vendor hold policy for an operating unit, verifying which tax hierarchy is applied to vendor-site tax determination, and resolving the default currency rate type used during commitment entry. A common diagnostic query is:

SELECT org_id,
       default_rate_type,
       currency_rate_type,
       enforce_vendor_hold_flag,
       tax_from_vendor_flag,
       tax_from_vendor_site_flag,
       tax_from_system_flag
FROM   apps.igc_cc_system_parameters_v
WHERE  enforce_vendor_hold_flag = 'Y';

To return only the parameters for the session's operating unit, filter on ORG_ID via the MOAC org_id context. Because the view is a simple outer join over a single configuration table, it is inexpensive to query and is safe to embed in concurrent-program extracts and BI Publisher data templates where current parameter values must be reported alongside transactional data.