How do I feed balances for pay data reporting?

Pay data reporting uses two balances for tracking employee earnings and hours. Before you can load their data to the storage table, configure their balance feeds.

Skip this step if you're not an Oracle Fusion Global Payroll customer.

Note:

If you perform a balance initialization that includes these balances, consider providing the Calculation Breakdown ID and Tax Reporting Unit (TRU) contexts for them.

Start the Balance Definitions task.

Search for and select the following balances. Configure the feeds appropriately.

Balance name	What you need to do
Regional Pay Data Employee Hours	For each earnings element: In Regional Pay Data, click Balance Feeds. In Balance Feeds by Element, click Create. Select the element's Results indirect element. Select Hours Calculated as the input value. Select Add. Click Save, and repeat for the next Earnings element. Click Submit. If you don't complete these steps, the storage table records the employees' hours as 0.
Regional Pay Data Employee Earnings	For each earnings element: In Regional Pay Data, click Balance Feeds. In Balance Feeds by Element, click Create. Select the element's Results indirect element. Select Earnings Calculated as the input value. Select Add. Click Save, and repeat for the next Earnings element. Click Submit. If you don't complete these steps, the storage table records the employees' earnings as $0. In this case, the Load Hours and Earnings Data for Reporting flow uses the US_MEDICARE_REDUCED_SUBJECT_WITHHOLDABLE balance for the employee earnings in W-2 Box-5.

Balance name

What you need to do

Regional Pay Data Employee Hours

For each earnings element:

In Regional Pay Data, click Balance Feeds.
In Balance Feeds by Element, click Create.
Select the element's Results indirect element.
Select Hours Calculated as the input value.
Select Add.
Click Save, and repeat for the next Earnings element.
Click Submit.

If you don't complete these steps, the storage table records the employees' hours as 0.

Regional Pay Data Employee Earnings

For each earnings element:

In Regional Pay Data, click Balance Feeds.
In Balance Feeds by Element, click Create.
Select the element's Results indirect element.
Select Earnings Calculated as the input value.
Select Add.
Click Save, and repeat for the next Earnings element.
Click Submit.

If you don't complete these steps, the storage table records the employees' earnings as $0.

In this case, the Load Hours and Earnings Data for Reporting flow uses the US_MEDICARE_REDUCED_SUBJECT_WITHHOLDABLE balance for the employee earnings in W-2 Box-5.