Search Results csi_install_parameters




Overview
Explore in AI Chat

Overview

The CSI_INSTALL_PARAMETERS table is an operational configuration table within the Oracle E-Business Suite Install Base (CSI) module. It stores application-level installation parameters that govern how Install Base processes transactional data, creates inventory and asset records, allocates components, and enforces ownership and security rules. Unlike the high-volume transactional tables that hold actual instance and item data (such as CSI_ITEM_INSTANCES), CSI_INSTALL_PARAMETERS functions as a reference and control table: a small, administrator-maintained set of rows that drive system-wide behavior.

Conceptually, the table captures the default locations, category set, sequencing rules, and flag-based controls used when Install Base integrates with Order Management, Inventory, Purchasing, Work in Process, and Fixed Assets. It bridges the Install Base application with enterprise-wide setup decisions.

Per the heuristic Data Vault classification mined from the foreign key structure, this object is assessed as standalone — that is, it does not clearly map to a hub, link, or satellite construct. In Data Vault modeling terms, this suggests treating CSI_INSTALL_PARAMETERS as an independent reference or parameter table rather than as a core business entity, though the presence of SECURITY_GROUP_ID as a foreign key means it must still participate in security-group-scoped joins.

Key Information Stored

The table contains 22 documented columns. The most significant are:

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and SECURITY_GROUP_ID complete the schema. SECURITY_GROUP_ID references FND_SECURITY_GROUPS and is the only documented foreign key. The table is a low-cardinality configuration object, so a single active row typically governs an entire security group or installation.

Common Use Cases and Queries

Administrators query this table to verify or diagnose Install Base behavior. A representative pattern retrieves the active configuration for a given security group:

  • Setup verification: SELECT * FROM csi.csi_install_parameters WHERE security_group_id = :sgid; — confirms location defaults, category set, and freeze status.
  • Freeze diagnostics: checking FREEZE_FLAG and FREEZE_DATE to determine whether transactional processing is currently suspended.
  • Integration troubleshooting: reviewing AUTO_ALLOCATE_COMP_AT_WIP, OWNERSHIP_OVERRIDE_AT_TXN, and OWNERSHIP_CASCADE_AT_TXN when ownership or allocation behaves unexpectedly during Order Management or WIP transactions.
  • Fixed Assets reconciliation: inspecting FA_CREATION_GROUP_BY to understand how asset records are grouped during creation.
  • Reporting/ETL: HISTORY_FULL_DUMP_FREQUENCY informs the schedule of full data extracts; parameters in this table often appear as a control row in warehouse load logic.

Related Objects

The documented relationship data identifies one foreign key target, with other CSI integration points inferred from the column semantics and standard Install Base architecture:

  • FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID; defines the security scope for the parameter row.
  • CSI_ITEM_INSTANCES — the core Install Base transactional table governed by the parameters here.
  • MTL_PARAMETERS / MTL_SYSTEM_ITEMS — inventory location and category set references used by the LOCATION_ID and CATEGORY_SET_ID columns.
  • FA_ADDITIONS / FA_BOOKS — Fixed Assets tables affected by FA_CREATION_GROUP_BY.
  • WIP_DISCRETE_JOBS / WIP_ENTITIES — WIP transactions influenced by AUTO_ALLOCATE_COMP_AT_WIP.
  • PO_HEADERS_ALL — purchasing flows tied to PO_LOCATION_ID.
  • CSI_INSTALL_PARAMETERS public API — where exposed, maintained through concurrent programs or DBA scripts rather than direct user interfaces.