Search Results fixed

PAY_REPORT_FORMAT_MAPPINGS_F in Oracle EBS 12.1.1/12.2.2

Table Purpose: The PAY_REPORT_FORMAT_MAPPINGS_F table serves as a critical component in Oracle E-Business Suite's Payroll module, specifically designed to store mapping relationships between report formats and their associated parameters or components.

Technical Details

Table Type: Foundation table in Payroll module
Primary Key: Typically includes columns like REPORT_FORMAT_MAPPING_ID
Effective Dating: The '_F' suffix indicates this is an effective-dated table
Module Association: Primarily used by Oracle Payroll (PY)

Key Functional Areas

The table supports several payroll reporting functions:

Mapping report templates to specific output formats
Defining parameter mappings for payroll reports
Storing configuration data for report generation
Maintaining version control through effective dating

Important Columns

While the exact column structure may vary between versions, typical columns include:

REPORT_FORMAT_MAPPING_ID: Unique identifier for each mapping
REPORT_TYPE: Classification of the report being mapped
SOURCE_FORMAT: Original format identifier
TARGET_FORMAT: Destination format identifier
MAPPING_PARAMETERS: Configuration details for the transformation
EFFECTIVE_START_DATE/EFFECTIVE_END_DATE: Date range for which the mapping is valid
CREATED_BY/LAST_UPDATED_BY: Audit columns tracking changes

Integration Points

The table interacts with several other Oracle EBS components:

Payroll Process Reports (PYUGEN)
XML Publisher for report generation
Payroll Calculation Engine
Payroll Data Extract processes

Version-Specific Considerations

Between 12.1.1 and 12.2.2:

12.2.2 may include additional columns for enhanced reporting features
Integration with Oracle Business Intelligence may be more robust in 12.2.2
12.2.2 likely includes improved XML handling capabilities

Maintenance Considerations

Changes should be made through Oracle Payroll screens, not direct SQL
Effective-dating requires careful management of date ranges
Custom mappings should be thoroughly tested before production use
Table is typically maintained via Payroll Administration functions

Common Use Cases

Configuring custom payroll report outputs
Mapping legacy report formats to new standards
Supporting multi-country payroll reporting requirements
Generating regulatory compliance 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: 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: 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: PAYJPFLI_XML 12.2.2
product: PAY - Payroll , user_name: Payroll Report (Final Notice of Fixed Labor Ins Fee) (XML) , description: Payroll Report (Final Notice of Fixed Labor Ins Fee) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PAYJPFLI_XML 12.1.1
product: PAY - Payroll , user_name: Payroll Report (Final Notice of Fixed Labor Ins Fee) (XML) , description: Payroll Report (Final Notice of Fixed Labor Ins Fee) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: FI_TRADE_UNION_FEE_TYPE 12.2.2
product: PAY - Payroll , meaning: Trade Union Fees Type , description: Trade Union Fees Type ,
Lookup Type: FI_TRADE_UNION_FEE_TYPE 12.1.1
product: PAY - Payroll , meaning: Trade Union Fees Type , description: Trade Union Fees Type ,
Lookup Type: FR_DADS_WORK_CONTRACT_CODE 12.2.2
product: PAY - Payroll , meaning: Work Contract Code for DADS-U ,
Table: PAY_REPORT_FORMAT_MAPPINGS_F 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_REPORT_FORMAT_MAPPINGS_F, object_name:PAY_REPORT_FORMAT_MAPPINGS_F, status:VALID, product: PAY - Payroll , description: Maps a report for a given jurisdiction to the fixed format defined for the magnetic tape. , implementation_dba_data: HR.PAY_REPORT_FORMAT_MAPPINGS_F ,
Table: PAY_REPORT_FORMAT_MAPPINGS_F 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_REPORT_FORMAT_MAPPINGS_F, object_name:PAY_REPORT_FORMAT_MAPPINGS_F, status:VALID, product: PAY - Payroll , description: Maps a report for a given jurisdiction to the fixed format defined for the magnetic tape. , implementation_dba_data: HR.PAY_REPORT_FORMAT_MAPPINGS_F ,
Lookup Type: PAY_MX_IDW_TYPES 12.1.1
product: PAY - Payroll , meaning: Types for Integrated Daily Wages for Mexico Payroll , description: Types for Integrated Daily Wages for Mexico Payroll ,
Table: PAY_MAGNETIC_BLOCKS 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_MAGNETIC_BLOCKS, object_name:PAY_MAGNETIC_BLOCKS, status:VALID, product: PAY - Payroll , description: Driving table for fixed format version of the magnetic tape process. , implementation_dba_data: HR.PAY_MAGNETIC_BLOCKS ,
Lookup Type: FR_DADS_WORK_CONTRACT_CODE 12.1.1
product: PAY - Payroll , meaning: Work Contract Code for DADS-U ,
Lookup Type: PAY_MX_IDW_TYPES 12.2.2
product: PAY - Payroll , meaning: Types for Integrated Daily Wages for Mexico Payroll , description: Types for Integrated Daily Wages for Mexico Payroll ,
Table: PAY_MAGNETIC_BLOCKS 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_MAGNETIC_BLOCKS, object_name:PAY_MAGNETIC_BLOCKS, status:VALID, product: PAY - Payroll , description: Driving table for fixed format version of the magnetic tape process. , implementation_dba_data: HR.PAY_MAGNETIC_BLOCKS ,
Table: PAY_MAGNETIC_RECORDS 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_MAGNETIC_RECORDS, object_name:PAY_MAGNETIC_RECORDS, status:VALID, product: PAY - Payroll , description: Controls the detailed formatting of the fixed format version of the magnetic tape process. , implementation_dba_data: HR.PAY_MAGNETIC_RECORDS ,
Table: PAY_MAGNETIC_RECORDS 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_MAGNETIC_RECORDS, object_name:PAY_MAGNETIC_RECORDS, status:VALID, product: PAY - Payroll , description: Controls the detailed formatting of the fixed format version of the magnetic tape process. , implementation_dba_data: HR.PAY_MAGNETIC_RECORDS ,
Lookup Type: MX_INSURANCE_TYPES 12.1.1
product: PAY - Payroll , meaning: MX_INSURANCE_TYPES , description: Insurance types for Mexican social security quotas ,
Lookup Type: MX_INSURANCE_TYPES 12.2.2
product: PAY - Payroll , meaning: MX_INSURANCE_TYPES , description: Insurance types for Mexican social security quotas ,