Search Results unit




The LEGACY_PS_REC_TABLES lookup type in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical configuration element used primarily in the context of legacy data migration, reporting, or integration processes. This lookup type serves as a metadata repository that maps legacy tables from older systems (such as PeopleSoft) to corresponding Oracle EBS tables, enabling seamless data transformation and reconciliation during system upgrades or data consolidation projects. Below is a detailed analysis of its purpose, structure, and implementation within Oracle EBS.

Purpose and Context

The LEGACY_PS_REC_TABLES lookup type is designed to facilitate the transition from legacy systems (e.g., PeopleSoft) to Oracle EBS by maintaining a reference of table mappings. It ensures that data extracted from legacy tables can be accurately transformed and loaded into Oracle EBS tables. This is particularly useful in scenarios where organizations migrate from PeopleSoft to Oracle EBS or need to maintain backward compatibility for reporting and auditing purposes.

Technical Structure

This lookup type is defined in the Oracle Application Object Library (FND_LOOKUP_TYPES) and consists of the following key components:
  • Lookup Code: Represents the legacy table name (e.g., PS_EMPLOYEES).
  • Meaning: The corresponding Oracle EBS table name (e.g., PER_ALL_PEOPLE_F).
  • Description: Additional metadata, such as the purpose of the mapping or transformation rules.
  • Enabled Flag: Indicates whether the mapping is active.
  • Start/End Date: Defines the validity period of the mapping.

Implementation in Oracle EBS

In Oracle EBS 12.1.1 and 12.2.2, the LEGACY_PS_REC_TABLES lookup type is typically accessed and maintained via the following methods:
  1. Application Developer Responsibility: Administrators navigate to Application Developer > Application > Lookups > Application Object Library to define or modify lookup values.
  2. SQL Scripts: For bulk updates, scripts can directly insert or update records in FND_LOOKUP_VALUES with LOOKUP_TYPE = 'LEGACY_PS_REC_TABLES'.
  3. APIs: The FND_LOOKUP_PKG can be used programmatically to manage lookup entries.

Use Cases

  1. Data Migration: During a PeopleSoft-to-EBS migration, this lookup type ensures legacy data is correctly mapped to EBS tables.
  2. Reporting: Legacy reports referencing PeopleSoft tables can be redirected to EBS tables using these mappings.
  3. Integration: Middleware tools (e.g., Oracle Integration Cloud) use these mappings to transform legacy data feeds into EBS-compatible formats.

Challenges and Best Practices

  • Data Consistency: Ensure mappings are validated to prevent data corruption during migration.
  • Performance: Large lookup datasets may require indexing or caching optimizations.
  • Maintenance: Regularly review and disable obsolete mappings to avoid confusion.

Conclusion

The LEGACY_PS_REC_TABLES lookup type is a pivotal component in Oracle EBS for managing legacy system transitions. By providing a structured approach to table mapping, it simplifies data migration, reporting, and integration tasks. Proper configuration and maintenance of this lookup type are essential to ensure data integrity and system efficiency in Oracle EBS 12.1.1 and 12.2.2 environments.