Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject area

Summary:

Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject area

Content (required):

We have payroll balance data for an employee in a pay period but unable to get the values through "Payroll - Payroll Balances Real Time" subject area. This is happening only for few employees in a few periods and for the remaining periods it is showing exact values with the application for the same employees too. We are not sure why we are not getting balance value for the same employees. If we hardcode and run for the OTBI report then it is throwing error. Attached analysis XML for your reference.