Search Results person_extra_info_id
The deepseekAPPS.GHR_NON_SF52_EXTRA_INFO
table in Oracle E-Business Suite (EBS) versions 12.1.1 or 12.2.2 is a custom object that typically stores supplemental data related to non-SF52 personnel records, often extending the functionality of the Global Human Resources (GHR) module. Its dependencies on PAY_USER_TABLES
are critical for maintaining data integrity, validation, and reporting within the payroll and HRMS ecosystem. Below is a detailed analysis of these dependencies:
1. Structural Dependencies
ThePAY_USER_TABLES
is a core Oracle Payroll table that defines custom user-defined tables for payroll processing. deepseekAPPS.GHR_NON_SF52_EXTRA_INFO
may depend on it in the following ways:
- Foreign Key Relationships: If
GHR_NON_SF52_EXTRA_INFO
stores payroll-related attributes (e.g., custom earnings, deductions), it may referencePAY_USER_TABLES
via foreign keys to ensure alignment with payroll structures. - Table Definitions:
PAY_USER_TABLES
may define the metadata or schema for custom payroll tables, whichGHR_NON_SF52_EXTRA_INFO
could leverage for dynamic field validation or storage.
2. Functional Dependencies
The interaction between these tables often supports:- Payroll Calculations: If
GHR_NON_SF52_EXTRA_INFO
contains data influencing payroll (e.g., tax exemptions, allowances), it may rely onPAY_USER_TABLES
to map these values to payroll elements during batch processing. - Data Validation:
PAY_USER_TABLES
may enforce constraints or lookup values thatGHR_NON_SF52_EXTRA_INFO
must adhere to, ensuring consistency with payroll rules.
3. Integration Points
In EBS 12.1.1/12.2.2, dependencies manifest through:- APIs and PL/SQL Logic: Custom APIs or concurrent programs may join these tables to process HR-to-payroll data flows, especially for non-standard SF52 (federal) employees.
- Reports and Extracts: Payroll reports or regulatory filings (e.g., W-2, 1099) may query both tables to aggregate HR and payroll data for non-SF52 workers.
4. Impact of Customizations
IfGHR_NON_SF52_EXTRA_INFO
is customized:
- Schema Changes: Altering columns in
GHR_NON_SF52_EXTRA_INFO
may require updates toPAY_USER_TABLES
definitions to maintain compatibility. - Patch Considerations: Oracle patches to
PAY_USER_TABLES
(e.g., tax law updates) may necessitate regression testing for dependent custom objects.
5. Performance Implications
Joins between these tables in SQL queries or views can impact performance, especially during:- Payroll Runs: Large datasets in
GHR_NON_SF52_EXTRA_INFO
may slow down payroll calculations if indexed improperly. - Data Migrations: ETL processes moving data between HR and payroll modules must handle these dependencies to avoid referential integrity errors.
Conclusion
The dependency ofdeepseekAPPS.GHR_NON_SF52_EXTRA_INFO
on PAY_USER_TABLES
underscores the tight integration between HR and payroll in Oracle EBS. Proper indexing, validation logic, and testing are essential to maintain system stability, particularly in environments with heavy customizations or regulatory reporting requirements.
-
APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_USER_TABLES
12.1.1
-
APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_USER_TABLES
12.2.2
-
VIEW: HR.HR_PERSON_DEPLYMT_EITS#
12.2.2
-
APPS.PQH_PQIPED7_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.PER_PL_PERSON_EXTRA_INFO dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.PER_PL_PERSON_EXTRA_INFO dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.PQH_PQIPED5_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.PQH_PQIPED10_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.PQH_PROCESS_ACADEMIC_RANK SQL Statements
12.1.1
-
APPS.GHR_API dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.PQH_PQIPED9_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.PQH_PQIPED9_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.PQH_PQIPED11_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.PER_CN_EXTRA_PER_INFO_LEG_HOOK SQL Statements
12.1.1
-
APPS.PQH_PQIPED10_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.GHR_API dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.PQH_PQIPED6_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.PQH_PQIPED11_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.PQH_PROCESS_TENURE_STATUS SQL Statements
12.2.2
-
APPS.PER_CN_EXTRA_PER_INFO_LEG_HOOK SQL Statements
12.2.2
-
APPS.PQH_PROCESS_TENURE_STATUS SQL Statements
12.1.1
-
APPS.PQH_PROCESS_ACADEMIC_RANK SQL Statements
12.2.2
-
VIEW: HR.PER_PEOPLE_EXTRA_INFO_EFC#
12.2.2
-
APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_GENERAL
12.2.2
-
APPS.PER_CN_EXTRA_PER_INFO_LEG_HOOK dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.PER_CN_EXTRA_PER_INFO_LEG_HOOK dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.PQH_PROCESS_TENURE_STATUS dependencies on FND_DATE
12.1.1
-
APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_GENERAL
12.1.1
-
APPS.PQH_PROCESS_TENURE_STATUS dependencies on FND_DATE
12.2.2
-
APPS.PQH_PROCESS_ACADEMIC_RANK dependencies on FND_DATE
12.2.2
-
APPS.HR_PDE_SHD SQL Statements
12.1.1
-
APPS.PQH_PROCESS_ACADEMIC_RANK dependencies on FND_DATE
12.1.1
-
APPS.PQH_PQIPED8_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.PQH_PQIPED8_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.HR_PDE_SHD SQL Statements
12.2.2
-
APPS.GHR_SS_VIEWS_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
VIEW: HR.PER_PEOPLE_EXTRA_INFO#
12.2.2
-
APPS.GHR_SS_VIEWS_PKG dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
VIEW: APPS.PER_QH_EIT_V
12.2.2
-
APPS.PAY_GB_PRE_RTI_NINO dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.PE_PEI_UPD dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.GHR_MTO_INT dependencies on GHR_MT_PEOPLE_EI_V
12.2.2
-
VIEW: APPS.PER_QH_EIT_V
12.1.1
-
APPS.PE_PEI_SHD SQL Statements
12.1.1
-
APPS.PE_PEI_SHD SQL Statements
12.2.2
-
APPS.PE_PEI_UPD dependencies on PER_PEOPLE_EXTRA_INFO
12.2.2
-
APPS.PE_PEI_DEL dependencies on PER_PEOPLE_EXTRA_INFO
12.1.1
-
APPS.GHR_MTO_INT dependencies on GHR_MT_PEOPLE_EI_V
12.1.1