Search Results unit of measure




The PAY_COIN_ANAL_ELEMENTS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Oracle Payroll module, specifically designed to store analytical information related to costing and accounting entries for payroll elements. This table plays a pivotal role in the integration between payroll processing and general ledger (GL) accounting, ensuring accurate financial reporting and compliance with organizational accounting policies.

Purpose and Functionality

The primary purpose of PAY_COIN_ANAL_ELEMENTS is to store detailed costing information for payroll elements, enabling the system to generate appropriate accounting entries during payroll runs. It acts as a bridge between payroll calculations and financial accounting by capturing data such as cost allocation keys, natural account segments, and other analytical attributes required for GL postings. This table is particularly significant in multi-organization environments where payroll costs must be distributed across different cost centers, departments, or projects.

Key Columns and Structure

The table includes several important columns that define its functionality:
  • ANALYSIS_TYPE_ID: Identifies the type of analysis (e.g., cost center, project, account code).
  • ELEMENT_TYPE_ID: Links to the payroll element being analyzed.
  • SEGMENT1 to SEGMENT30: Stores flexfield segments for accounting flexfield structures.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE: Define the validity period of the analysis setup.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Standard Oracle audit columns.

Integration with Other Modules

PAY_COIN_ANAL_ELEMENTS integrates with multiple Oracle EBS modules:
  • Oracle General Ledger: Provides the accounting segments for payroll journal entries.
  • Oracle Projects: Enables project costing when payroll expenses need to be charged to projects.
  • Oracle HRMS: Links to employee assignments and organizational structures.

Technical Implementation

The table is implemented as a standard Oracle database table with appropriate indexes on key columns like ELEMENT_TYPE_ID and ANALYSIS_TYPE_ID for performance optimization. It participates in Oracle's Application Object Library (AOL) framework, supporting flexfields and value sets for segment validation.

Business Process Flow

In typical payroll processing:
  1. Payroll administrators define costing rules for elements through the Payroll Costing screen.
  2. The system stores these rules in PAY_COIN_ANAL_ELEMENTS.
  3. During payroll runs, the costing engine references this table to determine proper account combinations.
  4. Resulting accounting entries are generated and transferred to GL.

Customization Considerations

While Oracle provides standard functionality through this table, organizations often need to customize:
  • Additional validation rules for accounting segments
  • Complex cost allocation formulas
  • Integration with third-party systems
Customizations should be implemented carefully to maintain upgrade compatibility and system integrity.

Performance Implications

As payroll systems process large volumes of transactions, the PAY_COIN_ANAL_ELEMENTS table must be properly indexed and maintained. Organizations with complex costing requirements should consider:
  • Regular statistics gathering
  • Partitioning strategies for large implementations
  • Archiving historical data

Conclusion

The PAY_COIN_ANAL_ELEMENTS table is a fundamental component of Oracle Payroll's costing functionality in EBS 12.1.1 and 12.2.2. Its proper configuration and maintenance are essential for accurate financial reporting and compliance. Understanding its structure and relationships with other system components enables organizations to effectively manage payroll accounting processes while supporting complex business requirements.

  • Lookup Type: W2 KIND OF EMPLOYER 12.2.2

    product: PAY - Payroll ,  meaning: W2 Kind of Employer values ,  description: Lookups to be used with the Year End Process and Views , 

  • Lookup Type: PAY_PIT_PERIOD_TYPE 12.2.2

    product: PAY - Payroll ,  meaning: Payroll Point In Time Definition Period Type ,  description: Payroll Point In Time Definition Period Type , 

  • Lookup Type: PAY_PIT_PERIOD_TYPE 12.1.1

    product: PAY - Payroll ,  meaning: Payroll Point In Time Definition Period Type ,  description: Payroll Point In Time Definition Period Type , 

  • Table: PAY_COIN_ANAL_ELEMENTS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_COIN_ANAL_ELEMENTS,  object_name:PAY_COIN_ANAL_ELEMENTS,  status:VALID,  product: PAY - Payroll ,  description: Monetary unit quantities for automatic make-up of cash payments. ,  implementation_dba_data: HR.PAY_COIN_ANAL_ELEMENTS , 

  • Table: PAY_COIN_ANAL_ELEMENTS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_COIN_ANAL_ELEMENTS,  object_name:PAY_COIN_ANAL_ELEMENTS,  status:VALID,  product: PAY - Payroll ,  description: Monetary unit quantities for automatic make-up of cash payments. ,  implementation_dba_data: HR.PAY_COIN_ANAL_ELEMENTS , 

  • Lookup Type: SE_REQUEST_LEVEL 12.1.1

    product: PAY - Payroll ,  meaning: General Request level , 

  • Lookup Type: SE_REQUEST_LEVEL 12.2.2

    product: PAY - Payroll ,  meaning: General Request level , 

  • View: PAY_ELEMENT_LINKS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PAY.PAY_ELEMENT_LINKS_V,  object_name:PAY_ELEMENT_LINKS_V,  status:VALID,  product: PAY - Payroll ,  description: Used to support user interface ,  implementation_dba_data: APPS.PAY_ELEMENT_LINKS_V , 

  • View: PAY_ELEMENT_LINKS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PAY.PAY_ELEMENT_LINKS_V,  object_name:PAY_ELEMENT_LINKS_V,  status:VALID,  product: PAY - Payroll ,  description: Used to support user interface ,  implementation_dba_data: APPS.PAY_ELEMENT_LINKS_V , 

  • Lookup Type: GB_PENSION_LETTERS 12.2.2

    product: PAY - Payroll ,  meaning: Standard Letters for Pensions Automatic Enrolment ,  description: Standard Letters for Pensions Automatic Enrolment , 

  • Concurrent Program: PAYJPHID 12.2.2

    execution_filename: PAYJPHID ,  product: PAY - Payroll ,  user_name: PAYJPHID ,  description: Payroll Report (Notification of Dependents for Health Insurance / Notification of Type 3 Insured for National Pension) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPHID 12.1.1

    execution_filename: PAYJPHID ,  product: PAY - Payroll ,  user_name: PAYJPHID ,  description: Payroll Report (Notification of Dependents for Health Insurance / Notification of Type 3 Insured for National Pension) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Lookup Type: GB_PENSION_LET_MODES 12.2.2

    product: PAY - Payroll ,  meaning: Modes of Generation of Letters ,  description: Modes of Generation of Letters , 

  • Lookup Type: SE_WAGES_REPORT 12.2.2

    product: PAY - Payroll ,  meaning: SE_WAGES_REPORT ,  description: Swedish Wages Reports Parameters , 

  • Lookup Type: SE_WAGES_REPORT 12.1.1

    product: PAY - Payroll ,  meaning: SE_WAGES_REPORT ,  description: Swedish Wages Reports Parameters , 

  • Lookup Type: FR_DADS_END_REASON 12.2.2

    product: PAY - Payroll ,  meaning: End Date reasons for DADS-U , 

  • Lookup Type: FR_DADS_END_REASON 12.1.1

    product: PAY - Payroll ,  meaning: End Date reasons for DADS-U , 

  • 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: 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: FR_DADS_PROF_STATUS_CODE 12.2.2

    product: PAY - Payroll ,  meaning: Professional Status Code for DADS-U , 

  • Lookup Type: FR_DADS_PROF_STATUS_CODE 12.1.1

    product: PAY - Payroll ,  meaning: Professional Status Code for DADS-U , 

  • Lookup Type: PAY_CA_RL1_FOOTNOTES 12.2.2

    product: PAY - Payroll ,  meaning: RL1 footnotes ,  description: Footnotes for RL1 slips , 

  • Concurrent Program: PYZASOTC 12.1.1

    execution_filename: PYZASOTC ,  product: PAY - Payroll ,  user_name: PYZASOTC ,  description: Summary of Tax Certificates ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PYZASOTC 12.2.2

    execution_filename: PYZASOTC ,  product: PAY - Payroll ,  user_name: PYZASOTC ,  description: Summary of Tax Certificates ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PYNZSOE 12.2.2

    execution_filename: PYNZSOE ,  product: PAY - Payroll ,  user_name: PYNZSOE ,  description: Statement Of Earnings (New Zealand) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Lookup Type: FR_GI_TYPES 12.2.2

    product: PAY - Payroll ,  meaning: Sickness Guarantee Types , 

  • Concurrent Program: PYNZSOE 12.1.1

    execution_filename: PYNZSOE ,  product: PAY - Payroll ,  user_name: PYNZSOE ,  description: Statement Of Earnings (New Zealand) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPDEP 12.2.2

    execution_filename: PAYJPDEP ,  product: PAY - Payroll ,  user_name: PAYJPDEP ,  description: Payroll Report (Notification of Deduction for Dependents) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Lookup Type: FR_GI_TYPES 12.1.1

    product: PAY - Payroll ,  meaning: Sickness Guarantee Types , 

  • Concurrent Program: PAYJPFLI 12.1.1

    execution_filename: PAYJPFLI ,  product: PAY - Payroll ,  user_name: PAYJPFLI ,  description: Payroll Report (Final Notice of Fixed Labor Ins Fee) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPDEP 12.1.1

    execution_filename: PAYJPDEP ,  product: PAY - Payroll ,  user_name: PAYJPDEP ,  description: Payroll Report (Notification of Deduction for Dependents) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPFLI 12.2.2

    execution_filename: PAYJPFLI ,  product: PAY - Payroll ,  user_name: PAYJPFLI ,  description: Payroll Report (Final Notice of Fixed Labor Ins Fee) ,  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: PAYJPSID 12.2.2

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

  • Concurrent Program: PAYJPSID 12.1.1

    execution_filename: PAYJPSID ,  product: PAY - Payroll ,  user_name: PAYJPSID ,  description: Payroll Report (Notification of Disqualification for Health Ins/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: PAYJPSIQ 12.1.1

    execution_filename: PAYJPSIQ ,  product: PAY - Payroll ,  user_name: PAYJPSIQ ,  description: Payroll Report (Notification of Qualification for Health Ins/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: PAYJPBON 12.1.1

    execution_filename: PAYJPBON ,  product: PAY - Payroll ,  user_name: PAYJPBON ,  description: Payroll Report (Check List of Bonus Payment Notification for Health Ins/Welfare Pension Ins) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYJPBON 12.2.2

    execution_filename: PAYJPBON ,  product: PAY - Payroll ,  user_name: PAYJPBON ,  description: Payroll Report (Check List of Bonus Payment Notification for Health Ins/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: 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: 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: PAYJPSIQ 12.2.2

    execution_filename: PAYJPSIQ ,  product: PAY - Payroll ,  user_name: PAYJPSIQ ,  description: Payroll Report (Notification of Qualification for Health Ins/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 , 

  • Lookup Type: DK_SALARY_BASIS_MKODE 12.1.1

    product: PAY - Payroll ,  meaning: DK_SALARY_BASIS_MKODE ,  description: Lookup to select Employee Code for Salary Basis , 

  • Lookup Type: DK_SALARY_BASIS_MKODE 12.2.2

    product: PAY - Payroll ,  meaning: DK_SALARY_BASIS_MKODE ,  description: Lookup to select Employee Code for Salary Basis , 

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