Search Results pay_all_payrolls_f
The PAY_ALL_PAYROLLS_F
table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Oracle Payroll module, serving as the foundation for payroll processing and management. This table stores comprehensive information about payroll definitions, including their attributes, processing rules, and associations with other payroll-related entities. Below is a detailed breakdown of its structure, purpose, and significance in Oracle EBS.
Overview and Purpose
ThePAY_ALL_PAYROLLS_F
table is a flexfield-enabled entity that stores master data for payrolls within an organization. It acts as a central repository for payroll definitions, enabling organizations to configure multiple payrolls with distinct characteristics, such as payment frequencies, consolidation sets, and legal entities. This table supports date-effective records, allowing historical tracking of payroll changes over time, which is essential for compliance and auditing purposes.
Key Columns and Their Significance
- PAYROLL_ID: The primary key, uniquely identifying each payroll record.
- PAYROLL_NAME: A user-defined name for the payroll (e.g., "Monthly Payroll" or "Weekly Payroll").
- BUSINESS_GROUP_ID: Links the payroll to a specific business group, ensuring data isolation in multi-org environments.
- PERIOD_TYPE: Defines the frequency of payroll runs (e.g., monthly, bi-weekly, or weekly).
- CONSOLIDATION_SET_ID: Associates the payroll with a consolidation set, which groups payrolls for reporting or processing.
- DATE_EFFECTIVE and DATE_END: Enables date tracking, allowing payroll definitions to evolve over time without losing historical data.
- LEGISLATION_CODE: Specifies the country or legislative framework governing the payroll (e.g., "US" or "GB").
Functional Role in Payroll Processing
ThePAY_ALL_PAYROLLS_F
table plays a pivotal role in payroll execution. It serves as the backbone for:
- Payroll Definition: Organizations can define multiple payrolls with varying frequencies, tax rules, and payment methods.
- Payroll Run Scheduling: The
PERIOD_TYPE
column determines how often payroll is processed, while date-effective columns ensure accurate scheduling. - Legal Compliance: By linking payrolls to legislation codes, the table ensures adherence to regional tax and labor laws.
- Reporting and Consolidation: Payrolls can be grouped into consolidation sets for streamlined reporting and financial reconciliation.
Integration with Other Modules
This table integrates with several Oracle EBS modules, including:- Oracle HRMS: Links payrolls to employees via assignments and organizational hierarchies.
- Oracle General Ledger (GL): Payroll results are transferred to GL for accounting purposes.
- Oracle Time and Labor (OTL): Payrolls may reference time entry rules for calculating wages.
Technical Considerations
- Flexfields: The table supports descriptive flexfields (DFFs), allowing organizations to capture custom attributes.
- Indexing: Key columns like
PAYROLL_ID
andBUSINESS_GROUP_ID
are indexed for performance. - APIs Oracle provides PL/SQL APIs (e.g.,
PAY_PAYROLL_PKG
) to manipulate payroll data programmatically.
Conclusion
ThePAY_ALL_PAYROLLS_F
table is indispensable in Oracle EBS Payroll, providing the structural foundation for defining, processing, and managing payrolls. Its date-effective design, integration capabilities, and compliance features make it a cornerstone of payroll operations in organizations using Oracle EBS 12.1.1 or 12.2.2. Understanding its structure and relationships is essential for payroll administrators, developers, and implementers.
-
Table: PAY_ALL_PAYROLLS_F
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ALL_PAYROLLS_F, object_name:PAY_ALL_PAYROLLS_F, status:VALID, product: PAY - Payroll , description: Payroll group definitions. , implementation_dba_data: HR.PAY_ALL_PAYROLLS_F ,
-
Table: PAY_ALL_PAYROLLS_F
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_ALL_PAYROLLS_F, object_name:PAY_ALL_PAYROLLS_F, status:VALID, product: PAY - Payroll , description: Payroll group definitions. , implementation_dba_data: HR.PAY_ALL_PAYROLLS_F ,
-
APPS.BEN_COBRA_REQUIREMENTS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PER_QH_MAINTAIN_QUERY dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_IE_LE_MIGRATE dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_JP_WIC_PKG dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_BAL_ADJUST dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.SSP_ERN_BUS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_US_RULES dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PER_ASG_BUS2 dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_IE_P35_XML_PKG dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.BEN_EFC_ADJUSTMENTS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_IE_P60XML dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_IE_PAYE_PKG dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.HR_PAYROLLS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.BEN_EPY_BUS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PER_PAY_PROPOSALS_POPULATE dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.HR_ASSIGNMENT dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_IN_TAX_UTILS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.HR_US_FF_UDF1 dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PER_POSITION_MAPPING dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_ZA_EOY_VAL dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PSB_POSITION_CONTROL_PVT dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_GB_PAYROLL_RULES dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.HR_SECURITY_INTERNAL dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.HR_PAYROLLS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.HR_ASSIGNMENT dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_DK_PR_ELE dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.BEN_DERIVE_FACTORS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_PAY_INS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PSP_GENERAL dependencies on PAY_ALL_PAYROLLS_F
12.1.1
-
APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.PAY_IE_PRSI dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.PYUDET dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.BEN_BATCH_UTILS dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.PAY_CA_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.PAY_OPM_BUS dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.PER_ASG_AGGR dependencies on PAY_ALL_PAYROLLS_F
12.2.2
-
APPS.PAY_PAYROLLS_F_PKG dependencies on PAY_ALL_PAYROLLS_F
12.2.2