Search Results responsibility

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:

Application Developer Responsibility: Administrators navigate to Application Developer > Application > Lookups > Application Object Library to define or modify lookup values.
SQL Scripts: For bulk updates, scripts can directly insert or update records in FND_LOOKUP_VALUES with LOOKUP_TYPE = 'LEGACY_PS_REC_TABLES'.
APIs: The FND_LOOKUP_PKG can be used programmatically to manage lookup entries.

Use Cases

Data Migration: During a PeopleSoft-to-EBS migration, this lookup type ensures legacy data is correctly mapped to EBS tables.
Reporting: Legacy reports referencing PeopleSoft tables can be redirected to EBS tables using these mappings.
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.

Lookup Type: OSS_SECURED_SS_RESP 12.1.1
product: IGS - Student System , meaning: OSS Admin Responsibilities , description: Lookup type for storing all Self-Service Admin responsibilities. ,
View: IGS_PS_TCH_RESP_UOO_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PS_TCH_RESP_UOO_V, object_name:IGS_PS_TCH_RESP_UOO_V, status:VALID, product: IGS - Student System , description: View created to contain the teaching responsibility, which applies to a given unit offering option. This routine will use either the teaching responsibility or teaching responsibility override tables to determine the relevant responsibility , implementation_dba_data: APPS.IGS_PS_TCH_RESP_UOO_V ,
Lookup Type: IGS_AD_SS_RESP 12.1.1
product: IGS - Student System , meaning: Applicant page Configuration Responsibility Type , description: Applicant page Configuration Responsibility Type ,
Lookup Type: DISBURSEMENT_METHOD 12.1.1
product: IGS - Student System , meaning: Disbursement Method , description: Obsolete Disbursement Method ,
Lookup Type: VS_AS_SORT_UNIT 12.1.1
product: IGS - Student System , meaning: Static Values For Sort By Unit , description: Static Values For Sort By Unit ,
Lookup Type: LEGACY_PS_REC_TABLES 12.1.1
product: IGS - Student System , meaning: Program Structure and Planning Interface Tables. , description: Program Structure and Planning Interface Tables being imported by the Legacy Import process. ,
Table: IGS_SS_PE_PERTYP_RESP_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_SS_PE_PERTYP_RESP_ALL, object_name:IGS_SS_PE_PERTYP_RESP_ALL, status:VALID, product: IGS - Student System , description: Stores the Person Type responsibility details , implementation_dba_data: IGS.IGS_SS_PE_PERTYP_RESP_ALL ,
Table: IGS_SS_PERTYP_RESP_GROUPS_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_SS_PERTYP_RESP_GROUPS_ALL, object_name:IGS_SS_PERTYP_RESP_GROUPS_ALL, status:VALID, product: IGS - Student System , description: Stores the Person Type responsibility group details , implementation_dba_data: IGS.IGS_SS_PERTYP_RESP_GROUPS_ALL ,
Table: IGS_AD_CRT_APPL_CFG 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_AD_CRT_APPL_CFG, object_name:IGS_AD_CRT_APPL_CFG, status:VALID, product: IGS - Student System , description: Stores the "Create application Page" configuration details , implementation_dba_data: IGS.IGS_AD_CRT_APPL_CFG ,
View: IGS_PS_TCH_RESP_HIST_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PS_TCH_RESP_HIST_V, object_name:IGS_PS_TCH_RESP_HIST_V, status:VALID, product: IGS - Student System , description: This view is used to merge teaching responsibility history with the current teaching responsibility details enabling all details to be accessed over time, up till the current day. , implementation_dba_data: APPS.IGS_PS_TCH_RESP_HIST_V ,
Table: IGS_PE_TYP_RSP_DFLT 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_PE_TYP_RSP_DFLT, object_name:IGS_PE_TYP_RSP_DFLT, status:VALID, product: IGS - Student System , description: Contains the mapping of System Person Types with Responsibility. , implementation_dba_data: IGS.IGS_PE_TYP_RSP_DFLT ,
Table: IGP_AS_RESP_MAPPINGS 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGP_AS_RESP_MAPPINGS, object_name:IGP_AS_RESP_MAPPINGS, status:VALID, product: IGS - Student System , description: Table to store the setup data for mapping between account classification and responsibility , implementation_dba_data: IGS.IGP_AS_RESP_MAPPINGS ,
Table: IGS_PS_TCH_RESP_HIST_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_PS_TCH_RESP_HIST_ALL, object_name:IGS_PS_TCH_RESP_HIST_ALL, status:VALID, product: IGS - Student System , description: This entity describes the history of changes to a unit version's teaching responsibility. , implementation_dba_data: IGS.IGS_PS_TCH_RESP_HIST_ALL ,
Lookup Type: OR_FTR_FUNC_NAME 12.1.1
product: IGS - Student System , meaning: OR_FTR_FUNC_NAME , description: Organization Structure Filter Function Name ,
View: IGS_AD_CRT_APPL_CFG_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_AD_CRT_APPL_CFG_V, object_name:IGS_AD_CRT_APPL_CFG_V, status:VALID, product: IGS - Student System , description: Form view for IGS_AD_CRT_APPL_CFG table , implementation_dba_data: APPS.IGS_AD_CRT_APPL_CFG_V ,
Table: IGS_PS_TCH_RSOV_HIST_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_PS_TCH_RSOV_HIST_ALL, object_name:IGS_PS_TCH_RSOV_HIST_ALL, status:VALID, product: IGS - Student System , description: This table describes the teaching responsibility override details for a given unit offering option. Where an override is specified, it must total 100% for any given unit offering option. , implementation_dba_data: IGS.IGS_PS_TCH_RSOV_HIST_ALL ,
Table: IGS_PS_TCH_RESP_OVRD_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_PS_TCH_RESP_OVRD_ALL, object_name:IGS_PS_TCH_RESP_OVRD_ALL, status:VALID, product: IGS - Student System , description: This table describes the teaching responsibility override details for a given unit offering option. Where an override is specified, it must total 100% for any given unit offering option. , implementation_dba_data: IGS.IGS_PS_TCH_RESP_OVRD_ALL ,
View: IGS_PS_TCH_RSOV_HIST_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PS_TCH_RSOV_HIST_V, object_name:IGS_PS_TCH_RSOV_HIST_V, status:VALID, product: IGS - Student System , description: This view is used to merge teaching responsibility override history with the current teaching responsibility override details enabling all details to be accessed over time, up till the current day. , implementation_dba_data: APPS.IGS_PS_TCH_RSOV_HIST_V ,
View: IGS_SS_PERTYP_RESP_GROUPS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_SS_PERTYP_RESP_GROUPS, object_name:IGS_SS_PERTYP_RESP_GROUPS, status:VALID, product: IGS - Student System , description: This view stores the Person Type Responsibility Groups , implementation_dba_data: APPS.IGS_SS_PERTYP_RESP_GROUPS ,
View: IGS_PE_TYP_RSP_DFLT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_PE_TYP_RSP_DFLT_V, object_name:IGS_PE_TYP_RSP_DFLT_V, status:VALID, product: IGS - Student System , description: Contains mapping of System Person Type with Responsibility , implementation_dba_data: APPS.IGS_PE_TYP_RSP_DFLT_V ,
Lookup Type: LEGACY_TOKENS 12.1.1
product: IGS - Student System , meaning: Legacy Message Tokens , description: Legacy Message Tokens ,