Search Results open swf file




The PAY_Tables.html file in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 refers to the documentation or metadata describing the key tables used in the Payroll module (PAY). Oracle Payroll is a critical component of Oracle HRMS (Human Resource Management System), handling complex payroll processing, tax calculations, and compliance reporting. The PAY tables store transactional and configuration data necessary for payroll runs, deductions, earnings, and statutory reporting. Below is a detailed breakdown of the structure, purpose, and significance of these tables in Oracle EBS 12.1.1 and 12.2.2.

1. Core PAY Tables Overview

The PAY tables are categorized into logical groups based on functionality:
  • Payroll Definitions (PAY_PAYROLLS_F): Stores payroll master data, including frequency, payment methods, and consolidation sets.
  • Element Definitions (PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F): Defines earnings, deductions, and benefits elements linked to employees.
  • Employee Assignments (PAY_ALL_PAYROLLS_F, PAY_ASSIGNMENT_ACTIONS): Tracks payroll assignments and processed actions (e.g., prepayments, retropay).
  • Payroll Results (PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES): Stores calculated payroll results, including gross-to-net values.
  • Tax and Compliance (PAY_TAXABILITY_RULES, PAY_US_EMP_FED_TAX_RULES_F): Manages tax rules, jurisdiction codes, and statutory requirements.

2. Key Tables and Relationships

  1. PAY_PAYROLLS_F: Primary table for payroll definitions, linked to PER_ALL_ASSIGNMENTS_F (HR assignments) and PAY_ASSIGNMENT_ACTIONS.
  2. PAY_ELEMENT_TYPES_F: Defines elements (e.g., salary, bonuses) with attributes like classification, processing rules, and input values.
  3. PAY_RUN_RESULTS: Captures output of payroll runs, referencing PAY_ASSIGNMENT_ACTIONS and storing values like hours, amounts, and tax withholdings.
  4. PAY_BALANCE_TYPES: Manages balance dimensions (e.g., YTD, QTD) for payroll calculations and reporting.

3. Functional Significance

  • Payroll Processing: Tables like PAY_RUN_RESULTS and PAY_ASSIGNMENT_ACTIONS are critical for the payroll engine to process earnings, deductions, and taxes.
  • Retroactive Adjustments: PAY_RETRO_PAYMENTS and PAY_RETRO_COMPONENTS handle backdated calculations.
  • Compliance: Tax tables (PAY_TAXABILITY_RULES) ensure adherence to regional regulations.

4. Technical Considerations

  • Partitioning: In EBS 12.2.2, large tables like PAY_RUN_RESULTS may be partitioned for performance.
  • Indexing: Key columns (e.g., ASSIGNMENT_ID, PAYROLL_ID) are indexed for efficient querying.
  • Audit Columns: Most tables include CREATION_DATE, LAST_UPDATE_DATE, and LAST_UPDATED_BY for tracking changes.

5. Integration Points

The PAY tables integrate with:
  • Oracle HR (PER_* tables): Employee and assignment data.
  • Oracle General Ledger (GL_* tables): Payroll accounting entries.
  • Oracle Time and Labor (OTL): Timecard data for payroll inputs.

6. Customization and Extensions

Custom Fast Formulas or PL/SQL scripts often reference PAY tables for:
  • Complex element calculations.
  • Custom reporting via BI Publisher or Oracle Reports.
  • Data fixes via AD_ZD patches in 12.2.2.

Conclusion

