Search Results xtr_company_parameters




Overview
Explore in AI Chat

Overview

The XTR_COMPANY_PARAMETERS table is a core data object within the Oracle E-Business Suite (EBS) Treasury (XTR) module. It functions as a central repository for storing and managing configuration parameters that are specific to individual legal entities or companies defined within the treasury system. Its primary role is to establish and maintain the operational rules, defaults, and control settings that govern treasury transactions and processes for each company. This enables a single EBS instance to support multiple, distinct treasury entities, each with its own tailored set of financial policies and processing behaviors, ensuring data integrity and appropriate segregation of treasury activities.

Key Information Stored

While the provided metadata does not list specific columns beyond the key structure, the table's description indicates it holds transactional parameters. Based on standard treasury implementations, such parameters typically include settings for interest calculation methods, default bank accounts for settlements, revaluation frequency, hedge accounting preferences, and authorization limits. The documented primary key, COMPANY_PARAMETER_ID, uniquely identifies each parameter record. The COMPANY_CODE column is a critical foreign key that links each parameter set to a specific company master record in the XTR_PARTY_INFO table, ensuring parameters are correctly scoped to the intended legal entity.

Common Use Cases and Queries

A primary use case is the configuration and maintenance of company-specific treasury operations during implementation or when onboarding a new legal entity. Treasury administrators query this table to review or audit the active settings for a company. Common reporting needs involve listing all configured companies and their critical parameters. A typical SQL pattern retrieves parameters for a specific company code, often joining to the party information table for descriptive details.

SELECT cp.*, pi.party_name
FROM xtr.xtr_company_parameters cp,
     xtr.xtr_party_info pi
WHERE cp.company_code = pi.company_code
  AND cp.company_code = '&COMPANY';

Another common query is used to verify parameter setup completeness across all treasury-enabled companies.

Related Objects

The table maintains a direct and essential relationship with the XTR_PARTY_INFO table, which serves as the master source for company definitions within the XTR module. The documented foreign key relationship is:

  • Foreign Key to XTR_PARTY_INFO: The column XTR_COMPANY_PARAMETERS.COMPANY_CODE references XTR_PARTY_INFO. This join is fundamental for associating parameter records with the correct legal entity name and details. Virtually all processes and reports that utilize company parameters will involve this join to resolve the company code to its full descriptive name.

As a foundational setup table, XTR_COMPANY_PARAMETERS is likely referenced by numerous transactional and control tables within the XTR schema (e.g., deal headers, settlement instructions) to enforce company-specific rules, though these are not explicitly detailed in the provided metadata.