Balance Initialization Data - Payroll Extracts

Summary:

Fetching data from balance loads in balance group reports.

Content (required):

Hello,

We are building a payroll report using HCM extracts. Using a combination of balance groups, balance groups usages and the extract we were able to fetch data for the pay periods where payroll is run.

However, when running the report for balance data that has been initialized via a balance load, the report does not return any data. We've narrowed it down to ORA_BALANCE_GROUP_USAGE_REL_LEVEL_UE which contains a join on pay_action_contexts.tax_unit_id which isn't available on the loaded data.