The PAY_Tables.html documentation provides a blueprint for understanding Oracle Payroll's data model in EBS 12.1.1/12.2.2. Mastery of these tables is essential for payroll implementations, troubleshooting, and optimizations. Their design supports scalability, compliance, and integration with other EBS modules, making them foundational to payroll operations.

  • File: PAYROLL_R12_ERD.pdf 12.1.1

    product: PAY - Payroll ,  size: 33.81 KBytes ,  file_type: PDF Diagram , 

  • File: PAY_Dependencies.html 12.1.1

    product: PAY - Payroll ,  size: 1.264 MBytes ,  file_type: HTML Report ,  description: PAY_Dependencies.html is an html report that documents dependencies to tables and views in the PAY product. , 

  • File: PAYROLL_R12_ERD.pdf 12.2.2

    product: PAY - Payroll ,  size: 33.81 KBytes ,  file_type: PDF Diagram , 

  • File: PAYROLL_R121_PROCESS_EVENTS.pdf 12.2.2

    product: PAY - Payroll ,  size: 7.679 KBytes ,  file_type: PDF Diagram , 

  • File: Payroll_ERD.pdf 12.1.1

    product: PAY - Payroll ,  size: 43.358 KBytes ,  file_type: PDF Diagram , 

  • File: PAY_Tables.html 12.1.1

    product: PAY - Payroll ,  size: 7.28 MBytes ,  file_type: HTML Report ,  description: PAY_Tables.html is an html report that documents the table and view definitions for the PAY product. , 

  • File: PAYProduct_Dependencies.html 12.2.2

    product: PAY - Payroll ,  size: 47.036 KBytes ,  file_type: HTML Report ,  description: PAYProduct_Dependencies.html is an html report that documentsexternal dependencies to tables and views in the PAY product. , 

  • File: PAYProduct_Dependencies.html 12.1.1

    product: PAY - Payroll ,  size: 81.215 KBytes ,  file_type: HTML Report ,  description: PAYProduct_Dependencies.html is an html report that documentsexternal dependencies to tables and views in the PAY product. , 

  • File: PAY_Tables.html 12.2.2

    product: PAY - Payroll ,  size: 7.68 MBytes ,  file_type: HTML Report ,  description: PAY_Tables.html is an html report that documents the table and view definitions for the PAY product. , 

  • File: PAYROLL_R121_RUN_TYPES.pdf 12.2.2

    product: PAY - Payroll ,  size: 5.531 KBytes ,  file_type: PDF Diagram , 

  • File: PAYROLL_R121_PROCESS_EVENTS.pdf 12.1.1

    product: PAY - Payroll ,  size: 7.679 KBytes ,  file_type: PDF Diagram , 

  • File: PAYROLL_R121_RUN_TYPES.pdf 12.1.1

    product: PAY - Payroll ,  size: 5.531 KBytes ,  file_type: PDF Diagram , 

  • File: Payroll_ERD.pdf 12.2.2

    product: PAY - Payroll ,  size: 43.358 KBytes ,  file_type: PDF Diagram , 

  • File: PAY_Dependencies.html 12.2.2

    product: PAY - Payroll ,  size: 1.141 MBytes ,  file_type: HTML Report ,  description: PAY_Dependencies.html is an html report that documents dependencies to tables and views in the PAY product. , 

  • Concurrent Program: PAYKRSEF 12.2.2

    execution_filename: pay_kr_nonstat_spay_efile.submit_efile ,  product: PAY - Payroll ,  user_name: KR Non-Statutory Separation Pay E-File (PL/SQL) ,  description: KR Non-Statutory Separation Pay E-File (PL/SQL) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PAYKRSEF_NS 12.1.1

    execution_filename: pay_kr_nonstat_spay_efile.submit_efile ,  product: PAY - Payroll ,  user_name: KR Non-Statutory Separation Pay E-File (PL/SQL) ,  description: KR Non-Statutory Separation Pay E-File (PL/SQL) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PAYKRSEF_NS 12.2.2

    execution_filename: pay_kr_nonstat_spay_efile.submit_efile ,  product: PAY - Payroll ,  user_name: KR Non-Statutory Separation Pay E-File (PL/SQL) ,  description: KR Non-Statutory Separation Pay E-File (PL/SQL) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PYKRYEAM_DON 12.1.1

    execution_filename: PAY_KR_YEA_DON_EFILE_CONC_PKG.SUBMIT_EFILE ,  product: PAY - Payroll ,  user_name: KR Year End Adjustment Donation E-File ,  description: KR Detailed Donation E-File for YEA ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PYKRYEAM_DON 12.2.2

    execution_filename: PAY_KR_YEA_DON_EFILE_CONC_PKG.SUBMIT_EFILE ,  product: PAY - Payroll ,  user_name: KR Year End Adjustment Donation E-File ,  description: KR Detailed Donation E-File for YEA ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PAYJPMAG 12.1.1

    execution_filename: PAYJPMAG ,  product: PAY - Payroll ,  user_name: PAYJPMAG ,  description: Generate Direct Deposit File ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPMAG 12.2.2

    execution_filename: PAYJPMAG ,  product: PAY - Payroll ,  user_name: PAYJPMAG ,  description: Generate Direct Deposit File ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPWTM 12.1.1

    execution_filename: PAYJPWTM ,  product: PAY - Payroll ,  user_name: PAYJPWTM ,  description: Payroll Report (Create File-Tax Withheld Report) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPWTM 12.2.2

    execution_filename: PAYJPWTM ,  product: PAY - Payroll ,  user_name: PAYJPWTM ,  description: Payroll Report (Create File-Tax Withheld Report) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPCAD 12.1.1

    execution_filename: PAYJPCAD ,  product: PAY - Payroll ,  user_name: PAYJPCAD ,  description: Payroll Report (Create File-Notification Change Address for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPSDD 12.1.1

    execution_filename: PAYJPSDD ,  product: PAY - Payroll ,  user_name: PAYJPSDD ,  description: Payroll Report (Create File-Notification of Disqualification for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPSTT 12.1.1

    execution_filename: PAYJPSMT ,  product: PAY - Payroll ,  user_name: PAYJPSMT ,  description: Payroll Report (Create File-Notification of Santei for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPSQD 12.1.1

    execution_filename: PAYJPSQD ,  product: PAY - Payroll ,  user_name: PAYJPSQD ,  description: Payroll Report (Create File-Notification of Qualification for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPGMT 12.1.1

    execution_filename: PAYJPGMT ,  product: PAY - Payroll ,  user_name: PAYJPGMT ,  description: Payroll Report (Create File-Notification of Geppen for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPCAD 12.2.2

    execution_filename: PAYJPCAD ,  product: PAY - Payroll ,  user_name: PAYJPCAD ,  description: Payroll Report (Create File-Notification Change Address for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPSQD 12.2.2

    execution_filename: PAYJPSQD ,  product: PAY - Payroll ,  user_name: PAYJPSQD ,  description: Payroll Report (Create File-Notification of Qualification for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPGMT 12.2.2

    execution_filename: PAYJPGMT ,  product: PAY - Payroll ,  user_name: PAYJPGMT ,  description: Payroll Report (Create File-Notification of Geppen for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPSDD 12.2.2

    execution_filename: PAYJPSDD ,  product: PAY - Payroll ,  user_name: PAYJPSDD ,  description: Payroll Report (Create File-Notification of Disqualification for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPSMT 12.2.2

    execution_filename: PAYJPSMT ,  product: PAY - Payroll ,  user_name: PAYJPSMT ,  description: Payroll Report (Create File-Notification of Santei for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPSTT 12.2.2

    execution_filename: PAYJPSMT ,  product: PAY - Payroll ,  user_name: PAYJPSMT ,  description: Payroll Report (Create File-Notification of Santei for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPSMT 12.1.1

    execution_filename: PAYJPSMT ,  product: PAY - Payroll ,  user_name: PAYJPSMT ,  description: Payroll Report (Create File-Notification of Santei for Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Lookup Type: NO_PAYMENT_PROCESS_LABELS 12.2.2

    product: PAY - Payroll ,  meaning: Norwegian Payment Process Labels ,  description: Lookup to hold values for NO Payment Process Labels , 

  • Lookup Type: NO_PAYMENT_PROCESS_LABELS 12.1.1

    product: PAY - Payroll ,  meaning: Norwegian Payment Process Labels ,  description: Lookup to hold values for NO Payment Process Labels , 

  • Concurrent Program: PAYJPMAG_XML 12.1.1

    product: PAY - Payroll ,  user_name: Generate Direct Deposit File (XML) ,  description: Generate Direct Deposit File ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYZAIRPM_XML 12.2.2

    product: PAY - Payroll ,  user_name: Electronic Tax File ,  description: Electronic Tax File ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PAYJPMAG_XML 12.2.2

    product: PAY - Payroll ,  user_name: Generate Direct Deposit File (XML) (Obsolete) ,  description: Generate Direct Deposit File (Obsolete) ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Lookup Type: PAY_US_SQWL_REPORT_OPTIONS 12.2.2

    product: PAY - Payroll ,  meaning: SQWL Report Output Options , 

  • Concurrent Program: PAYJPWTM_XML 12.1.1

    product: PAY - Payroll ,  user_name: Payroll Report (Create File-Tax Withheld Report) (XML) ,  description: Payroll Report (Create File-Tax Withheld Report) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYZAIRPM 12.1.1

    execution_filename: PYUMAG ,  product: PAY - Payroll ,  user_name: PYUMAG ,  description: Magnetic Report ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: PAYJPWTM_XML 12.2.2

    product: PAY - Payroll ,  user_name: Payroll Report (Create File-Tax Withheld Report) (XML) (Obsolete) ,  description: Payroll Report (Create File-Tax Withheld Report) (Obsolete) ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYSGIA8A 12.1.1

    execution_filename: PYUGEN ,  product: PAY - Payroll ,  user_name: PYUGEN ,  description: Generic Payroll Execution Process ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: PYSGIR8A 12.1.1

    execution_filename: PYUGEN ,  product: PAY - Payroll ,  user_name: PYUGEN ,  description: Generic Payroll Execution Process ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: PYSGIA8B 12.1.1

    execution_filename: PYUGEN ,  product: PAY - Payroll ,  user_name: PYUGEN ,  description: Generic Payroll Execution Process ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: PYSGIA8B 12.2.2

    execution_filename: PYUGEN ,  product: PAY - Payroll ,  user_name: PYUGEN ,  description: Generic Payroll Execution Process ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: PAY_NL_CBS_FILE 12.1.1

    execution_filename: PYUGEN ,  product: PAY - Payroll ,  user_name: PYUGEN ,  description: Generic Payroll Execution Process ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: PYZAUIFA 12.2.2

    execution_filename: PYUGEN ,  product: PAY - Payroll ,  user_name: PYUGEN ,  description: Generic Payroll Execution Process ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned ,