Search Results france sabi kali is a




The PAY_RUN_TYPE_ORG_METHODS_F_EFC table is a critical component within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically designed to support the payroll processing framework. This table plays a pivotal role in defining the relationship between payroll run types, organizations, and the associated calculation methods, ensuring accurate and efficient payroll execution. Below is a detailed analysis of its structure, functionality, and significance in Oracle EBS.

Table Overview

The PAY_RUN_TYPE_ORG_METHODS_F_EFC table is part of the Oracle Payroll module and is primarily used to store configuration details that link payroll run types to organizational structures and their corresponding calculation methodologies. This table is essential for organizations that require flexible payroll processing rules based on different organizational hierarchies or geographic locations.

Key Columns and Their Significance

  • RUN_TYPE_ID: References the payroll run type, which defines the category of payroll processing (e.g., regular, bonus, or off-cycle).
  • ORGANIZATION_ID: Identifies the organizational unit (department, division, or legal entity) to which the payroll run type applies.
  • METHOD_CODE: Specifies the calculation method (e.g., "STANDARD," "HOURLY," or "COMMISSION") associated with the run type and organization.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE: Define the validity period of the configuration, enabling temporal flexibility in payroll processing rules.
  • LEGISLATION_CODE: Indicates the country or legislative group governing the payroll rules, ensuring compliance with regional labor laws.

Functional Role in Payroll Processing

The PAY_RUN_TYPE_ORG_METHODS_F_EFC table acts as a bridge between payroll run definitions (PAY_RUN_TYPES_F) and organizational structures (HR_ORGANIZATION_UNITS). By associating specific calculation methods with run types and organizations, it enables:
  • Customized Payroll Rules: Different departments or subsidiaries can have distinct payroll calculation logic (e.g., sales teams using commission-based methods).
  • Multi-Country Payroll: Supports varying legislative requirements by linking run types to country-specific organizations and methods.
  • Audit and Compliance: Tracks historical configurations via effective dating, aiding in regulatory audits.

Integration with Other Modules

This table interacts with several core Oracle EBS tables:
  • PAY_RUN_TYPES_F: Provides the master list of payroll run types.
  • HR_ORGANIZATION_UNITS: Supplies organizational hierarchy data.
  • PAY_CALCULATION_METHODS: Defines the calculation logic referenced by METHOD_CODE.

Technical Considerations

  • Indexing: Typically indexed on RUN_TYPE_ID, ORGANIZATION_ID, and EFFECTIVE_START_DATE for performance optimization.
  • Partitioning: In large implementations, partitioning by LEGISLATION_CODE or ORGANIZATION_ID may be employed.
  • EFC Suffix: Denotes compatibility with the "Encoded Fiscal Classification" feature, used in certain localized versions.

Conclusion

