Results for “csp_excess_rules_tl”
40 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CSP_EXCESS_RULES_TL is the translation (language) table for Excess Rules definitions within the Oracle E-Business Suite Spares Management (CSP) module. It stores the language-specific, user-facing descriptive text for each Excess Rule record whose transactional and control attributes reside in the base table CSP_EXCESS_RULES_B. In Oracle EBS Release 12.1.1 and 12.2.2, the CSP schema governs service and spare parts planning, and Excess Rules drive the logic that identifies and processes surplus inventory positions. The _TL designation follows the standard EBS multilingual pattern: the _B table holds language-independent columns, while the _TL table holds the translatable DESCRIPTION column keyed by both the entity identifier and LANGUAGE.
From a data-modeling perspective, the foreign key relationship to CSP_EXCESS_RULES_B indicates that this object is best classified as satellite-leaning. It extends the base entity with descriptive, language-dependent attributes rather than introducing new business entities or many-to-many associations. Modelers should treat CSP_EXCESS_RULES_B as the hub (or core entity) and CSP_EXCESS_RULES_TL as its descriptive satellite, with LANGUAGE acting as an additional discriminating attribute in the satellite key.
Key Information Stored
The table is documented with ten columns. The most significant are:
- EXCESS_RULE_ID — The surrogate primary-key component tying each translated row to its parent Excess Rule in CSP_EXCESS_RULES_B. It is the first column of the composite primary key CSP_EXCESS_RULES_TL_PK.
- LANGUAGE — The second primary-key component, identifying the language of the row (for example, US for U.S. English). Together with EXCESS_RULE_ID it forms the unique business-key candidate CSP_EXCESS_RULES_TL_U1.
- SOURCE_LANG — Indicates the source language from which the row was created, supporting the EBS Translation/MLS framework.
- DESCRIPTION — The translated, user-facing description of the Excess Rule; this is the primary payload of the translation row.
- SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing the EBS security-group (operating unit) isolation model.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard EBS WHO audit columns, tracking row creation and modification history for validation and audit purposes.
The distinguishing structural fact is that the surrogate/business key is composite (EXCESS_RULE_ID, LANGUAGE), not a single column, whereas SECURITY_GROUP_ID is a foreign key rather than part of the primary key.
Common Use Cases and Queries
Because this is a translation table, the dominant use case is resolving the description of an Excess Rule in the language of the connected EBS session. Typical multilingual reporting and integration queries join the _TL table to its base table and filter on LANGUAGE, for example:
- Reporting the rule descriptions for a given language: SELECT b.excess_rule_id, t.description FROM csp_excess_rules_b b, csp_excess_rules_tl t WHERE b.excess_rule_id = t.excess_rule_id AND t.language = USERENV('LANG');
- Confirming that every base rule has a translated row: an outer join from CSP_EXCESS_RULES_B to CSP_EXCESS_RULES_TL on EXCESS_RULE_ID to detect missing translations.
- Security-scoped extracts filtering on SECURITY_GROUP_ID to return only rules visible to a given operating unit.
- Audit and data-conversion validation using CREATION_DATE and LAST_UPDATE_DATE to identify recently maintained translations.
Queries should always constrain LANGUAGE to avoid returning multiple rows per rule and should be mindful of the WHO and security-group columns when extracting data for downstream systems.
Related Objects
The following objects are most relevant to CSP_EXCESS_RULES_TL:
- CSP_EXCESS_RULES_B — The base (language-independent) Excess Rules table; joined on EXCESS_RULE_ID, and the parent in the documented foreign key.
- FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID; supplies the security-group definition used for row-level access control.
- CSP_EXCESS_RULES_TL_PK — The composite primary key unique index on (EXCESS_RULE_ID, LANGUAGE).
- CSP_EXCESS_RULES_TL_U1 — The unique business-key index, also on (EXCESS_RULE_ID, LANGUAGE).
- FND_LANGUAGES — The standard EBS language lookup that resolves the LANGUAGE and SOURCE_LANG codes stored in this table.
- The CSP Excess Rules maintenance form and its associated API/validation logic — which read and write the translated DESCRIPTION through the _TL table during rule maintenance.
Together these objects form the translated Excess Rules definition set used throughout Spares Management.
-
Translated Excess rules definitions
-
Translated Excess rules definitions
-
View: CSP_EXCESS_RULES_VL 12.2.2
Shows excess rules with translated description.
APPS.CSP_EXCESS_RULES_VL·↳ CSP_EXCESS_RULES_B·↳ CSP_EXCESS_RULES_TL·Explore CSP module →
-
View: CSP_EXCESS_RULES_VL 12.1.1
Shows excess rules with translated description.
APPS.CSP_EXCESS_RULES_VL·↳ CSP_EXCESS_RULES_B·↳ CSP_EXCESS_RULES_TL·Explore CSP module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - CSP Tables and Views 12.1.1
Summarized usage history information
-
eTRM - CSP Tables and Views 12.2.2
Summarized usage history information
-
eTRM - CSP Tables and Views 12.1.1
Summarized usage history information
-
eTRM - CSP Tables and Views 12.2.2
Summarized usage history information
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1