Search Results planning party

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.

File: Student System Program Structure and Planning - Unit r11i10 ERD.pdf 12.1.1
product: IGS - Student System , size: 96.839 KBytes , file_type: PDF Diagram ,
File: Student System Program Structure and Planning - Program r11i10 ERD.pdf 12.1.1
product: IGS - Student System , size: 95.82 KBytes , file_type: PDF Diagram ,
Concurrent Program: IGSPSW09 12.1.1
execution_filename: IGSPSW09 , product: IGS - Student System , user_name: IGSPSW09 , description: Program Structure And Planning - Landwide , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: IGSPSJ12 12.1.1
execution_filename: IGS_PS_LGCY_CONC_PKG.LEGACY_BATCH_PROCESS , product: IGS - Student System , user_name: IGSPSJ12 , description: Legacy Import Process for Program Structure and Planning , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: IGSPSS09 12.1.1
execution_filename: IGSPSS09 , product: IGS - Student System , user_name: IGSPSS09 , description: Program Structure And Planning - Landscape , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: IGS_EN_USE_PLAN 12.1.1
product: IGS - Student System , meaning: Use Planning Sheet , description: Indicates if planning sheet is used by the institution or not ,
Lookup Type: IGS_MODULES 12.1.1
product: IGS - Student System , meaning: IGS: Oracle Student System modules , description: Oracle Student System modules. ,
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. ,
Lookup Type: PARTY_RELATIONS_TYPE 12.1.1
product: IGS - Student System , meaning: Party Relations Type , description: Party Relations Type ,
Table: IGS_EN_PLAN_UNITS 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_EN_PLAN_UNITS, object_name:IGS_EN_PLAN_UNITS, status:VALID, product: IGS - Student System , description: Contains the student planning sheet unit attempt details , implementation_dba_data: IGS.IGS_EN_PLAN_UNITS ,
Lookup Type: TRANSCRIPT_SOURCE 12.1.1
product: IGS - Student System , meaning: Transcript Source , description: Transcript Source ,
Lookup Type: PERSON_INTERNATIONAL_DETAILS 12.1.1
product: IGS - Student System , meaning: Person International Details , description: Person International Details ,
Lookup Type: ACTIVITY_SOURCE 12.1.1
product: IGS - Student System , meaning: Activity Source , description: Activity Source ,
Table: IGS_FI_ACCT_INT_ALL 12.1.1
product: IGS - Student System , description: This interface table stores third party account definitions - Obsolete , implementation_dba_data: Not implemented in this database ,
Table: IGS_FI_TERM_INT_ALL 12.1.1
product: IGS - Student System , description: This interface table stores third party payment term definitions. , implementation_dba_data: Not implemented in this database ,
Table: IGS_DA_PRSMD 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_DA_PRSMD, object_name:IGS_DA_PRSMD, status:VALID, product: IGS - Student System , description: Storage of information on requests made for Person modifications to assist 3rd party on OSS updates , implementation_dba_data: IGS.IGS_DA_PRSMD ,
Table: IGS_DA_REQ_RPTS 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_DA_REQ_RPTS, object_name:IGS_DA_REQ_RPTS, status:VALID, product: IGS - Student System , description: Storage for Degree Audit Request Reports generated by the 3rd Party. , implementation_dba_data: IGS.IGS_DA_REQ_RPTS ,
Table: IGS_DA_CNFG_SRT_ORD 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_DA_CNFG_SRT_ORD, object_name:IGS_DA_CNFG_SRT_ORD, status:VALID, product: IGS - Student System , description: Storage for Degree Audit Request configuration on how Units and Unit Like information (Test scores and special requirements) is to be stored in the outgoing tables for the 3rd party. , implementation_dba_data: IGS.IGS_DA_CNFG_SRT_ORD ,
Table: IGS_DA_IN_SRC_UNTS 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_DA_IN_SRC_UNTS, object_name:IGS_DA_IN_SRC_UNTS, status:VALID, product: IGS - Student System , description: Storage for all the Source Units given by the 3rd party for the Students in the Degree Audit Request. , implementation_dba_data: IGS.IGS_DA_IN_SRC_UNTS ,
Lookup Type: IGS_FI_LOCKBOX 12.1.1
product: IGS - Student System , meaning: Concurrent Log Parameter Column Titles , description: Concurrent Log Parameter Column Titles ,
Table: IGS_DA_IN_RSLT_UNTS 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_DA_IN_RSLT_UNTS, object_name:IGS_DA_IN_RSLT_UNTS, status:VALID, product: IGS - Student System , description: Storage for the Resulting Unit information from the 3rd party about Units for the Students in the Degree Audit Request. , implementation_dba_data: IGS.IGS_DA_IN_RSLT_UNTS ,
Table: IGS_FI_PARTY_VENDRS 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_FI_PARTY_VENDRS, object_name:IGS_FI_PARTY_VENDRS, status:VALID, product: IGS - Student System , description: Maintains the relationships between the Party in Oracle Student System and Supplier in Oracle Payables. , implementation_dba_data: IGS.IGS_FI_PARTY_VENDRS ,
Table: IGS_FI_PARTY_SA 12.1.1
product: IGS - Student System , description: Stores the mapping between the party id and the sub account id , implementation_dba_data: Not implemented in this database ,
Table: IGS_FI_EXT_INT_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_FI_EXT_INT_ALL, object_name:IGS_FI_EXT_INT_ALL, status:VALID, product: IGS - Student System , description: This table is used as a source for the entry of all external charges from any third party. , implementation_dba_data: IGS.IGS_FI_EXT_INT_ALL ,
Table: IGS_DA_IN_PRG 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_DA_IN_PRG, object_name:IGS_DA_IN_PRG, status:VALID, product: IGS - Student System , description: Storage for the incoming information from the 3rd party about programs related to the Students in the Degree Audit Request. , implementation_dba_data: IGS.IGS_DA_IN_PRG ,
Table: IGS_DA_IN_USET 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_DA_IN_USET, object_name:IGS_DA_IN_USET, status:VALID, product: IGS - Student System , description: Storage for incoming Unit Set information for the programs coming back from the 3rd party for the Students in the Degree Audit Request. , implementation_dba_data: IGS.IGS_DA_IN_USET ,
Lookup Type: IMPORT_INST_ERROR_CODE 12.1.1
product: IGS - Student System , meaning: Import Inst Error Code , description: Import Inst Error Code ,
View: IGSBV_PARTY_BALANCES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSBV_PARTY_BALANCES, object_name:IGSBV_PARTY_BALANCES, status:VALID, product: IGS - Student System , description: In context of an account, gives balance amount for a party , implementation_dba_data: APPS.IGSBV_PARTY_BALANCES ,
Table: IGS_FI_BALANCES 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_FI_BALANCES, object_name:IGS_FI_BALANCES, status:VALID, product: IGS - Student System , description: This table contains balance amount for a party in the context of an Account. , implementation_dba_data: IGS.IGS_FI_BALANCES ,
Table: IGS_FI_PARTY_SUBACTS 12.1.1
product: IGS - Student System , description: Captures information that are specific to a person and sub account relationship. This table contains holds threshold amount , holds waiver flag etc. that are pertinent to the party and sub account context. , implementation_dba_data: Not implemented in this database ,
View: IGS_FI_PARTY_VENDRS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_PARTY_VENDRS_V, object_name:IGS_FI_PARTY_VENDRS_V, status:VALID, product: IGS - Student System , description: Entity to retrieve relationships between the Party in Oracle Student System and Supplier in Oracle Payables. , implementation_dba_data: APPS.IGS_FI_PARTY_VENDRS_V ,
View: IGSFV_PARTY_BALANCES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSFV_PARTY_BALANCES, object_name:IGSFV_PARTY_BALANCES, status:VALID, product: IGS - Student System , description: In context of an account, gives balance amount for a party , implementation_dba_data: APPS.IGSFV_PARTY_BALANCES ,
View: IGSBV_PARTY_CREDITS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSBV_PARTY_CREDITS, object_name:IGSBV_PARTY_CREDITS, status:VALID, product: IGS - Student System , description: Stores all Party Credits in Student Finance , implementation_dba_data: APPS.IGSBV_PARTY_CREDITS ,
View: IGS_DA_XML_CONTROL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_DA_XML_CONTROL_V, object_name:IGS_DA_XML_CONTROL_V, status:VALID, product: IGS - Student System , description: XML element ControlType. View of the request configuration. Provides 3rd Party Software specific processing instructions. , implementation_dba_data: APPS.IGS_DA_XML_CONTROL_V ,
View: IGSFV_PARTY_CREDITS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGSFV_PARTY_CREDITS, object_name:IGSFV_PARTY_CREDITS, status:VALID, product: IGS - Student System , description: Stores all Party Credits in Student Finance , implementation_dba_data: APPS.IGSFV_PARTY_CREDITS ,
Lookup Type: PE_US_COURSE_SUBJECT 12.1.1
product: IGS - Student System , meaning: SEVIS Major Minor Subject , description: Major Minor/Subject-Student and Exchange Visitor ,
Lookup Type: IMPORT_ERROR_CODE 12.1.1
product: IGS - Student System , meaning: Import Error Code , description: Import Error Code ,