The PAY_RUN_TYPE_ORG_METHODS_F_EFC table is a cornerstone of Oracle EBS Payroll's configurability, enabling organizations to tailor payroll processing to diverse operational and regulatory needs. Its design reflects Oracle's emphasis on flexibility, compliance, and scalability in enterprise payroll solutions. Understanding this table is essential for payroll system administrators, implementers, and developers working with Oracle EBS 12.1.1 or 12.2.2.

  • Concurrent Program: PYFRMCTR 12.1.1

    execution_filename: PAY_FR_MIGRATE_TIME_ANALYSIS.MIGRATE ,  product: PAY - Payroll ,  user_name: PYFRMCTR ,  description: Migration of existing employees to use new Contract DDF for France. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PYFRUDUC 12.1.1

    execution_filename: pay_fr_ducs.recalculate_payment ,  product: PAY - Payroll ,  user_name: PYFRUDUC ,  description: Upload Payment Details (France) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PYFRUDUC 12.2.2

    execution_filename: pay_fr_ducs.recalculate_payment ,  product: PAY - Payroll ,  user_name: PYFRUDUC ,  description: Upload Payment Details (France) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PYFRMCTR 12.2.2

    execution_filename: PAY_FR_MIGRATE_TIME_ANALYSIS.MIGRATE ,  product: PAY - Payroll ,  user_name: PYFRMCTR ,  description: Migration of existing employees to use new Contract DDF for France. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PAYFRRUN 12.2.2

    execution_filename: PAY_FR_RUN_TYPES.REBUILD_RUN_TYPES ,  product: PAY - Payroll ,  user_name: PAYFRRUN ,  description: Rebuild Run Types (France) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PAYFRASD 12.1.1

    execution_filename: PAYFRASD ,  product: PAY - Payroll ,  user_name: PAYFRASD ,  description: Attestation ASSEDIC (France) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYFRRUN 12.1.1

    execution_filename: PAY_FR_RUN_TYPES.REBUILD_RUN_TYPES ,  product: PAY - Payroll ,  user_name: PAYFRRUN ,  description: Rebuild Run Types (France) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PAYFRASD 12.2.2

    execution_filename: PAYFRASD ,  product: PAY - Payroll ,  user_name: PAYFRASD ,  description: Attestation ASSEDIC (France) ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PYFRUPLD 12.2.2

    execution_filename: pay_fr_bal_upload.create_structure ,  product: PAY - Payroll ,  user_name: PYFRUPLD ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PYFRDADF 12.1.1

    execution_filename: PAY_FR_DADS_F_PKG.PROCESS ,  product: PAY - Payroll ,  user_name: PYFRDADF ,  description: French DADS-U File and Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PAYFRCJR 12.1.1

    execution_filename: PAYFRCJR ,  product: PAY - Payroll ,  user_name: PAYFRCJR ,  description: Contribution Journal Management Control Report for French Payroll ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PYFRADUC 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: PAYFRCJR 12.2.2

    execution_filename: PAYFRCJR ,  product: PAY - Payroll ,  user_name: PAYFRCJR ,  description: Contribution Journal Management Control Report for French Payroll ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PYFRUPLD 12.1.1

    execution_filename: pay_fr_bal_upload.create_structure ,  product: PAY - Payroll ,  user_name: PYFRUPLD ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PAYFRARC 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: PEFRPHMM 12.1.1

    execution_filename: PER_FR_ELECTION.PROCESS ,  product: PAY - Payroll ,  user_name: PEFRPHMM ,  description: Archive process for the workers election file ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PEFRPHMM 12.2.2

    execution_filename: PER_FR_ELECTION.PROCESS ,  product: PAY - Payroll ,  user_name: PEFRPHMM ,  description: Archive process for the workers election file ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PAYFRGTN 12.2.2

    execution_filename: PAYFRGTN ,  product: PAY - Payroll ,  user_name: PAYFRGTN ,  description: Gross To Net Management Control Report for French Payroll ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PYFRDADG 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: PYFRADUC 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: PYFRDADF 12.2.2

    execution_filename: PAY_FR_DADS_F_PKG.PROCESS ,  product: PAY - Payroll ,  user_name: PYFRDADF ,  description: French DADS-U File and Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PYFRDADG 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: PAYFRGTN 12.1.1

    execution_filename: PAYFRGTN ,  product: PAY - Payroll ,  user_name: PAYFRGTN ,  description: Gross To Net Management Control Report for French Payroll ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: PAYFRARC 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 , 

  • Lookup Type: PQP_US_COUNTRY_TRANSLATE 12.1.1

    product: PAY - Payroll ,  meaning: PQP_US_COUNTRY_TRANSLATE ,  description: Translates country from Oracle application to IRS country codes , 

  • Lookup Type: PQP_US_COUNTRY_TRANSLATE 12.2.2

    product: PAY - Payroll ,  meaning: PQP_US_COUNTRY_TRANSLATE ,  description: Translates country from Oracle application to IRS country codes , 

  • Table: PAY_RUN_TYPE_ORG_METHODS_F_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_RUN_TYPE_ORG_METHODS_F_EFC,  object_name:PAY_RUN_TYPE_ORG_METHODS_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_RUN_TYPE_ORG_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_RUN_TYPE_ORG_METHODS_F_EFC , 

  • Table: PAY_RUN_TYPE_ORG_METHODS_F_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_RUN_TYPE_ORG_METHODS_F_EFC,  object_name:PAY_RUN_TYPE_ORG_METHODS_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_RUN_TYPE_ORG_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_RUN_TYPE_ORG_METHODS_F_EFC , 

  • Table: PAY_PRE_PAYMENTS_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_PRE_PAYMENTS_EFC,  object_name:PAY_PRE_PAYMENTS_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_PRE_PAYMENTS table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_PRE_PAYMENTS_EFC , 

  • Table: PAY_PAYROLL_ACTIONS_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_PAYROLL_ACTIONS_EFC,  object_name:PAY_PAYROLL_ACTIONS_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_PAYROLL_ACTIONS table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_PAYROLL_ACTIONS_EFC , 

  • Table: PAY_PRE_PAYMENTS_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_PRE_PAYMENTS_EFC,  object_name:PAY_PRE_PAYMENTS_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_PRE_PAYMENTS table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_PRE_PAYMENTS_EFC , 

  • Table: PAY_PAYROLL_ACTIONS_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_PAYROLL_ACTIONS_EFC,  object_name:PAY_PAYROLL_ACTIONS_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_PAYROLL_ACTIONS table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_PAYROLL_ACTIONS_EFC , 

  • Table: PAY_ELEMENT_ENTRY_VALUES_F_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ELEMENT_ENTRY_VALUES_F_EFC,  object_name:PAY_ELEMENT_ENTRY_VALUES_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_ELEMENT_ENTRY_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_ELEMENT_ENTRY_VALUES_F_EFC , 

  • Table: PAY_PERSONAL_PAYMENT_METHO_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_PERSONAL_PAYMENT_METHO_EFC,  object_name:PAY_PERSONAL_PAYMENT_METHO_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_PERSONAL_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_PERSONAL_PAYMENT_METHO_EFC , 

  • Table: PAY_ORG_PAYMENT_METHODS_F_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ORG_PAYMENT_METHODS_F_EFC,  object_name:PAY_ORG_PAYMENT_METHODS_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_ORG_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_ORG_PAYMENT_METHODS_F_EFC , 

  • Table: PAY_COSTS_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_COSTS_EFC,  object_name:PAY_COSTS_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_COSTS table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_COSTS_EFC , 

  • Table: PAY_COSTS_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_COSTS_EFC,  object_name:PAY_COSTS_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_COSTS table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_COSTS_EFC , 

  • Table: PAY_BALANCE_TYPES_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_BALANCE_TYPES_EFC,  object_name:PAY_BALANCE_TYPES_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_BALANCE_TYPES table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_BALANCE_TYPES_EFC , 

  • Table: PAY_GRADE_RULES_F_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_GRADE_RULES_F_EFC,  object_name:PAY_GRADE_RULES_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_GRADE_RULES_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_GRADE_RULES_F_EFC , 

  • Table: PAY_PERSONAL_PAYMENT_METHO_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_PERSONAL_PAYMENT_METHO_EFC,  object_name:PAY_PERSONAL_PAYMENT_METHO_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_PERSONAL_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_PERSONAL_PAYMENT_METHO_EFC , 

  • Table: PAY_ELEMENT_TYPES_F_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ELEMENT_TYPES_F_EFC,  object_name:PAY_ELEMENT_TYPES_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_ELEMENT_TYPES_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_ELEMENT_TYPES_F_EFC , 

  • Table: PAY_LINK_INPUT_VALUES_F_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_LINK_INPUT_VALUES_F_EFC,  object_name:PAY_LINK_INPUT_VALUES_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_LINK_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_LINK_INPUT_VALUES_F_EFC , 

  • Table: PAY_RUN_RESULT_VALUES_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_RUN_RESULT_VALUES_EFC,  object_name:PAY_RUN_RESULT_VALUES_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_RUN_RESULT_VALUES table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_RUN_RESULT_VALUES_EFC , 

  • Table: PAY_ORG_PAYMENT_METHODS_F_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ORG_PAYMENT_METHODS_F_EFC,  object_name:PAY_ORG_PAYMENT_METHODS_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_ORG_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_ORG_PAYMENT_METHODS_F_EFC , 

  • Table: PAY_INPUT_VALUES_F_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_INPUT_VALUES_F_EFC,  object_name:PAY_INPUT_VALUES_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_INPUT_VALUES_F_EFC , 

  • Table: PAY_RUN_RESULT_VALUES_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_RUN_RESULT_VALUES_EFC,  object_name:PAY_RUN_RESULT_VALUES_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_RUN_RESULT_VALUES table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_RUN_RESULT_VALUES_EFC , 

  • Table: PAY_LINK_INPUT_VALUES_F_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_LINK_INPUT_VALUES_F_EFC,  object_name:PAY_LINK_INPUT_VALUES_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_LINK_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_LINK_INPUT_VALUES_F_EFC , 

  • Table: PAY_INPUT_VALUES_F_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_INPUT_VALUES_F_EFC,  object_name:PAY_INPUT_VALUES_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_INPUT_VALUES_F_EFC , 

  • Table: PAY_ELEMENT_ENTRY_VALUES_F_EFC 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ELEMENT_ENTRY_VALUES_F_EFC,  object_name:PAY_ELEMENT_ENTRY_VALUES_F_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_ELEMENT_ENTRY_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_ELEMENT_ENTRY_VALUES_F_EFC , 

  • Table: PAY_BALANCE_TYPES_EFC 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_BALANCE_TYPES_EFC,  object_name:PAY_BALANCE_TYPES_EFC,  status:VALID,  product: PAY - Payroll ,  description: This is a copy of the PAY_BALANCE_TYPES table which is populated by the EFC (Euro as a Functional Currency) process. ,  implementation_dba_data: HR.PAY_BALANCE_TYPES_EFC ,