Search Results get help with file explorer in windows




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. , 

  • Table: PAY_ELEMENT_SETS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ELEMENT_SETS,  object_name:PAY_ELEMENT_SETS,  status:VALID,  product: PAY - Payroll ,  description: Groups elements to restrict payroll runs, customize windows, or as a distribution set for costs. ,  implementation_dba_data: HR.PAY_ELEMENT_SETS , 

  • Table: PAY_ELEMENT_SETS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ELEMENT_SETS,  object_name:PAY_ELEMENT_SETS,  status:VALID,  product: PAY - Payroll ,  description: Groups elements to restrict payroll runs, customize windows, or as a distribution set for costs. ,  implementation_dba_data: HR.PAY_ELEMENT_SETS , 

  • 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 , 

  • Lookup Type: PAY_AC_QTM_PLATFORMS 12.1.1

    product: PAY - Payroll ,  meaning: PAY_AC_QTM_PLATFORMS ,  description: List of Supported Platforms for Quantum , 

  • Lookup Type: PAY_AC_QTM_PLATFORMS 12.2.2

    product: PAY - Payroll ,  meaning: PAY_AC_QTM_PLATFORMS ,  description: List of Supported Platforms for Quantum , 

  • Concurrent Program: PYNOEERSTCR 12.2.2

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOEERSTCEFT 12.2.2

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOEERSTCEFT 12.1.1

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOEERCNTEFT 12.2.2

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOSSTPDF 12.1.1

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOSSTEFT 12.2.2

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOSSTPDF 12.2.2

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOSSTEFT 12.1.1

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOEERSTCR 12.1.1

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOEERCNTR 12.2.2

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOEERCNTR 12.1.1

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PYNOEERCNTEFT 12.1.1

    execution_filename: PayPDFGen ,  product: PAY - Payroll ,  user_name: PYXMLEMG ,  description: Payroll Message Report (PDF) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Lookup Type: DK_PPROC_LABELS 12.1.1

    product: PAY - Payroll ,  meaning: Labels to be used for fields in Payment File for Denmark. ,  description: Labels to be used for fields in Payment File for Denmark. , 

  • Lookup Type: DK_PPROC_LABELS 12.2.2

    product: PAY - Payroll ,  meaning: Labels to be used for fields in Payment File for Denmark. ,  description: Labels to be used for fields in Payment File for Denmark. , 

  • 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 , 

  • Table: PAY_FILE_DETAILS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_FILE_DETAILS,  object_name:PAY_FILE_DETAILS,  status:VALID,  product: PAY - Payroll ,  description: Report file details that have been saved in the system ,  implementation_dba_data: HR.PAY_FILE_DETAILS , 

  • 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 , 

  • Table: PAY_FILE_DETAILS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_FILE_DETAILS,  object_name:PAY_FILE_DETAILS,  status:VALID,  product: PAY - Payroll ,  description: Report file details that have been saved in the system ,  implementation_dba_data: HR.PAY_FILE_DETAILS , 

  • Table: PAY_NL_IZA_UPLD_STATUS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_NL_IZA_UPLD_STATUS,  object_name:PAY_NL_IZA_UPLD_STATUS,  status:VALID,  product: PAY - Payroll ,  description: Holds the Status of the Data Records in the Processed IZA File ,  implementation_dba_data: HR.PAY_NL_IZA_UPLD_STATUS , 

  • Table: PAY_NL_IZA_UPLD_STATUS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_NL_IZA_UPLD_STATUS,  object_name:PAY_NL_IZA_UPLD_STATUS,  status:VALID,  product: PAY - Payroll ,  description: Holds the Status of the Data Records in the Processed IZA File ,  implementation_dba_data: HR.PAY_NL_IZA_UPLD_STATUS , 

  • 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 ,