Search Results a




The PER_RATING_LEVELS_TL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Oracle Human Capital Management (HCM) module, specifically within the Performance Management functionality. This table stores translated descriptions of rating levels used in performance evaluations, competency assessments, and other talent management processes. As a translation table (denoted by the "_TL" suffix), it supports multilingual implementations by holding language-specific representations of rating level names and descriptions.

Table Structure and Key Columns

The PER_RATING_LEVELS_TL table typically contains these important columns:
  • RATING_LEVEL_ID: Foreign key reference to the base rating level in PER_RATING_LEVELS
  • LANGUAGE: Stores the language code (e.g., 'US', 'FR', 'DE')
  • SOURCE_LANG: Indicates the source language of the translation
  • NAME: The translated name of the rating level (e.g., "Exceeds Expectations")
  • DESCRIPTION: Detailed explanation of what the rating level signifies

Functional Context

This table supports Oracle's multi-rater functionality where organizations define hierarchical rating scales (such as 1-5 scales or descriptive scales like "Poor" to "Excellent"). The translations enable global enterprises to maintain consistent performance evaluation criteria across geographies while presenting information in local languages.

Integration Points

PER_RATING_LEVELS_TL integrates with several key Oracle HCM components:
  • Performance Management (appraisals, 360-degree feedback)
  • Succession Planning (assessment ratings)
  • Competency Management (proficiency level ratings)
  • Talent Profile (display of historical ratings)

Technical Implementation

The table follows Oracle's standard multilingual architecture:
  • Base data resides in PER_RATING_LEVELS
  • Translations are stored in PER_RATING_LEVELS_TL with LANGUAGE column filtering
  • Applications use the NLS (National Language Support) environment to determine which translation to display

Customization Considerations

When implementing or upgrading Oracle EBS HCM:
  • Translation records must be maintained for all active languages
  • Custom rating scales require corresponding TL entries
  • Reporting solutions must account for language preferences when joining to this table
  • Data migration scripts should handle both base and translated records

Common Use Cases

Typical scenarios involving this table include:
  • Generating performance appraisal forms in multiple languages
  • Displaying historical ratings in employee self-service portals
  • Configuring workflow notifications with localized rating descriptions
  • Developing analytics on performance distribution across regions

Maintenance Best Practices

For optimal performance and data integrity:
  • Maintain indexes on RATING_LEVEL_ID and LANGUAGE columns
  • Implement a translation maintenance process during rating model changes
  • Audit translation completeness as part of periodic system reviews
  • Consider table growth when adding new languages to the implementation
This table exemplifies Oracle's approach to global HCM implementations where both standardized rating methodologies and localized user experiences are equally important for effective talent management processes.