Payroll Costing Results Report

Use the Payroll Costing Results Report to view and verify the costing results for a costing process or the costing entries of a payroll run.

This report uses the extracts-based architecture to handle large volumes of data.

The report uses delivered user entities and database items so you can write to your own extracts to query the costing results.

Submit the Run Payroll Costing Results Report. Before running this report, submit one or more processes that generate costing results.

User Entities

A user entity is a logical entity associated with a data group defined using the HCM Extracts feature, a flexible tool for generating data files and reports. This table describes the user entities related to costing results and the type of data they extract.

User Entity

Description

ORA_PAY_COST_RESULT_UE

Extracts the detailed costing results.

ORA_PAY_COST_SUMMARY_UE

Extracts the summary of the costing results.

ORA_PAY_COST_ALLOCATION_ACCOUNT_UE

Extracts the individual costing segment information.

Report Parameters

The parameter values determine which records to include in the report. Many parameters are self-explanatory. The following parameters have special meaning in the context of this report.

Scope

This parameter determines the level of detail in the report. You can select one of two values for the Scope parameter, as shown in this table.

Scope

Description

When to Use

Summary

Shows the account numbers and the net credit and debit amounts for transferring and posting to general ledger.

Select this scope to create a Microsoft Excel file for your third-party general ledger provider.

Detail

Shows a breakdown of the costing at the element entry, employee, and other levels where costing is calculated.

Select this scope to:

  • Review individual entries, such as the results of distributed or allocated costing.

  • Analyze entries to an invalid account number.

Process Start Date and Process End Date

The date parameters determine which records to process in a specified time frame. The Process Start Date specifies the first effective date of the payroll process that generates costing results to include in the report. The Process End Date specifies the last effective date.

Typically, you specify the start date and end dates of the current payroll period or accounting period. You may also specify the start and end dates of a previous payroll period to identify which payroll period to use for your partial period accruals.

To report the results you want to view, the time period defined by the start and end dates must include the effective date of the process. These processes use the process date as the effective date:

  • Cost adjustments

  • Costing of balance adjustments

  • Partial period accruals

  • Payroll calculations

  • Retroactive pay calculations

  • QuickPay calculations, voids, and reversals

All other processes that generate costing results use the process end date as the effective date.

Process

The name of a process that generates costing results.

By default, the report generates results on all costing processes within a specified time period. Select a single process, such as retroactive costing, to confirm the results of updates made to costing setups before transferring the results to the general ledger.

Process Configuration Group

Select the process configuration group, if you have defined one. A process configuration group is used to provide sets of processing parameters, primarily related to logging and performance. If you don't select a process configuration group, the application uses the parameters in the default group.

Consolidation Group

Select the consolidation group specified for a payroll definition. Specify this parameter to view costing results for all payrolls that are included in this consolidation group. For example, if your weekly payrolls share the same consolidation group, you can review the results of cost adjustments before transferring their results to general ledger.

Location

Select a single work location, or all work locations. The report output lists the payroll relationship records based on a person's assignment location. The location is listed with the other parameters, but not on the results.

Payroll Relationship Group

Select the payroll relationship group name, if you have defined one. Payroll relationship groups limit the persons processed for payroll, data entry, and reporting. For example, you can create a group to process the report for terminated employees.

Note:

Use the Object Groups to define a process configuration group, consolidation group, or payroll relationship group, before you can select it here.

Person Name

Select a person name to view the costing results for a specific person. This parameter is only available for detailed reports.

Results Reported

Use this parameter to filter and view the report results for smaller volumes of data, thereby enhancing the report performance. Here are the values you can select.

Value

Description

Payroll process costing results

The report includes the costing results of payroll processes, such as calculate payroll, QuickPay, and reversals.

Payment process cost results

The report includes the costing results of payment processes, such as costing of payments.

Payroll and payment process cost results

The report includes the costing results of both payroll and payment processes.

Report Category

Use this parameter to generate the report output in the Excel or text format.

Report Results

The report separates the displayed values using a pipe delimiter when:

  • A person has multiple assignments, and

  • The costing result for an element at the payroll relationship level includes more than one value for a parameter.

For example, if a person has one payroll relationship and two assignments to different departments, the costing report lists the costing result for the deduction. The report also shows the department names separated using a pipe delimiter.