How do I load regional pay data for day data reporting?

How you load your hours and earnings info to the storage table depends on your Oracle Fusion implementation.

You can skip this step if you are an Oracle Fusion Global Payroll customer who implemented on the reporting year.

What you can do Who can do it How you do it

What you can do	Who can do it	How you do it
Create a `PayrollInterfaceInbound.dat` file, and load it using HDL.	Oracle Fusion Global HR-only customers Oracle Fusion Global Payroll customers who have incomplete hours or earnings info for the reporting year Oracle Fusion Global Payroll customers who implemented in the middle of the reporting year	To load your earnings, hours and Total Annual Weeks Worked data with HDL, you must first build the `PayrollInterfaceInbound.dat` file. Include columns for Person, Total Wages, Total Hours, and Total Annual Weeks Worked. You can also use the HDL process to change select data. For further info, see BI Publisher Reports for Use with HCM Data Loader (KB96684) on My Oracle Support. This document includes a sample upload file to help you get started. Note: The Load Hours and Earnings Data for Reporting process overrides the data in the storage table. If there is no data in table, it adds it. The process captures all active employees in the year you select. When you run the Regional Pay Data Report, it selects only those employees from this snapshot period.
Run the Load Hours and Earnings Data for Reporting flow. To load the balances for the current year, set the submission year appropriately.	Oracle Fusion Global Payroll customers who implemented as of the first payroll run of the reporting year	To load your earnings and hours data with the Load Hours and Earnings Data for Reporting flow: From My Client Groups, click Payroll. Click Submit a Flow. Select your US legislative data group (LDG). Search for and run Load Hours and Earnings Data for Reporting. For further info, see Load Hours and Earnings Data for Reporting for the US.

Create a PayrollInterfaceInbound.dat file, and load it using HDL.

Oracle Fusion Global HR-only customers
Oracle Fusion Global Payroll customers who have incomplete hours or earnings info for the reporting year
Oracle Fusion Global Payroll customers who implemented in the middle of the reporting year

To load your earnings, hours and Total Annual Weeks Worked data with HDL, you must first build the PayrollInterfaceInbound.dat file. Include columns for Person, Total Wages, Total Hours, and Total Annual Weeks Worked. You can also use the HDL process to change select data.

For further info, see BI Publisher Reports for Use with HCM Data Loader (KB96684) on My Oracle Support. This document includes a sample upload file to help you get started.

Note:

The Load Hours and Earnings Data for Reporting process overrides the data in the storage table. If there is no data in table, it adds it.

The process captures all active employees in the year you select. When you run the Regional Pay Data Report, it selects only those employees from this snapshot period.

Run the Load Hours and Earnings Data for Reporting flow.

To load the balances for the current year, set the submission year appropriately.

Oracle Fusion Global Payroll customers who implemented as of the first payroll run of the reporting year

To load your earnings and hours data with the Load Hours and Earnings Data for Reporting flow:

From My Client Groups, click Payroll.
Click Submit a Flow.
Select your US legislative data group (LDG).
Search for and run Load Hours and Earnings Data for Reporting.

For further info, see Load Hours and Earnings Data for Reporting for the US.